{"product_id":"n8n-workflow-weekly-gmail-re-engagement-from-google-sheets-slack","title":"n8n Workflow: Weekly Gmail Re-engagement from Google Sheets + Slack","description":"\u003ch3\u003eRe-engage inactive clients automatically every Monday with Gmail + Google Sheets, and get weekly visibility in Slack\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow scans your Google Sheets client list for contacts inactive for 14+ days, sends a re-engagement email via Gmail, logs the outreach in a second Google Sheets tab, and posts a top-10 weekly summary (with failure alerts) to Slack.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on a schedule:\u003c\/strong\u003e A scheduled trigger starts the workflow every \u003cstrong\u003eMonday at 9:00 AM\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads client data from Google Sheets:\u003c\/strong\u003e It pulls all rows from \u003cstrong\u003eSheet1\u003c\/strong\u003e in the “Client Engagement Automation” spreadsheet.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIdentifies inactive clients:\u003c\/strong\u003e Using the \u003cstrong\u003eLast Activity Date\u003c\/strong\u003e, it flags records older than \u003cstrong\u003e14 days\u003c\/strong\u003e and keeps only those needing attention.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSplits contacts for individual outreach:\u003c\/strong\u003e The inactive list is split into one item per contact so each client receives a dedicated email.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends re-engagement emails:\u003c\/strong\u003e For each flagged contact, it sends an email through \u003cstrong\u003eGmail\u003c\/strong\u003e (with customizable subject\/body and sender details).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLogs outreach in Google Sheets:\u003c\/strong\u003e Each contacted client is appended to \u003cstrong\u003eSheet2\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePosts results to Slack:\u003c\/strong\u003e It compiles a Slack message with the total count and lists up to \u003cstrong\u003e10 clients\u003c\/strong\u003e, then posts to your chosen channel.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAlerts on failures:\u003c\/strong\u003e If the workflow execution fails, it sends a separate \u003cstrong\u003eSlack\u003c\/strong\u003e alert to the error channel.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSaaS teams re-contacting customers or leads who haven’t engaged in the last two weeks.\u003c\/li\u003e\n  \u003cli\u003eSales\/CS ops using n8n to keep outreach consistent without manual spreadsheet updates.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers needing a reliable weekly re-engagement pipeline with audit logging and Slack reporting.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNodes \/ tools:\u003c\/strong\u003e scheduled trigger, \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003egmail\u003c\/strong\u003e, \u003cstrong\u003eslack\u003c\/strong\u003e, \u003cstrong\u003esplit out\u003c\/strong\u003e, and \u003cstrong\u003esticky note\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets requirements:\u003c\/strong\u003e “Client Engagement Automation” with \u003cstrong\u003eSheet1\u003c\/strong\u003e columns including “First Name”, “Last Name”, “Email”, “Phone”, “Company”, and “Last Activity Date”.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSlack reporting:\u003c\/strong\u003e weekly summary to a selected channel; execution-failure alerts to a designated error channel.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45878613639347,"sku":"N8N-18544","price":78.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/2gI6LYNWLKGdnnJLMU6UJ_BnPgd0ed.png?v=1787389732","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-weekly-gmail-re-engagement-from-google-sheets-slack","provider":"N8N Commerce","version":"1.0","type":"link"}