{"product_id":"gpt-4-gmail-outreach-automation-with-google-sheets-tracking","title":"GPT-4 Gmail Outreach Automation with Google Sheets Tracking","description":"\u003ch3\u003eGPT-4 Gmail Outreach Automation with Google Sheets Tracking — personalized emails, sent at scale, with reply-based lead updates\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow pulls leads from \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, generates personalized \u003cstrong\u003eGPT-4\u003c\/strong\u003e HTML outreach emails, sends them via \u003cstrong\u003eGmail\u003c\/strong\u003e, then monitors the Gmail thread for replies—updating booking status and reply details back into your spreadsheet.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eManually start\u003c\/strong\u003e the workflow (you can trigger it whenever you’re ready to run a batch).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRead and validate lead rows\u003c\/strong\u003e from your Google Sheets. If a lead’s email address is invalid, it logs the record to a separate Google Sheets tab.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFilter out already-booked leads\u003c\/strong\u003e by checking \u003cem\u003eBooking Status\u003c\/em\u003e; rows marked \u003cstrong\u003eBOOKED\u003c\/strong\u003e are skipped.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerate outreach content with OpenAI (GPT-4)\u003c\/strong\u003e: for each remaining lead, the workflow sends lead details to OpenAI and expects a JSON response containing an email \u003cstrong\u003esubject\u003c\/strong\u003e and \u003cstrong\u003eHTML body\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSend via Gmail\u003c\/strong\u003e and store the resulting \u003cstrong\u003eGmail thread ID\u003c\/strong\u003e for follow-up tracking.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCheck for replies\u003c\/strong\u003e: after waiting briefly, it fetches the sent Gmail thread and looks for a reply snippet that contains \u003cstrong\u003e“Yes”\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpdate Google Sheets\u003c\/strong\u003e: if “Yes” is detected, it extracts reply details and sets the lead to \u003cstrong\u003eBOOKED\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSend a follow-up if needed\u003c\/strong\u003e: if no qualifying reply is found, it sends a follow-up email, waits again, rechecks the thread, and either records reply details or marks the lead as \u003cstrong\u003eDeclined\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSaaS teams running \u003cstrong\u003eoutreach campaigns\u003c\/strong\u003e and tracking outcomes in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers needing a \u003cstrong\u003ereply-driven\u003c\/strong\u003e lead status workflow in n8n.\u003c\/li\u003e\n  \u003cli\u003eOperators who want \u003cstrong\u003eGPT-4 personalization\u003c\/strong\u003e while keeping all tracking centralized in Sheets.\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\u003c\/strong\u003e (source leads + outreach-tracking destination, including an invalid-email logging tab)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGmail\u003c\/strong\u003e with OAuth2 (send email, retrieve thread by thread ID)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOpenAI \/ GPT-4\u003c\/strong\u003e to generate subject + HTML body from lead data\u003c\/li\u003e\n  \u003cli\u003en8n nodes referenced: \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003ewait\u003c\/strong\u003e, \u003cstrong\u003egmail\u003c\/strong\u003e, and a \u003cstrong\u003esticky note\u003c\/strong\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003e\u003cstrong\u003eSetup note:\u003c\/strong\u003e add Google Sheets credentials for both spreadsheets, update document IDs and tab names, add Gmail OAuth2, and adjust the initial recipient settings as required.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45895369752755,"sku":"N8N-18667","price":24.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/FXKlDoBAMl4qgmnZtsRSr_D8Kv2ILv.png?v=1787648758","url":"https:\/\/buyflowscripts.com\/products\/gpt-4-gmail-outreach-automation-with-google-sheets-tracking","provider":"N8N Commerce","version":"1.0","type":"link"}