Automation Template

Stop chasing
overdue invoices manually

Auto-generate PDF invoices from Google Sheets, send via Gmail, and fire 3-stage payment reminders automatically — at 3, 7, and 14 days overdue.

$89
one-time payment · instant download
Buy on Gumroad

Auto-Generated PDF Invoices

Reads client and project data from Google Sheets and generates a branded PDF invoice automatically — no copy-pasting or manual formatting.

Instant Gmail Delivery

Sends each invoice directly to the client's email with a personalised message via Gmail. You never need to open your inbox to send an invoice.

3-Stage Overdue Reminders

Reminder emails fire automatically at 3, 7, and 14 days overdue. Each reminder escalates in urgency — all without you doing anything.

Owner Alerts on Unpaid Invoices

When an invoice hits 14 days unpaid, you receive a direct email alert so you can follow up personally or escalate before it becomes a write-off.

Google Sheets as Your Invoice Hub

Your entire invoice pipeline lives in a Google Sheet — add a row, set Status to Pending, and the automation handles everything from there.

Works with n8n and Make.com

Includes both an n8n workflow and a Make.com blueprint. No subscription needed — run it on any free tier account and pay nothing monthly.

How It Works

1

Add invoice to Google Sheets

Enter client name, email, description, amount, and due date. Set Status to Pending. That is all you do manually.

2

Automation generates PDF invoice

Every hour, the workflow checks for Pending invoices. It builds a professional HTML invoice and converts it to PDF via PDF.co's free API.

3

Invoice emailed to client via Gmail

The PDF attaches to a personalised email and lands in the client's inbox within seconds of being generated. The sheet updates to show InvoiceSent = TRUE.

4

Overdue reminders fire automatically

At 3, 7, and 14 days past the due date, reminder emails go out automatically. Each one is tracked in the sheet so reminders never repeat.

5

You get alerted at 14 days

When an invoice reaches 14 days unpaid, you receive a direct email alert with client name, amount, and days overdue — so you can take action.

What Is Included

  • n8n workflow JSON — 10 nodes, ready to import
  • Make.com blueprint — same logic, different platform
  • PDF setup guide — step-by-step with screenshots
  • Markdown setup guide — readable anywhere
  • Google Sheets column template
  • Personal commercial licence

Frequently Asked Questions

How does the invoice automation work?

The workflow runs every hour and checks your Google Sheets invoice list for rows marked Pending. For new invoices, it generates a professional PDF via PDF.co and emails it via Gmail. For overdue invoices, it sends reminders at 3, 7, and 14 days — and alerts you when an invoice hits 14 days unpaid.

Do I need a PDF.co subscription?

No — PDF.co's free tier includes 100 PDF conversions per month, enough for most small businesses. If you send more than 100 invoices per month, a paid plan starts at $8/month. The automation uses simple HTML-to-PDF conversion that works on the free tier.

Can I customise the invoice design?

Yes. The invoice HTML template is inside the workflow's Generate Invoice PDF node. Edit the HTML and CSS directly to match your brand colours, add your logo, or change the layout. Basic HTML knowledge is all you need.

What happens when an invoice is marked paid?

Change the Status column in Google Sheets from Pending to Paid. The automation skips any row without Status = Pending, so reminders stop automatically once you mark an invoice paid.

Does this work with Make.com as well as n8n?

Yes — the download includes both an n8n workflow JSON and a Make.com blueprint. Both versions have the same logic. The setup guide covers both platforms.

Is there a limit to how many invoices I can process?

The only practical limit is PDF.co's free tier (100/month). The n8n and Make.com free tiers handle hundreds of executions per month. For high-volume invoicing, a paid PDF.co plan is recommended.

Ready to automate your invoicing?

One-time payment. Instant download. Works on the free tier of n8n and Make.com.

Get Invoice Automation — $89