Automation: Build a Grant Deadline Tracker That Reminds You Automatically

What This Builds

Instead of relying on your memory or a manual calendar to track 20–40 grant deadlines, this automation watches your Google Sheets grant tracker and sends you email reminders at 30 days, 14 days, and 7 days before each deadline — automatically, for every grant in your portfolio. You set it up once and it runs forever.

Prerequisites

• Google account with Google Sheets and Gmail (free)
• Zapier account — free tier works for this; sign up at zapier.com
• Your grants currently tracked in a spreadsheet (or you'll create one)
• Time to build: 1–2 hours
• Cost: Free (Zapier free tier allows up to 5 active Zaps with 100 tasks/month)

The Concept

Think of Zapier as a translator between your apps. It watches one app for a "trigger" (something that happens) and then takes an "action" in another app. In this case: Zapier watches your Google Sheets tracker every day. When it finds a row where a deadline is exactly 30, 14, or 7 days away, it sends you an email. You never look at Zapier once it's running — it just works in the background.

Build It Step by Step

Part 1: Set up your Google Sheets grant tracker

If you don't already have a grant tracking spreadsheet, create one in Google Sheets with these exact column headers in row 1:

Fill in your current active grants. Make sure dates are formatted consistently — Zapier requires a standard date format to work correctly. Select your date columns, go to Format → Number → Date, and choose "MM/DD/YYYY."

Add a sheet tab called "Upcoming Deadlines" — you'll use this as a view, but Zapier will read from your main data sheet.

Test your setup: Make sure you can open the spreadsheet and see all your current grants with dates in the correct columns.

Part 2: Create your Zapier account and first Zap

Go to zapier.com and create a free account. Once inside, click Create Zap.

Step 1 — Set the Trigger:

• Search for and select Google Sheets as your trigger app
• Select trigger event: New or Updated Spreadsheet Row
• Connect your Google account when prompted
• Select your grants tracking spreadsheet and the main sheet tab
• Click Test trigger — Zapier will pull in a sample row from your spreadsheet to confirm the connection

Step 2 — Add a Filter (this is critical): After the trigger, click the + button and add a Filter step (not an action — a Filter):

• Set: Only continue if... [Application Deadline] days until [today] equals 30

This tells Zapier: only proceed with this Zap if the deadline is exactly 30 days away.

Step 3 — Set the Action:

• Select Gmail as your action app
• Select action event: Send Email
• Connect your Gmail account
• Set To: your own email address
• Set Subject: Grant Deadline Reminder: [Application Deadline] — [Funder Name]

  • In the Subject field, click the + button to insert data from your spreadsheet: select Funder Name and Application Deadline
• Set Body:

GRANT DEADLINE REMINDER — 30 DAYS OUT

Funder: [Funder Name]
Deadline: [Application Deadline]
Grant Amount: [Grant Amount]
Program: [Program]
Status: [Status]
Notes: [Notes]

This is an automated reminder from your Zapier grant tracker.

• Insert each spreadsheet field using the + button in the email body

• Click Test action — Zapier will send a test email to your inbox

• Name the Zap something clear: "Grant Deadline — 30-Day Reminder"

• Click Publish

Part 3: Duplicate for 14-day and 7-day reminders

Click Make a copy on your completed Zap. In the copy:

• Change the Filter from 30 days to 14 days
• Update the email subject and body to say "14 DAYS OUT"
• Rename: "Grant Deadline — 14-Day Reminder"
• Publish

Repeat for 7 days.

Now repeat the entire process for your Report Due Date column (column E) — creating a parallel set of 30/14/7-day reminders for reporting deadlines.

You'll have 6 Zaps total, which fits within Zapier's free tier (5 active Zaps). If you need more, upgrade to the Starter plan (~$20/month) or use only the 14-day and 7-day reminders to stay within the free limit.

Real Example: Full Workflow in Action

Setup: You have 22 active grants in your Google Sheets tracker, each with an application or report deadline.

Input: Every morning at 6am, Zapier scans your spreadsheet for rows where a deadline matches today + 30, 14, or 7 days.

Output: You receive this email on March 20 at 6am:

GRANT DEADLINE REMINDER — 14 DAYS OUT

Funder: Metro Community Trust
Deadline: 04/03/2026
Grant Amount: $25,000
Program: Youth Workforce Development
Status: In Progress — needs evaluation plan section
Notes: Program officer is Sandra Chen; she prefers concise evaluation sections

Time saved: You'd normally discover this deadline on March 28 while scanning your spreadsheet manually — now you have 14 days of runway instead of 6. For a $25,000 grant, this difference can mean a strong vs. rushed proposal.

What to Do When It Breaks

• Reminders stopped arriving: Check Zapier's task history (Task History tab) — if a Zap ran but the email didn't arrive, check your spam folder. If the Zap shows an error, re-connect your Gmail account in Zapier's settings.
• Wrong grants triggering reminders: Your date column may have inconsistent formatting. Select the entire date column in Google Sheets and reformat to MM/DD/YYYY. Re-test the Zap.
• Zapier hit its task limit: Free tier allows 100 tasks/month. With 6 Zaps running on 22+ grants, you may exceed this. Upgrade to Starter ($20/month) or reduce to only 7-day reminders.
• New grant added to spreadsheet isn't triggering reminders: Zapier only checks for "new or updated rows." If you added the row a while ago, manually set the Status to something new (add a space) to trigger an update.

Variations

• Simpler version: Skip Zapier entirely — set Google Calendar reminders manually for each deadline (15 minutes per grant). Less elegant but zero setup time and no third-party tools.
• Extended version: Add a fourth action to automatically create a Google Doc outline for the proposal when the 30-day reminder fires — so when you open the email, there's already a draft document waiting with the funder name, deadline, and blank sections pre-populated.
• Team version: Add your ED and any co-writers to the email reminders. In Zapier, add their email addresses to the "To" field separated by commas.

What to Do Next

• This week: Set up your Google Sheets tracker with clean date formatting and build the first Zap (30-day application reminder)
• This month: Add all 6 Zaps and add every active grant and report deadline to the tracker
• Advanced: Build a companion Zap that sends a Slack message to your #grants channel when a new grant is awarded — so leadership is automatically notified without you writing an update

Advanced guide for nonprofit grant writer professionals. Zapier workflows require periodic maintenance when connected apps update their APIs.