Overdue Contact Reminder Digest (Sheets, Gemini, Gmail) | n8n

Never let outreach fall off your radar — get an Overdue Contact Reminder Digest generated with Google Sheets, Google Gemini, RSS, and Gmail

This 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.

What this workflow does

• Runs daily at 8:00 and loads configuration values (Google Sheet URL/tab, recipient email, language, and Google News settings).
• Reads all contacts from Google Sheets (e.g., name, relationship, last_contact, interval_days, interests, notes, active).
• Finds overdue follow-ups by normalizing last-contact dates and interest terms, then keeping only active contacts whose follow-up interval has passed.
• Searches Google News RSS for recent headlines matching each person’s interests and keeps the top results.
• Generates a warm draft with Google Gemini using the contact context + selected headlines to produce a subject, reason, and short message draft.
• Aggregates everything into one HTML digest and sends it to you via Gmail.

Use cases

• SaaS operators who want consistent partner and customer follow-ups without manually searching for updates.
• Automation engineers building a repeatable “outreach queue” workflow inside n8n.
• Founders and networking pros who prefer reviewing one digest before contacting people—keeping control over final outreach.

Technical details

• Scheduler: runs every morning at 8:00
• Google Sheets: reads contact records from your specified sheet/tab
• Google News RSS: rss feed read for interest-matched headlines
• Google Gemini (PaLM): generates topic selection and message drafts
• n8n nodes used: set, filter, aggregate, sticky note, rss feed read, and Gmail for sending the digest

For n8n workflows focused on contact management, Gemini-assisted messaging, and Gmail digests, this overdue contact reminder digest gives you relevance, consistency, and time savings.