Generate and score LinkedIn posts from bullet points with Gemini and Google Sheets
Ready for 3.0What this workflow does
This AI workflow has 11 nodes and runs when an HTTP POST request hits its webhook URL. Along the way it connects Google Gemini Chat Model and Google Sheets.
How it runs
Trigger: When an HTTP POST request hits its webhook URL.
- Set Post Parameters (Edit Fields (Set)): sets 6 fields: bullet_points, tone, post_type…
- Generate Post Variations (Basic LLM Chain): sends a prompt to an LLM, with model: Gemini Generate Variations; output parser: Parse Variations Output
- Score Variations (Basic LLM Chain): sends a prompt to an LLM, with model: Gemini Score Variations; output parser: Parse Scores Output
- Select Best Variation (Code): runs custom JavaScript code
- Append to Google Sheets (Google Sheets): append
- Respond with Results (Respond to Webhook): sends the response back to the webhook caller
Services it uses
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 (8)
- Webhook
n8n-nodes-base.webhook - Edit Fields (Set)
n8n-nodes-base.set - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Code
n8n-nodes-base.code - Google Sheets
n8n-nodes-base.googleSheets - Respond to Webhook
n8n-nodes-base.respondToWebhook
From the author
Quick overview This workflow receives bullet points via a webhook, uses Google Gemini to generate and score three LinkedIn post variations, logs the results to Google Sheets, and returns an HTML page with all versions plus an automatically selected…