Automatic Invoice Reminders with Google Sheets (Free, No Zapier)
Some links may be affiliate links. If you buy through them we may earn a commission, at no extra cost to you. We only recommend tools we have tested.
Chasing late payments is awkward and easy to forget. Paid tools can automate it, but if you already track invoices in Google Sheets you can do it for free with about 40 lines of Google Apps Script. Here’s the full setup.
What you’ll build
Every morning, the script checks your invoice sheet. For each unpaid invoice that is past due, it emails the client a polite reminder, at most once every 7 days, and records the date it sent it.
Step 1: Set up the sheet
Create a Google Sheet with these columns in row 1, exactly in this order:
| A | B | C | D | E | F | G |
|---|---|---|---|---|---|---|
| Invoice # | Client name | Client email | Amount | Due date | Status | Last reminder |
- Due date must be a real date (Format → Number → Date).
- Status: type
Paidwhen paid. Anything else counts as unpaid. - Leave Last reminder empty. The script fills it in.
Step 2: Add the script
In the sheet, open Extensions → Apps Script, delete the sample code and paste:
const YOUR_NAME = 'Your Name'; // change this
const REMIND_EVERY_DAYS = 7;
function sendInvoiceReminders() {
const sheet = SpreadsheetApp.getActiveSpreadsheet().getSheets()[0];
const rows = sheet.getDataRange().getValues();
const today = new Date();
today.setHours(0, 0, 0, 0);
for (let i = 1; i < rows.length; i++) {
const [invoice, name, email, amount, due, status, last] = rows[i];
if (!email || !(due instanceof Date)) continue;
if (String(status).trim().toLowerCase() === 'paid') continue;
if (due >= today) continue; // not overdue yet
const daysSinceLast = last instanceof Date
? (today - last) / 86400000
: Infinity;
if (daysSinceLast < REMIND_EVERY_DAYS) continue;
const daysLate = Math.round((today - due) / 86400000);
const subject = `Friendly reminder: invoice ${invoice}`;
const body =
`Hi ${name},\n\n` +
`I hope you're well. This is a quick reminder that invoice ${invoice} ` +
`for ${amount} was due on ${due.toDateString()} (${daysLate} days ago).\n\n` +
`If you've already sent payment, thank you, and please ignore this email. ` +
`If anything is unclear, just reply and I'll help.\n\n` +
`Best regards,\n${YOUR_NAME}`;
MailApp.sendEmail(email, subject, body);
sheet.getRange(i + 1, 7).setValue(new Date()); // column G
}
}
Change YOUR_NAME, then click Save.
Step 3: Test it safely
- Add a test row with your own email, a due date in the past and status
Unpaid. - In Apps Script, choose
sendInvoiceRemindersin the function menu and click Run. - Google asks for permission. Click Review permissions, choose your account, then Advanced → Go to (project name) and Allow. The warning appears because the script is yours and not published by Google.
- Check your inbox. Column G should now show today’s date.
Run it again straight away. You should not get a second email. That proves the 7-day rule works.
Step 4: Make it run every day
- In Apps Script, click the clock icon (Triggers) on the left.
- Click Add Trigger.
- Function:
sendInvoiceReminders, event source: Time-driven, type: Day timer, time: 8am to 9am. - Save.
Done. The script now checks your invoices every morning.
Ideas to extend it
- Escalate the tone: use a firmer message when
daysLate > 30. - CC yourself: replace the send line with
MailApp.sendEmail(email, subject, body, { cc: 'you@example.com' });. - Weekly summary: send yourself one email listing every overdue invoice and its total.
Common problems
| Problem | Fix |
|---|---|
| Nothing sends | Check the due date column is a real date, not text |
| “Exceeded maximum execution time” | Very large sheets: archive paid invoices to another tab |
| Emails go to spam | Keep the text plain and personal. Avoid links and all-caps |
Want your receipts filed automatically too? See how to save Gmail attachments to Google Drive.
Fifteen minutes of setup, and you never have to remember to chase a late invoice again.
Frequently asked questions
How many reminder emails can I send per day?
Google limits Apps Script email sending. Free Gmail accounts can send to roughly 100 recipients a day, and Google Workspace accounts get a higher limit. That is plenty for most freelancers and small businesses.
Will the emails come from my Gmail address?
Yes. The script sends from the Google account that owns the spreadsheet, so replies come straight to your inbox.
Is it safe to authorise the script?
The script runs only inside your own Google account. Google shows a warning because you wrote it yourself and it is not published. Read the code below so you know exactly what it does: it reads your sheet and sends emails, nothing else.
Keep reading
How to Save Gmail Attachments to Google Drive Automatically
Automatically save invoices, receipts and client files from Gmail into a Google Drive folder with a free Apps Script. No Zapier needed, 15-minute setup.