Publish AI-written newsletters and LinkedIn posts from WordPress with Gemini, Google Sheets and Gmail
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 13 nodes and runs on a schedule (every day). Along the way it connects Google Gemini Chat Model, LinkedIn, Google Sheets and Gmail. It also calls vaguefoundation.com over HTTP.
How it runs
Trigger: On a schedule (every day).
- HTTP Request: calls vaguefoundation.com
- Last ID (Google Sheets): uses Google Sheets
- If: checks a condition and branches into true / false
- Update Last ID (Google Sheets): update
- data cleanse (Code): runs custom JavaScript code
- AI Agent: runs an AI agent, with model: Google Gemini Chat Model
- Format Response (Code): runs custom JavaScript code
- Email List (Google Sheets): uses Google Sheets
- Create a post (LinkedIn): uses LinkedIn
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
…plus 1 more step. See the full node list below.
Services it uses
HTTP calls to: vaguefoundation.com
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (10)
- Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - LinkedIn
n8n-nodes-base.linkedIn - If
n8n-nodes-base.if - Code
n8n-nodes-base.code - Google Sheets
n8n-nodes-base.googleSheets - Gmail
n8n-nodes-base.gmail - Schedule Trigger
n8n-nodes-base.scheduleTrigger - AI Agent
@n8n/n8n-nodes-langchain.agent - HTTP Request
n8n-nodes-base.httpRequest
From the author
How it works This workflow fetches the latest blog post from a WordPress API and checks against a Google Sheets tracker to prevent duplicate processing. If a new post is found, the workflow updates the tracker and cleans the blog data. The cleaned content is…