Send weekly timesheet reminders to active agents with Gmail and Google Sheets
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 8 nodes and runs on a schedule (cron 0 16 * * 5). Along the way it connects Google Sheets and Gmail.
How it runs
Trigger: On a schedule (cron 0 16 * * 5).
- Configure (Edit Fields (Set)): sets 2 fields: sheetUrl, managerEmail
- Read Active Agents (Google Sheets): read (sheet)
- Capture Row Index (Edit Fields (Set)): sets 1 field: row_number
- Filter: keeps only the items that match a condition
- Send Timesheet Reminder (Gmail): send (message)
- Prepare Row Update (Edit Fields (Set)): sets 1 field: row_number
- Record Reminder Date (Google Sheets): update (sheet)
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (5)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Edit Fields (Set)
n8n-nodes-base.set - Google Sheets
n8n-nodes-base.googleSheets - Filter
n8n-nodes-base.filter - Gmail
n8n-nodes-base.gmail
From the author
Quick overview This workflow runs every Friday at 16:00, reads an agent roster from Google Sheets, emails each active agent a personalized timesheet reminder via Gmail, and writes the date the reminder was sent back to the sheet. How it works 1. Runs every…