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.