{"product_id":"reactivate-dormant-leads-with-gmail-google-sheets-sequence","title":"Reactivate Dormant Leads with Gmail + Google Sheets Sequence","description":"\u003ch3\u003eReactivate Dormant Leads Every Morning—Automatically via Gmail + Google Sheets\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow reads your Leads from Google Sheets every day at \u003cstrong\u003e9:00\u003c\/strong\u003e, sends the next message in a \u003cstrong\u003ethree-step Gmail reactivation sequence\u003c\/strong\u003e, then updates each lead’s \u003cstrong\u003etouch count, last contact date, and status\u003c\/strong\u003e back in the same sheet.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on a daily schedule (9:00)\u003c\/strong\u003e to start the reactivation process.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLoads Config values\u003c\/strong\u003e such as \u003cem\u003esender_name\u003c\/em\u003e, \u003cem\u003ebusiness_name\u003c\/em\u003e, \u003cem\u003ebooking_link\u003c\/em\u003e, and \u003cem\u003edays_between_touches\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads all rows\u003c\/strong\u003e from the \u003cstrong\u003eLeads\u003c\/strong\u003e sheet in Google Sheets and filters to keep only leads with:\n    \u003cul\u003e\n      \u003cli\u003eAn \u003cstrong\u003eemail address\u003c\/strong\u003e\n\u003c\/li\u003e\n      \u003cli\u003eNot marked as \u003cstrong\u003ereplied\u003c\/strong\u003e or \u003cstrong\u003eunsubscribed\u003c\/strong\u003e\n\u003c\/li\u003e\n      \u003cli\u003e\u003cstrong\u003eFewer than three touches\u003c\/strong\u003e\u003c\/li\u003e\n      \u003cli\u003eA time gap since \u003cstrong\u003elast_touch_at\u003c\/strong\u003e that is greater than the configured \u003cem\u003edays_between_touches\u003c\/em\u003e\n\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSelects which of the three email templates to send\u003c\/strong\u003e (first, second, or third) based on the current \u003cstrong\u003etouch\u003c\/strong\u003e count.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends the email using Gmail\u003c\/strong\u003e to the matched lead.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpdates the lead row in Google Sheets\u003c\/strong\u003e by incrementing \u003cem\u003etouch\u003c\/em\u003e, setting \u003cem\u003elast_touch_at\u003c\/em\u003e to the current time, and setting \u003cem\u003estatus\u003c\/em\u003e to \u003cem\u003ein sequence\u003c\/em\u003e or \u003cem\u003eclosed\u003c\/em\u003e after the third email.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eKeep a pipeline warm by automatically reactivating leads who haven’t responded.\u003c\/li\u003e\n  \u003cli\u003eRun a controlled follow-up cadence (limited to three touches) using \u003cem\u003edays_between_touches\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003eCentralize lead tracking in Google Sheets while sending via Gmail from your chosen account.\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, gmail, filter, switch, sticky note, google sheets\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e Google Sheets (read leads + update touch\/status fields) and Gmail (send selected email template)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRequired sheet columns:\u003c\/strong\u003e \u003cem\u003eemail\u003c\/em\u003e (used to match rows), \u003cem\u003ename\u003c\/em\u003e, \u003cem\u003einterest\u003c\/em\u003e, \u003cem\u003estatus\u003c\/em\u003e, \u003cem\u003etouch\u003c\/em\u003e, \u003cem\u003elast_touch_at\u003c\/em\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eIdeal for n8n users, automation engineers, and SaaS operators who want an SEO-friendly, reliable Gmail + Google Sheets sequence for reactivation and lead lifecycle tracking.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45950064296115,"sku":"N8N-19164","price":61.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/FvLv_FnviMof3O_0H4xpU_Lz3QQmhe.png?v=1788513159","url":"https:\/\/buyflowscripts.com\/products\/reactivate-dormant-leads-with-gmail-google-sheets-sequence","provider":"N8N Commerce","version":"1.0","type":"link"}