The Freelancer's Automation Stack Problem
You're billing by the hour, which means every hour spent on admin, follow-ups, invoicing, and proposal formatting is an hour you're not earning. Yet most freelance guides jump straight to "use Notion" and leave you to wire everything together yourself.
This is the actual automation stack I use — built on Make.com, Zapier, and a handful of AI prompts. Total cost: under €50 in tools (some are free tiers). Setup time: one weekend. Return: roughly 8–10 hours/week back.
The Stack
1. Lead Capture → CRM (Free tier: Make.com + Airtable)
New inquiry comes in via contact form or email. Make.com catches it via webhook or Gmail watch trigger, extracts the key fields (name, company, what they need, budget hint), and pushes a structured row into Airtable.
No more copy-pasting from email. No more "wait, when did they reach out?"
The Make.com scenario takes about 20 minutes to build if you're using a pre-built template. I started with a Zapier/Make.com recipe bundle — 15 pre-configured workflows for exactly this kind of thing. Worth the €1 to skip the trial-and-error.
2. Proposal Generation (AI + Google Docs)
When a lead hits "Qualified" status in Airtable, Make.com triggers a second scenario: it pulls the lead data, sends it to an AI API with a structured prompt, and generates a first-draft proposal into a Google Doc.
The prompt matters more than the model. I've tested 30+ prompt variations and the ones that work include: the client's industry, their stated problem, three specific deliverables, and a timeline anchor. The output still needs editing, but it's 70% there in 90 seconds.
3. Follow-Up Sequences (Gmail + Make.com)
Most freelance revenue comes from follow-ups. Most freelancers do zero follow-ups because it's awkward and manual.
Automated version: when a proposal is sent (manual trigger via Airtable button), Make.com starts a follow-up sequence:
- Day 3: "Checking in — any questions on the proposal?"
- Day 7: "Following up — still happy to hop on a quick call"
- Day 14: "Closing the loop — let me know either way"
Each email is personalized with the client name and proposal subject. They look hand-written. The conversion lift is significant — I'd estimate 15–25% more closed projects just from consistent follow-up.
4. Invoice Automation (Free: Wave or Zoho Invoice)
When a project status flips to "Active" in Airtable, a Make.com scenario auto-creates a draft invoice in Wave (free accounting software) with:
- Client name/email pre-filled
- Project line items from Airtable
- Due date set to Net 30
You still send it manually (one click), but the 10-minute data entry step is gone.
5. Time Tracking → Weekly Report (Toggl + Make.com)
Every Sunday at 22:00, Make.com pulls last week's Toggl time entries, calculates effective hourly rate per project (revenue ÷ hours), and sends you a Slack/Telegram message with the summary.
If your effective rate is dropping, you know in real-time rather than discovering it at year-end when you do taxes.
The AI Prompt Layer
Automation handles routing and triggers. AI handles the content generation layer. The prompts I rely on most:
- Proposal scope section: "Given that the client needs [X], write a 3-bullet scope section that sets clear boundaries without sounding defensive..."
- Cold outreach: "Write a 3-sentence cold email to [job title] at [company type] about [service]. Tone: direct, not salesy. No fluff opener..."
- Pricing justification: "The client pushed back on my rate of €[X]. Write a 2-sentence response that holds the rate without being defensive..."
I packaged the 50 prompts I actually use into PromptForge — €3, immediate download. Not AI-generated fluff prompts. Ones I've iterated on for months.
What This Stack Does NOT Do
- It doesn't replace judgment. Qualifying leads, scoping projects, deciding whether to take on a client — still human decisions.
- It doesn't work if you don't use it. The automation only fires if data enters the system. You still have to log things.
- It doesn't replace good positioning. If you're getting bad leads, automation sends you more bad leads faster.
Getting Started (the non-overwhelming version)
Don't build the whole stack at once. Start with one automation that solves your biggest time sink:
- If you lose track of leads → build the CRM sync first
- If follow-ups feel awkward → build the sequence first
- If proposals take too long → build the AI draft first
Each one is a weekend project. Four weekends = the full stack.
The workflow templates referenced above are at northbeamstudio.gumroad.com if you want the starting point rather than building from a blank canvas.
What's the most manual thing still eating your time as a freelancer? Drop it in the comments — I've probably automated something similar.
Top comments (0)