Auto-Generate and Email Recurring Invoices from a Google Sheet
An n8n workflow that reads a Google Sheet of recurring clients, generates each due invoice as a PDF with the right amount and line items, emails it, and marks it sent — so freelancers and agencies bill on time every month without touching invoicing software.
- 1
Run daily
A
Schedule Triggerruns each morning. AGoogle Sheetsread pulls all recurring clients. - 2
Keep only today's invoices
A
Filternode keeps rows whosebilling_dayequals today's day-of-month, so only clients due today proceed. - 3
Build the invoice PDF
A
Set/HTMLstep fills your invoice template with client name, line items, amount and the next invoice number, then anHTTP Requestrenders it to PDF. - 4
Email and mark sent
A
Gmailnode sends the PDF to the client, then aGoogle Sheetsupdate increments the invoice number and writes the sent date so nothing double-bills.
Frequently asked questions
How does it know which invoices are due?
Each client row has a billing day of the month and a next-invoice number. The daily run keeps only rows whose billing day matches today, so exactly the right clients are invoiced — no more, no less.
How is the PDF created?
An HTML invoice template is filled with the client's details and rendered to PDF via a converter (an HTML-to-PDF API or n8n's HTML node piped to a PDF service). The PDF is attached to the email; the sheet stores the invoice number so numbering stays sequential.
Log Stripe Payments from Zapier into a Google Sheets Accounting Ledger
An n8n workflow that receives successful Stripe charges relayed by Zapier, calculates fees and net amount, and appends a clean bookkeeping row to a Google Sheets ledger — giving small businesses a real-time revenue log without paying for accounting software.
Free recipeGet Alerted the Moment a Supplier Changes Their Prices
An n8n workflow that periodically fetches your suppliers' price lists, compares them to the last known prices, and alerts you to any increases or drops with the exact delta — so cost creep never silently erodes your margins and you can renegotiate or re-price in time.
Free recipeRoute Expense Requests to the Right Manager for Approval in Slack
An n8n workflow that takes each submitted expense, routes it to the correct approver based on amount and department, and posts interactive Approve/Reject buttons in Slack — so reimbursements get decided in minutes instead of living in an email thread for a week.