Auto-Turn Gmail Newsletters into LinkedIn Insight Posts

Gmail emails → OpenAI extract & generate → LinkedIn auto-publish

Who

Content creators, marketers, and business professionals who want to repurpose regular newsletters into LinkedIn posts

You get

Automatically filter emails, extract key points, generate on-brand LinkedIn posts, and publish directly

You need

n8n · gmail · linkedin

Steps

1. Configure Gmail trigger and filter

   Add or modify the Gmail node in n8n, rename it to 'Filter Gmail Newsletter'. Set filters.sender to your newsletter sender address (e.g., [email protected]), operation to getAll, and limit as needed. Configure gmailOAuth2 credentials and authorize. Use the 'When clicking Test workflow' manual trigger for testing.

2. Extract news items with OpenAI

   Add an OpenAI node and rename it to 'Extract News Items'. Select model o3-mini-2025-01-31 (or o3-mini). Enable jsonOutput. Place the following prompt in the messages field; this node reads the email body from Gmail and extracts 5 main news headlines and summaries.

   Execution prompt · Source text。OpenAI node Extract News Items, messages.values[].content field

   Copy prompt

   =Given the following newsletter content, identify and summarize the 5 main news items. Focus on factual updates like new AI tools, product launches, or strategic investments. For each item, extract a headline and provide a concise summary. Please ignore purely promotional sections (e.g., calls to book demos or product advertisements).
   
   <text>
   {{ $json.text }}
   </text>

3. Split out multiple news items

   Add a Split Out node and set fieldToSplitOut to message.content.news_items (the news list field from the previous OpenAI JSON output). This splits the array into individual records, each processed in its own branch.

4. Generate LinkedIn posts with OpenAI

   Add a second OpenAI node and rename it to 'Create LinkedIn Posts'. Use the same model, o3-mini-2025-01-31. Place the following prompt in the messages field; this node receives headline and summary per item and outputs a styled LinkedIn post.

   Execution prompt · Source text。OpenAI node Create LinkedIn Posts, messages.values[].content field

   Copy prompt

   =Using the news item details below:
   
   Headline: {{ $json.headline }}
   Summary: {{ $json.summary }}
   
   Craft a concise, non-promotional LinkedIn post in a smart, deadpan style with subtle humor. Focus on clearly conveying the main points and insights so readers gain practical value. 
   - Break up the text into short paragraphs or bullet points for clarity.
   - Use line breaks where helpful.
   - End with an observation or question that encourages reflection—without being overly salesy or flashy.
   - Keep it under 80 words total.

5. Publish to LinkedIn

   Add a LinkedIn node and rename it to 'Post to LinkedIn'. Set the text field to ={{ $json.message.content }} to reference the generated post from the previous step. Configure linkedInOAuth2Api credentials and confirm the person parameter is your actual LinkedIn profile ID (the template example EI5XKdiMv1 must be replaced). Executing the workflow publishes the post directly to your LinkedIn account.

You are an n8n workflow setup assistant. The user wants to replicate the automation that turns Gmail newsletters into LinkedIn posts. First confirm they have: 1) access to an n8n instance; 2) Gmail OAuth2, OpenAI API, and LinkedIn OAuth2 credentials; 3) a known newsletter sender address. Then guide them to import the template or build nodes manually, checking Gmail filter conditions, OpenAI prompt variable names ($json.text / $json.headline / $json.summary / $json.message.content), and connection order. If they want to change tone, suggest testing a single item in Extract News Items or Create LinkedIn Posts before batch runs.