Google Sheets to Gmail, deadline reminders sent for you
Your task list is “in the sheet,” but deadlines still get missed. Not because people don’t care, but because nobody has time to scan rows, compare dates, and nudge the right person every morning.
Project managers feel the heat when one slip blocks five other tasks. Operations leads and small team owners deal with it too. This Sheets Gmail reminders automation turns your Google Sheets into automatic Gmail deadline reminders, so follow-ups happen without you playing human alarm clock.
Below, you’ll see exactly how the workflow runs daily, how it decides “today vs. 3 days vs. 7 days,” and what you need to make it reliable.
How This Automation Works
The full n8n workflow, from trigger to final output:
n8n Workflow Template: Google Sheets to Gmail, deadline reminders sent for you
flowchart LR
subgraph sg0["Schedule Flow"]
direction LR
n0@{ icon: "mdi:database", form: "rounded", label: "Get row(s) in sheet", pos: "b", h: 48 }
n1@{ icon: "mdi:swap-vertical", form: "rounded", label: "Loop Over Items", pos: "b", h: 48 }
n2@{ icon: "mdi:swap-horizontal", form: "rounded", label: "3日以内", pos: "b", h: 48 }
n3@{ icon: "mdi:play-circle", form: "rounded", label: "Schedule Trigger", pos: "b", h: 48 }
n4@{ icon: "mdi:swap-horizontal", form: "rounded", label: "Check Due Today (IF)", pos: "b", h: 48 }
n5@{ icon: "mdi:message-outline", form: "rounded", label: "Send 3-Day Reminder (Gmail)", pos: "b", h: 48 }
n6@{ icon: "mdi:swap-horizontal", form: "rounded", label: "Check Within 7 Days (IF)", pos: "b", h: 48 }
n7@{ icon: "mdi:message-outline", form: "rounded", label: "Send 7-Day Reminder", pos: "b", h: 48 }
n2 --> n5
n2 --> n6
n1 --> n4
n3 --> n0
n0 --> n1
n7 --> n1
n4 --> n1
n4 --> n2
n6 --> n7
n6 --> n1
n5 --> n1
end
%% Styling
classDef trigger fill:#e8f5e9,stroke:#388e3c,stroke-width:2px
classDef ai fill:#e3f2fd,stroke:#1976d2,stroke-width:2px
classDef aiModel fill:#e8eaf6,stroke:#3f51b5,stroke-width:2px
classDef decision fill:#fff8e1,stroke:#f9a825,stroke-width:2px
classDef database fill:#fce4ec,stroke:#c2185b,stroke-width:2px
classDef api fill:#fff3e0,stroke:#e65100,stroke-width:2px
classDef code fill:#f3e5f5,stroke:#7b1fa2,stroke-width:2px
classDef disabled stroke-dasharray: 5 5,opacity: 0.5
class n3 trigger
class n2,n4,n6 decision
class n0 database
The Problem: Spreadsheet deadlines don’t chase anyone
Google Sheets is great for tracking tasks, but it’s passive. It won’t tap someone on the shoulder when a due date is coming up, and it definitely won’t do it consistently across a team. So reminders become a manual ritual: open the sheet, sort by date, check who owns what, draft messages, then repeat tomorrow. Miss a day because you’re in meetings and things quietly slip. Worse, the “who was supposed to follow up?” question starts taking more time than the work itself.
It adds up fast. Here’s where it usually breaks down in real teams.
- You spend about 30 minutes each morning scanning tasks and pinging people, and it still isn’t complete.
- Deadlines get interpreted differently because the nudge depends on who is doing the nudging that day.
- Tasks due “soon” don’t feel urgent until they’re due today, which creates last-minute chaos.
- Email addresses and owners change, so reminders go to the wrong person or to nobody.
The Solution: Google Sheets → Gmail deadline reminders (Today/3/7)
This workflow turns your task spreadsheet into a daily reminder engine. Every morning at 9:00, n8n pulls all rows from your Google Sheet, then checks each task one-by-one to see how close the deadline is. If a task is due today, it sends a “due today” email to the person responsible. If it’s not due today, the workflow checks whether it lands within the next three days, and sends a different message for that window. Still not urgent? It runs one more check for the next seven days and sends a “due within a week” reminder. The result is simple: each owner gets the right nudge at the right time, pulled directly from the “メールアドレス” field in the sheet.
The workflow starts on a schedule, reads the sheet, and loops through tasks in batches so nothing is skipped. Then it routes each task through date checks (today, within 3 days, within 7 days). Finally, Gmail sends the appropriate email and the workflow continues until every row has been evaluated.
What You Get: Automation vs. Results
| What This Workflow Automates | Results You’ll Get |
|---|---|
|
|
Example: What This Looks Like
Say your sheet has 40 active tasks across a small team. Manually, even a quick scan, sorting by deadline, and writing reminders can take about 30 minutes a day, and that’s on a “good” day. With this workflow, the only human time is maintaining the sheet itself: maybe 5 minutes to add or update tasks, then the 9:00 run handles the checks and sends the emails automatically. That’s roughly 2 hours back each week, plus fewer last-minute scrambles.
What You’ll Need
- n8n instance (try n8n Cloud free)
- Self-hosting option if you prefer (Hostinger works well)
- Google Sheets to store tasks, owners, and deadlines
- Gmail to send deadline reminder emails
- Google OAuth connection (create in Google Cloud console)
Skill level: Beginner. You’ll connect accounts, select the sheet, and confirm the required columns.
Don’t want to set this up yourself? Talk to an automation expert (free 15-minute consultation).
How It Works
A daily schedule kicks things off. At 9:00 each morning, n8n starts the workflow automatically, so reminders don’t depend on anyone remembering to run a report.
Your task list is pulled from Google Sheets. The workflow retrieves all rows, including task name (タスク), deadline (期限), owner (担当), and recipient email (メールアドレス).
Each task gets evaluated against date windows. First it checks “due today.” If not, it checks “within 3 days,” and then “within 7 days,” using simple If conditions so the logic stays readable.
Gmail sends the correct reminder and the loop continues. A “due today” task gets the most urgent message, while 3-day and 7-day tasks get softer nudges. Then n8n moves on to the next row until the sheet is done.
You can easily modify the reminder windows to match your process, so “3 days” can become “2 business days,” or you can add an overdue branch later. See the full implementation guide below for customization options.
Step-by-Step Implementation Guide
Step 1: Configure the Schedule Trigger
Set the daily schedule that kicks off the workflow and reads tasks from your spreadsheet.
- Add or open the Scheduled Start node and set the schedule rule to run at hour
9. - Confirm the execution flow starts at Scheduled Start and continues to Retrieve Sheet Rows.
Step 2: Connect Google Sheets
Pull task records from your spreadsheet so the workflow can evaluate deadlines.
- Open Retrieve Sheet Rows and select the spreadsheet Document ID as
[YOUR_ID]. - Set the Sheet Name to
シート1(gid0). - Credential Required: Connect your googleSheetsOAuth2Api credentials.
メールアドレス, タスク, 期限, and 担当. Mismatched headers will cause empty email content.Step 3: Set Up Record Iteration and Date Validation
Process each row, validate dates, and branch into the 3-day or 7-day deadline checks.
- In Iterate Task Records, keep default Options so each row is processed one at a time.
- Configure Validate Due Today with a condition that checks 期限 equals
{{ (new Date(Date.now() + 9*60*60*1000).toISOString().split("T")[0]) }}. - In Check Within 3 Days, set the two numeric conditions to:
{{ new Date($json["期限"]).getTime() }}≥{{ new Date().setHours(0,0,0,0) }}and ≤{{ new Date().setHours(0,0,0,0) + 3*24*60*60*1000 }}. - In Evaluate 7-Day Window, set the two numeric conditions to:
{{ new Date($json["期限"]).getTime() }}≥{{ new Date().setHours(0,0,0,0) }}and ≤{{ new Date().setHours(0,0,0,0) + 7*24*60*60*1000 }}.
Step 4: Configure Output Email Nodes
Set up the two Gmail actions that notify owners about upcoming deadlines.
- In Dispatch 3-Day Email, set Send To to
{{ $json['メールアドレス'] }}, Subject toタスク期限が三日前となりました, and Message to{{ $json['タスク'] }} {{ $json['期限'] }} {{ $json['担当'] }}. - Credential Required: Connect your gmailOAuth2 credentials for Dispatch 3-Day Email.
- In Send Weekly Deadline Email, set Send To to
{{ $json['メールアドレス'] }}, Subject toタスクの期限が一週間以内です, and Message to{{ $json['タスク'] }} {{ $json['期限'] }} {{ $json['担当'] }}. - Credential Required: Connect your gmailOAuth2 credentials for Send Weekly Deadline Email.
Step 5: Test and Activate Your Workflow
Run a manual test to ensure rows are read, conditions match, and emails send correctly before going live.
- Click Execute Workflow and verify that Scheduled Start triggers Retrieve Sheet Rows.
- Confirm each item flows through Iterate Task Records, then into Validate Due Today and the correct window check.
- Successful execution looks like a sent email from either Dispatch 3-Day Email or Send Weekly Deadline Email when a deadline is within range.
- Turn the workflow Active to enable scheduled runs in production.
Common Gotchas
- Google Sheets credentials can expire or need specific permissions. If things break, check the n8n Credentials tab and confirm the account can read that spreadsheet first.
- If you’re using Wait nodes or external rendering, processing times vary. Bump up the wait duration if downstream nodes fail on empty responses.
- Default prompts in AI nodes are generic. Add your brand voice early or you’ll be editing outputs forever.
Frequently Asked Questions
About 20 minutes if your sheet columns are ready.
No. You’ll mostly connect Google accounts and map the right columns. The date checks are already built into the workflow.
Yes. n8n has a free self-hosted option and a free trial on n8n Cloud. Cloud plans start at $20/month for higher volume. You’ll also need to factor in Google usage (usually negligible for this) since this workflow relies on Google Sheets and Gmail.
Two options: n8n Cloud (managed, easiest setup) or self-hosting on a VPS. For self-hosting, Hostinger VPS is affordable and handles n8n well. Self-hosting gives you unlimited executions but requires basic server management.
Yes, but you’ll want to tweak the date logic. You can adjust the “Validate Due Today,” “Check Within 3 Days,” and “Evaluate 7-Day Window” conditions to use business-day rules (or a holiday calendar) instead of simple calendar days. Common customizations include adding an overdue branch, changing the email subject lines, and sending a manager summary when high-impact tasks are near due.
Usually it’s expired Google OAuth credentials or the connected account no longer has access to the spreadsheet. Reconnect Google Sheets in n8n, then confirm the sheet is shared with that same Google account. Also check that the spreadsheet ID and worksheet/tab still match what the workflow expects, because renaming tabs can cause confusing “not found” behavior.
A few hundred tasks in a single morning run is normal for n8n, and many teams run more.
Often, yes. n8n makes it easier to loop through rows, branch logic for “today vs. 3 days vs. 7 days,” and keep everything in one workflow without paying extra for each path. You also get the option to self-host, which matters when reminders run daily and volumes grow. Zapier or Make can be quicker for a simple two-step trigger, but this use case usually turns into multi-branch logic fast. If you want help deciding, Talk to an automation expert.
Once this is running, your spreadsheet stops being a graveyard of “we’ll get to it.” It becomes a system that politely follows up every day, even when you’re busy.
Need Help Setting This Up?
Our automation experts can build and customize this workflow for your specific needs. Free 15-minute consultation—no commitment required.
