{"product_id":"overdue-contact-reminder-digest-sheets-gemini-gmail-n8n","title":"Overdue Contact Reminder Digest (Sheets, Gemini, Gmail) | n8n","description":"\u003ch3\u003eNever let outreach fall off your radar — get an Overdue Contact Reminder Digest generated with Google Sheets, Google Gemini, RSS, and Gmail\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow runs every morning to scan your Google Sheets contact list, detect overdue check-ins, pull relevant recent headlines from Google News RSS, and use Google Gemini to draft personalized outreach—then emails you a single digest via Gmail. No messages are sent to your contacts.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns daily at 8:00\u003c\/strong\u003e and loads configuration values (Google Sheet URL\/tab, recipient email, language, and Google News settings).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads all contacts from Google Sheets\u003c\/strong\u003e (e.g., name, relationship, last_contact, interval_days, interests, notes, active).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFinds overdue follow-ups\u003c\/strong\u003e by normalizing last-contact dates and interest terms, then keeping only active contacts whose follow-up interval has passed.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSearches Google News RSS\u003c\/strong\u003e for recent headlines matching each person’s interests and keeps the top results.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates a warm draft with Google Gemini\u003c\/strong\u003e using the contact context + selected headlines to produce a subject, reason, and short message draft.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAggregates everything into one HTML digest\u003c\/strong\u003e and sends it to you via \u003cstrong\u003eGmail\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSaaS operators\u003c\/strong\u003e who want consistent partner and customer follow-ups without manually searching for updates.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAutomation engineers\u003c\/strong\u003e building a repeatable “outreach queue” workflow inside n8n.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFounders and networking pros\u003c\/strong\u003e who prefer reviewing one digest before contacting people—keeping control over final outreach.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScheduler\u003c\/strong\u003e: runs every morning at \u003cstrong\u003e8:00\u003c\/strong\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e: reads contact records from your specified sheet\/tab\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle News RSS\u003c\/strong\u003e: rss feed read for interest-matched headlines\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Gemini (PaLM)\u003c\/strong\u003e: generates topic selection and message drafts\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes used\u003c\/strong\u003e: \u003cem\u003eset\u003c\/em\u003e, \u003cem\u003efilter\u003c\/em\u003e, \u003cem\u003eaggregate\u003c\/em\u003e, \u003cem\u003esticky note\u003c\/em\u003e, \u003cem\u003erss feed read\u003c\/em\u003e, and \u003cem\u003eGmail\u003c\/em\u003e for sending the digest\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eFor n8n workflows focused on contact management, Gemini-assisted messaging, and Gmail digests, this overdue contact reminder digest gives you relevance, consistency, and time savings.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46132748157107,"sku":"N8N-20191","price":22.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/Kv8nXCVVS9UbTcXMmWILn_IyMaV0F3.png?v=1790758977","url":"https:\/\/buyflowscripts.com\/products\/overdue-contact-reminder-digest-sheets-gemini-gmail-n8n","provider":"N8N Commerce","version":"1.0","type":"link"}