{"product_id":"win-back-drip-email-automation-in-n8n-sheets-smtp","title":"Win-Back Drip Email Automation in n8n: Sheets + SMTP","description":"\u003ch3\u003eWin-Back Drip Email Automation in n8n (Google Sheets + SMTP) — with compliance approval\u003c\/h3\u003e\n\u003cp\u003eAutomate your win-back\/reactivation outreach in n8n: this workflow reads a \u003cstrong\u003e“Win-Back Tracker”\u003c\/strong\u003e in Google Sheets daily and weekly, stages the next email based on time since \u003ccode\u003emarked_cold_at\u003c\/code\u003e, routes each message through a \u003cstrong\u003ecompliance\/guardrail approval\u003c\/strong\u003e step, sends via \u003cstrong\u003eSMTP\u003c\/strong\u003e, and updates your tracker—then emails a weekly status summary to your firm.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDaily (9am):\u003c\/strong\u003e Runs every morning at 9am and pulls lead records from the \u003cstrong\u003eWin-Back Tracker\u003c\/strong\u003e sheet.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eStage calculation:\u003c\/strong\u003e Uses days since \u003ccode\u003emarked_cold_at\u003c\/code\u003e and the configured \u003ccode\u003eWIN_BACK_DRIP_STAGES\u003c\/code\u003e sequence to determine which leads are due for the next drip stage.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePersonalized email build:\u003c\/strong\u003e Generates stage-specific win-back content (subject, text, and HTML) using the lead’s \u003cstrong\u003ename\u003c\/strong\u003e and \u003cstrong\u003epractice area\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCompliance approval check:\u003c\/strong\u003e Sends the draft to a separate compliance\/guardrail workflow and checks whether it’s \u003cem\u003eapproved\u003c\/em\u003e or the recipient has \u003cem\u003eopted out\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSMTP send + tracker update:\u003c\/strong\u003e If approved, sends the drip email via \u003cstrong\u003eSMTP\u003c\/strong\u003e and updates \u003ccode\u003elast_stage_sent\u003c\/code\u003e and \u003ccode\u003elast_sent_at\u003c\/code\u003e for the matching \u003ccode\u003elead_id\u003c\/code\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWeekly (Monday 8am):\u003c\/strong\u003e Summarizes counts (active\/reactivated\/unsubscribed) from Google Sheets and emails a weekly summary to the firm via SMTP.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eMaintain an orderly, time-based reactivation campaign without manual outreach.\u003c\/li\u003e\n  \u003cli\u003eEnsure win-back emails only send after compliance\/guardrail approval (and respect opt-outs).\u003c\/li\u003e\n  \u003cli\u003eGive your firm weekly reporting on pipeline status directly from the tracker.\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 integration:\u003c\/strong\u003e Reads “Win-Back Tracker” (e.g., \u003ccode\u003elead_id\u003c\/code\u003e, \u003ccode\u003eemail\u003c\/code\u003e, \u003ccode\u003estatus\u003c\/code\u003e, \u003ccode\u003emarked_cold_at\u003c\/code\u003e, \u003ccode\u003elast_stage_sent\u003c\/code\u003e).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSMTP email sending:\u003c\/strong\u003e Sends drip emails and the weekly summary.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCompliance\/guardrail workflow:\u003c\/strong\u003e Approval gate before sending; handles opt-outs.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes mentioned:\u003c\/strong\u003e \u003ccode\u003eif\u003c\/code\u003e, \u003ccode\u003ecode\u003c\/code\u003e, \u003ccode\u003eno op\u003c\/code\u003e, \u003ccode\u003eemail send\u003c\/code\u003e, \u003ccode\u003esticky note\u003c\/code\u003e, \u003ccode\u003egoogle sheets\u003c\/code\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eSetup essentials\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eConnect Google Sheets and set \u003ccode\u003eWIN_BACK_TRACKER_SHEET_ID\u003c\/code\u003e to the spreadsheet containing the “Win-Back Tracker” sheet.\u003c\/li\u003e\n  \u003cli\u003eConfigure an SMTP credential and set \u003ccode\u003eFIRM_FROM_EMAIL\u003c\/code\u003e (sender) and \u003ccode\u003eFIRM_EMAIL\u003c\/code\u003e (weekly summary recipient).\u003c\/li\u003e\n  \u003cli\u003eCreate or select the compliance\/guardrail workflow used for approval.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46072079450291,"sku":"N8N-19787","price":55.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/MAz-yeK17Zrc_spzLN0kr_spqv5J0c.png?v=1790068341","url":"https:\/\/buyflowscripts.com\/products\/win-back-drip-email-automation-in-n8n-sheets-smtp","provider":"N8N Commerce","version":"1.0","type":"link"}