{"product_id":"automate-google-sheets-lead-enrichment-with-gpt-4o-mini-gmail-draft","title":"Automate Google Sheets Lead Enrichment with GPT-4o-mini \u0026 Gmail Draft","description":"\u003ch3\u003eTurn new Google Sheets leads into ready-to-send Gmail drafts—automatically\u003c\/h3\u003e\n\u003cp\u003eThis n8n automation workflow continuously watches your \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e for new or updated lead rows, uses \u003cstrong\u003eGPT-4o-mini\u003c\/strong\u003e to generate a short company summary and automation value proposition, and then creates a personalized \u003cstrong\u003eGmail draft\u003c\/strong\u003e. Finally, it writes the AI output and draft status back to your sheet—saving you time while keeping outreach consistent.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePolls Google Sheets every minute\u003c\/strong\u003e for new or updated rows in the selected worksheet.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eExtracts lead fields\u003c\/strong\u003e—including the lead’s \u003cstrong\u003eCompany\u003c\/strong\u003e and \u003cstrong\u003eIndustry\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates AI content with GPT-4o-mini\u003c\/strong\u003e: a \u003cstrong\u003etwo-sentence company summary\u003c\/strong\u003e plus an \u003cstrong\u003eautomation-focused value proposition\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCreates a Gmail draft email\u003c\/strong\u003e addressed to the lead, using the AI-generated text and a \u003cstrong\u003ecompany-specific subject line\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpdates the originating row\u003c\/strong\u003e in Google Sheets with the \u003cstrong\u003eAI Summary\u003c\/strong\u003e and sets \u003cstrong\u003eStatus\u003c\/strong\u003e to \u003cstrong\u003e“Draft Created.”\u003c\/strong\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSaaS sales ops:\u003c\/strong\u003e Enrich and draft outreach emails for every newly imported lead without manual copywriting.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAutomation engineers:\u003c\/strong\u003e Validate a reliable lead-enrichment pipeline that ties \u003cem\u003eGoogle Sheets → OpenAI → Gmail → Sheets\u003c\/em\u003e together.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFounder-led outreach:\u003c\/strong\u003e Maintain a structured lead tracker while generating tailored drafts for each company and industry.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets Trigger\u003c\/strong\u003e to detect new\/updated rows on a 1-minute polling schedule.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOpenAI (GPT-4o-mini)\u003c\/strong\u003e via \u003cstrong\u003en8nn8n-nodes-langchainopenai\u003c\/strong\u003e to produce the two-sentence summary and value proposition.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGmail\u003c\/strong\u003e integration to draft the personalized outreach email.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets update action\u003c\/strong\u003e to write back \u003cstrong\u003eAI Summary\u003c\/strong\u003e and set \u003cstrong\u003eStatus\u003c\/strong\u003e to “Draft Created.”\u003c\/li\u003e\n  \u003cli\u003eExample required columns include: \u003cstrong\u003eFirstName\u003c\/strong\u003e, \u003cstrong\u003eCompany\u003c\/strong\u003e, \u003cstrong\u003eIndustry\u003c\/strong\u003e, \u003cstrong\u003eStatus\u003c\/strong\u003e, and \u003cstrong\u003eAI Summary\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cstrong\u003eSetup tip:\u003c\/strong\u003e Add valid credentials for Google Sheets, OpenAI, and Gmail in n8n, then select your target spreadsheet and worksheet in both the trigger and update steps.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46094191263923,"sku":"N8N-19931","price":28.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/sGW4OkElpoTmqmUUryl-x_zvjGq3fv.png?v=1790413974","url":"https:\/\/buyflowscripts.com\/products\/automate-google-sheets-lead-enrichment-with-gpt-4o-mini-gmail-draft","provider":"N8N Commerce","version":"1.0","type":"link"}