{"product_id":"n8n-workflow-generate-linkedin-posts-with-gemini-sheets","title":"n8n Workflow: Generate LinkedIn Posts with Gemini + Sheets","description":"\u003ch3\u003eGenerate 3 high-performing LinkedIn post options with Google Gemini + log results to Google Sheets\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow takes your bullet points via a webhook, uses \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e to generate \u003cstrong\u003ethree LinkedIn post variations\u003c\/strong\u003e, scores them for performance, saves everything in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, and returns an \u003cstrong\u003eHTML page\u003c\/strong\u003e showing the recommended post plus all alternatives.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives input\u003c\/strong\u003e: A POST request hits the \u003cstrong\u003ewebhook\u003c\/strong\u003e with \u003cem\u003ebullet_points\u003c\/em\u003e, \u003cem\u003etone\u003c\/em\u003e, \u003cem\u003epost_type\u003c\/em\u003e, and an optional \u003cem\u003eauthor_name\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes and configures\u003c\/strong\u003e: The workflow normalizes fields and sets the target Google Sheets document ID and worksheet name (including an expected worksheet named \u003cstrong\u003e“Posts”\u003c\/strong\u003e).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates exactly three variations\u003c\/strong\u003e: Using Google Gemini, it creates \u003cstrong\u003ethree distinct LinkedIn post drafts\u003c\/strong\u003e from your bullet points and options.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScores each variation\u003c\/strong\u003e: Gemini is then used again to score each draft on \u003cstrong\u003ehook strength\u003c\/strong\u003e, \u003cstrong\u003ereadability\u003c\/strong\u003e, and \u003cstrong\u003eengagement potential\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSelects a recommendation\u003c\/strong\u003e: It totals the three scores per variation, selects the highest-scoring version as the \u003cstrong\u003erecommended post\u003c\/strong\u003e, and prepares a breakdown for output.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLogs to Google Sheets\u003c\/strong\u003e: Appends the generated variations, totals, input metadata, and the recommended index into a worksheet.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReturns HTML output\u003c\/strong\u003e: Responds with a formatted HTML page showing the recommended post and all three variations with their scores.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSaaS operators turning product updates (bullet points) into LinkedIn posts in a consistent tone.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers building a repeatable “content draft → evaluation → storage” pipeline using n8n.\u003c\/li\u003e\n  \u003cli\u003eTeams testing different post types and choosing the best-performing draft automatically.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNodes \/ components\u003c\/strong\u003e: set, code, webhook, sticky note, Google Sheets, respond to webhook.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations\u003c\/strong\u003e: Google Gemini (attached to both generation and scoring steps) and Google Sheets OAuth2.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets setup\u003c\/strong\u003e: Create a worksheet named \u003cstrong\u003e“Posts”\u003c\/strong\u003e (or update the workflow) with headers including \u003cem\u003egenerated_at\u003c\/em\u003e, \u003cem\u003ebullet_points\u003c\/em\u003e, \u003cem\u003etone\u003c\/em\u003e, \u003cem\u003epost_type\u003c\/em\u003e, \u003cem\u003evariation_1\u003c\/em\u003e, \u003cem\u003escore_1\u003c\/em\u003e, \u003cem\u003evariation_2\u003c\/em\u003e, \u003cem\u003escore_2\u003c\/em\u003e, \u003cem\u003evariation_3\u003c\/em\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46192856596659,"sku":"N8N-20533","price":52.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/jE8aw6AmahDJzZqn2sZaD_YLpWUNRx.png?v=1791537496","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-generate-linkedin-posts-with-gemini-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}