n8n Workflow: Gemini + Google Sheets for LinkedIn Posts

Turn bullet points into 3 scored LinkedIn post options with Gemini + Google Sheets (in n8n)

Running an n8n workflow shouldn’t stop at drafting—this one takes your bullet points from an n8n Form trigger, uses Google Gemini to generate exactly three LinkedIn post variations, scores each one for quality, recommends the best version, logs everything to Google Sheets, and returns a formatted HTML results page.

What this workflow does

• Collects inputs: Receives bullet points, a tone, a post type, and an optional sign-off name from an n8n Form submission.
• Standardizes and routes data: Normalizes the incoming fields and sets the target Google Sheets document ID and sheet name for later logging.
• Generates 3 variations: Uses Google Gemini to create three distinct LinkedIn post variations based on your inputs.
• Scores each variation independently: Runs Gemini again to evaluate each option for hook strength, readability, and engagement potential.
• Recommends the best: Totals the scores per variation, selects the highest-scoring post, and prepares all results for output.
• Logs to Google Sheets: Appends bullet points, variations, scores, and the recommended index to a worksheet.
• Returns an HTML results page: Displays the recommendation plus all three scored variations.

Use cases

• Generate LinkedIn posts from weekly content bullets for SaaS operators and founders.
• Use Gemini scoring to quickly choose the strongest draft before publishing.
• Maintain a content “source of truth” by archiving every generated set in Google Sheets.

Technical details

• n8n nodes: set, code, sticky note, form trigger, google sheets, respond to webhook.
• AI integrations: Two Google Gemini nodes—one for generation and one for scoring.
• Required sheet headers: generated_at, bullet_points, tone, post_type, variation_1, score_1, variation_2, score_2, variation_3, score_3, recommended_index.
• Setup: Add Gemini (PaLM) API credentials to both Gemini nodes, add Google Sheets OAuth credentials, and replace REPLACE_WITH_GOOGLE.