Turn blog posts into ready to publish LinkedIn copy. Ideal for content and social teams who publish on Ghost and want fast, consistent social promotion stored in Google Sheets for review and scheduling.

The build pulls recent posts from Ghost, cleans the HTML to plain text, and loops through each article. An AI Agent powered by an OpenAI chat model writes a short LinkedIn message based on the title, link, and cleaned content. Results are merged with the original post data and saved to Google Sheets, including the post ID, title, excerpt, clean content, link, and the AI generated LinkedIn post. This creates one central sheet that your team can edit or move into a scheduling tool.

Setup is simple. Connect your Ghost site, your OpenAI API key, and your Google account for Sheets. Choose how many posts to fetch, tailor the AI system prompt to match your voice, and map columns in Google Sheets. Expect faster turnaround from hours to minutes, more consistent voice, and better tracking of social copy. Great for repurposing evergreen posts, campaign bursts, or new article launches.

• Ghost integration pulls recent articles with full content and metadata.
• Field extraction isolates id, title, excerpt, URL, and feature image.
• Split in Batches processes posts one by one for reliable runs.
• Custom Code removes HTML tags and normalizes spaces for clean text.
• AI Agent with an OpenAI chat model writes a short LinkedIn promo message.
• Merge steps keep clean text and AI output aligned with the correct article.
• Google Sheets append logs id, title, excerpt, clean content, link, and LinkedIn copy.
• Manual trigger supports safe testing before scheduling or scaling.

• Reduce manual writing time from 2 hours to 10 minutes per post
• Automate up to 90 percent of repetitive social copy tasks
• Improve consistency of tone across all LinkedIn posts
• Connect Ghost, OpenAI, and Google Sheets in one flow
• Create a single source of truth for social copy and links
• Scale to handle multiple posts at once with batching

1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
2. You'll need accounts with Ghost, OpenAI and Google Sheets. See the Tools Required section above for links to create accounts with these services.
3. In the Ghost node, double click the node, then on the 'Credential to connect with' dropdown, click 'Create new credential' and follow the on screen instructions. Provide your Ghost Admin URL and API key from your Ghost settings.
4. Set the Ghost node to Get All and choose the number of posts to fetch. Start with 3 to validate the flow.
5. Open the Set node for post fields and confirm mappings for id, title, excerpt, url, content, and feature image.
6. Review the Clean HTML Code node. It strips tags and extra spaces. Keep as is unless your content needs special handling.
7. Open the OpenAI Chat Model node. Create a new OpenAI credential using your API key from the OpenAI account API page. Name credentials clearly, for example OpenAI Prod.
8. Open the AI Agent node. Link it to the OpenAI Chat Model. Edit the system message to match your brand voice and any posting rules.
9. Check the Merge nodes. They combine clean text, AI output, and original fields. No changes are needed for basic use.
10. In the Google Sheets node, create a new credential. Use Google OAuth in n8n Cloud and approve access to Sheets with the correct Google account.
11. Select your spreadsheet and target sheet. Map columns to id, title, content, excerpt, clean_content, linkedin_post, and link. Create headers in the sheet if they do not exist.
12. Run the workflow with the manual trigger. Confirm rows appear in Sheets with the AI generated LinkedIn text. If rows are empty, check field mappings and the AI Agent output.
13. Troubleshoot common issues: 401 errors on Ghost mean API key or URL is wrong. OpenAI errors often mean a bad API key or model not allowed. Sheet append issues usually come from missing column headers.