{"product_id":"n8n-daily-google-sheets-lead-follow-up-digest-to-gmail","title":"n8n: Daily Google Sheets Lead Follow-Up Digest to Gmail","description":"\u003ch3\u003eDaily Google Sheets Lead Follow-Up Digest → Automatically Sent to Gmail (n8n)\u003c\/h3\u003e\n\u003cp\u003eThis n8n automation generates a \u003cstrong\u003edaily Gmail HTML digest\u003c\/strong\u003e of leads in your \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e tracker that need follow-up—so you can see \u003cstrong\u003eoverdue leads\u003c\/strong\u003e, \u003cstrong\u003edue today\u003c\/strong\u003e, and \u003cstrong\u003eincomplete records\u003c\/strong\u003e in one place. A single configured owner receives the message, with preview controls to verify results before delivery.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns daily at 09:00\u003c\/strong\u003e using a Schedule Trigger (workflow timezone), and includes a Manual Preview trigger to inspect output before enabling email delivery.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCollects and validates settings\u003c\/strong\u003e (spreadsheet ID, tab name, owner email, and delivery options) before processing.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads your lead tracker\u003c\/strong\u003e from Google Sheets (lead ID, name, status, follow-up date, and next action).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGroups leads\u003c\/strong\u003e into categories like \u003cstrong\u003eoverdue\u003c\/strong\u003e, \u003cstrong\u003edue today\u003c\/strong\u003e, and \u003cstrong\u003eneeds attention\u003c\/strong\u003e; future leads and closed leads are counted but excluded from the action list.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePrevents bad data\u003c\/strong\u003e:\n    \u003cul\u003e\n      \u003cli\u003e\n\u003cstrong\u003eIdentical duplicate records\u003c\/strong\u003e are ignored with a warning.\u003c\/li\u003e\n      \u003cli\u003e\n\u003cstrong\u003eConflicting lead IDs\u003c\/strong\u003e stop processing so you can correct the sheet.\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDelivers a single HTML digest\u003c\/strong\u003e to Gmail (best-effort daily delivery), records Gmail’s returned \u003cem\u003emessage ID\u003c\/em\u003e, and keeps preview\/skipped results in the execution output.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLeaves next actions for you\u003c\/strong\u003e: you contact customers manually and update their next actions in the sheet.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSaaS operators who want a \u003cstrong\u003edaily follow-up routine\u003c\/strong\u003e for leads captured in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers needing a \u003cstrong\u003ereliable n8n workflow\u003c\/strong\u003e with validation for duplicates and conflicting IDs.\u003c\/li\u003e\n  \u003cli\u003eTeams that prefer \u003cstrong\u003eone-owner Gmail summaries\u003c\/strong\u003e instead of chasing task lists throughout the day.\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 \/ logic:\u003c\/strong\u003e Schedule Trigger, Manual Preview trigger, \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e (read leads), \u003cstrong\u003eCode\u003c\/strong\u003e, \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003egmail\u003c\/strong\u003e, \u003cstrong\u003esticky note\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRequired Google Sheets tab headers\u003c\/strong\u003e (must match): \u003ccode\u003elead_id, name, status, follow_up_date, next_action\u003c\/code\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDate format:\u003c\/strong\u003e display dates as \u003ccode\u003eYYY\u003c\/code\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46008766857395,"sku":"N8N-19497","price":55.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/Lfb2Ho-NN2_IqsxT4_Wzd_xrl6dOlx.png?v=1789204221","url":"https:\/\/buyflowscripts.com\/products\/n8n-daily-google-sheets-lead-follow-up-digest-to-gmail","provider":"N8N Commerce","version":"1.0","type":"link"}