How to Send Invoices Automatically for Free (No Accounting Software)
INTRO
Accounting software costs money. FreshBooks starts at $15/month. Wave is free but limited. Most freelancers just want invoices sent automatically without paying or dealing with complex software.
The good news: You can automate invoices using free tools you already have. Google Sheets. Gmail. Make. Notion. Combined strategically, they handle 90% of freelancer invoicing needs without touching accounting software.
This article shows you exactly how to build an automated invoice system that sends reminders, tracks payment status, and follows up with clients—all free.
SECTION 1: WHY AUTOMATE INVOICING
Manual invoicing wastes time. You create an invoice. Send it. Check if it’s paid. Send a reminder. Follow up again. Repeat for every client.
A solo freelancer with 10 active clients sends 10+ invoices monthly. If each invoice takes 15 minutes to create, send, and follow up on, that’s 150+ minutes monthly = 2.5+ hours wasted.
Automated invoicing saves this time immediately. The system sends invoices on a schedule. It tracks payment status. It sends reminders automatically. It flags overdue invoices for follow-up.
More importantly: Automated invoicing improves cash flow. Clients pay faster when they get consistent reminders. You follow up more consistently when the system prompts you.
SECTION 2: THE FREE INVOICING STACK
Tools needed (all free):
- Google Sheets (invoice template storage)
- Gmail (invoice delivery)
- Make (automation platform)
- Notion (client database)
- Optional: Google Docs (professional invoice template)
Cost: $0 per month
Why this works: These tools connect seamlessly. Notion stores client info. Sheets stores invoice templates. Make connects them. Gmail sends.
No accounting software needed. No monthly fees. No complexity.
SECTION 3: SETUP STEP 1 – CREATE INVOICE TEMPLATE IN GOOGLE SHEETS
Start with a basic Google Sheets invoice template:
Header section:
- Your business name
- Your invoice number (auto-increment)
- Invoice date
- Due date (30 days from invoice date)
Client section:
- Client name
- Client email address
- Client address
Line items:
- Description of work
- Hours or quantity
- Rate
- Total
Footer:
- Amount due
- Payment instructions
- Late payment notice
Keep it simple. Professional but not complex. You’ll use this template repeatedly.
SECTION 4: SETUP STEP 2 – BUILD CLIENT DATABASE IN NOTION
Create a simple Notion database with client information:
Fields:
- Client name
- Client email
- Hourly rate or project rate
- Payment terms (30 days, net 15, etc.)
- Last invoice date
- Payment status (paid, pending, overdue)
Add all current clients. As you take on new clients, add them here immediately.
This becomes your single source of truth for invoicing. Everything flows from here.
SECTION 5: SETUP STEP 3 – AUTOMATE INVOICE CREATION WITH MAKE
Use Make to connect Notion → Google Sheets → Gmail:
Workflow 1: New invoice creation
- Trigger: Monthly (every 1st of month at 9 AM)
- Action 1: Query Notion database for all active clients
- Action 2: For each client, create new row in Google Sheets with invoice template
- Action 3: Auto-populate client name, email, rate, due date
- Cost: ~2 operations per client per month
Workflow 2: Invoice delivery
- Trigger: New row added to Google Sheets (invoice template)
- Action 1: Format invoice as readable email
- Action 2: Send via Gmail to client email address
- Cost: ~1 operation per invoice
Workflow 3: Payment reminder
- Trigger: Invoice is 7 days past due date (check Notion)
- Action 1: Send reminder email to client
- Action 2: Mark invoice as “reminded” in Notion
- Cost: ~1-2 operations per overdue invoice
Total monthly cost: ~5-10 operations (well within Make’s free 1,000 ops/month)
SECTION 6: SETUP STEP 4 – TRACK PAYMENTS IN NOTION
When client pays:
- Update payment status in Notion from “pending” to “paid”
- Add payment date
- Optional: Add payment method
This keeps your cash flow picture accurate. You can see at a glance which clients still owe money.
SECTION 7: ADD FOLLOW-UP AUTOMATION
If clients regularly miss payment deadlines, add follow-up automation:
Workflow: Late payment follow-up
- Trigger: Invoice is 14 days overdue
- Action 1: Send firm follow-up email to client
- Action 2: Notify you via Gmail with subject “OVERDUE: Client Name – Invoice #”
- Cost: ~2 operations per overdue invoice
This catches payment delays early. Most clients pay immediately when reminded. This workflow prevents slow payments from dragging down your cash flow.
SECTION 8: ALTERNATIVES IF YOU WANT EVEN SIMPLER
If the Make automation feels complex, simpler alternatives:
Wave (free accounting software):
- Pre-built invoicing
- Automatic payment reminders built-in
- Free tier has no monthly limits
- Downside: Less customizable than the automation stack above
Google Docs + Gmail:
- Create invoice in Google Docs
- Mail merge with Gmail
- Send manually but tracked
- Cost: $0
- Downside: Still requires manual send, but templates save time
- Similar to Make but different integrations
- $0–19/month depending on volume
- Good if Make doesn’t connect your tools
SECTION 9: COMMON MISTAKES TO AVOID
Forgetting to update payment status: If you don’t mark invoices as paid in Notion, your automation thinks they’re overdue and keeps sending reminders. Update status within 24 hours of receiving payment.
Setting due dates too short: 30 days is standard. Don’t use 10 or 15 days for freelance work unless agreed. Short payment terms strain client relationships.
Automating without a system: Don’t set up automation and ignore it. Check weekly that invoices are sending correctly and clients are paying on schedule.
Not personalizing reminders: Generic “payment due” emails get ignored. Personalize reminders with client name and specific invoice amount.
SECTION 10: NEXT STEPS
- Create your Google Sheets invoice template today
- Build your Notion client database this week
- Test Make workflow with 1-2 clients first
- Once working, expand to all clients
- Monitor for 2 weeks to ensure accuracy
- Adjust as needed
CONCLUSION
You don’t need accounting software to automate invoicing. Google Sheets, Notion, Make, and Gmail combined are powerful enough for any solo freelancer. You’ll save 2+ hours monthly and improve cash flow immediately.
Start simple. Automate invoice creation first. Add payment reminders once that’s working. Build follow-up automation only if needed.
Most freelancers find their invoicing routine working smoothly within 2 weeks of setup. After that, invoicing becomes truly hands-off.