Automation

Automatic Invoice Reminders with Google Sheets (Free, No Zapier)

By SoloStack Editorial · Nov 19, 2026 · 3 min read
Automatic Invoice Reminders with Google Sheets (Free, No Zapier) – SoloStack guide cover

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 Paid when 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

  1. Add a test row with your own email, a due date in the past and status Unpaid.
  2. In Apps Script, choose sendInvoiceReminders in the function menu and click Run.
  3. 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.
  4. 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

  1. In Apps Script, click the clock icon (Triggers) on the left.
  2. Click Add Trigger.
  3. Function: sendInvoiceReminders, event source: Time-driven, type: Day timer, time: 8am to 9am.
  4. 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