{"product_id":"n8n-workflow-gemini-google-sheets-for-linkedin-posts","title":"n8n Workflow: Gemini + Google Sheets for LinkedIn Posts","description":"\u003ch3\u003eTurn bullet points into 3 scored LinkedIn post options with Gemini + Google Sheets (in n8n)\u003c\/h3\u003e\n\u003cp\u003eRunning an \u003cstrong\u003en8n workflow\u003c\/strong\u003e shouldn’t stop at drafting—this one takes your bullet points from an \u003cstrong\u003en8n Form trigger\u003c\/strong\u003e, uses \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e to generate \u003cem\u003eexactly three\u003c\/em\u003e LinkedIn post variations, scores each one for quality, recommends the best version, logs everything to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, and returns a formatted \u003cstrong\u003eHTML\u003c\/strong\u003e results page.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCollects inputs:\u003c\/strong\u003e Receives \u003cem\u003ebullet points\u003c\/em\u003e, a \u003cem\u003etone\u003c\/em\u003e, a \u003cem\u003epost type\u003c\/em\u003e, and an optional \u003cem\u003esign-off name\u003c\/em\u003e from an n8n Form submission.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eStandardizes and routes data:\u003c\/strong\u003e Normalizes the incoming fields and sets the target Google Sheets \u003cstrong\u003edocument ID\u003c\/strong\u003e and \u003cstrong\u003esheet name\u003c\/strong\u003e for later logging.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates 3 variations:\u003c\/strong\u003e Uses \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e to create \u003cstrong\u003ethree distinct LinkedIn post variations\u003c\/strong\u003e based on your inputs.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScores each variation independently:\u003c\/strong\u003e Runs Gemini again to evaluate each option for \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\u003eRecommends the best:\u003c\/strong\u003e Totals the scores per variation, selects the highest-scoring post, and prepares all results for output.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLogs to Google Sheets:\u003c\/strong\u003e Appends bullet points, variations, scores, and the \u003cstrong\u003erecommended index\u003c\/strong\u003e to a worksheet.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReturns an HTML results page:\u003c\/strong\u003e Displays the recommendation plus all three scored variations.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eGenerate LinkedIn posts from weekly content bullets for \u003cstrong\u003eSaaS operators\u003c\/strong\u003e and founders.\u003c\/li\u003e\n  \u003cli\u003eUse Gemini scoring to quickly choose the strongest draft before publishing.\u003c\/li\u003e\n  \u003cli\u003eMaintain a content “source of truth” by archiving every generated set in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes:\u003c\/strong\u003e set, code, sticky note, form trigger, google sheets, respond to webhook.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAI integrations:\u003c\/strong\u003e Two \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e nodes—one for generation and one for scoring.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRequired sheet headers:\u003c\/strong\u003e generated_at, bullet_points, tone, post_type, variation_1, score_1, variation_2, score_2, variation_3, score_3, recommended_index.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSetup:\u003c\/strong\u003e Add Gemini (PaLM) API credentials to both Gemini nodes, add Google Sheets OAuth credentials, and replace \u003cstrong\u003eREPLACE_WITH_GOOGLE\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46094088700083,"sku":"N8N-19955","price":50.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/USJgri8HhQt5QMA9elmjK_0Rz5UDO5.png?v=1790413389","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-gemini-google-sheets-for-linkedin-posts","provider":"N8N Commerce","version":"1.0","type":"link"}