Time-Saving Scripts Every Freelancer Should Steal
Let me tell you a story. Two years ago, I almost quit freelancing. Not because I didn’t love the work—I do—but because I was drowning in the dumbest, most repetitive tasks. Writing the same email replies. Manually calculating invoices. Copy-pasting client info between tools. It felt like I couldn’t breathe.
That’s when I stumbled into the world of automation scripts. At first, it sounded too good to be true: “Write some code and the boring stuff magically happens for you.” But let me tell you, it’s not magic—it’s math. And it works. Now, half my business runs on autopilot, and I get to focus on the fun, high-value work (you know, the stuff clients actually pay me for).
Today, I’m pulling back the curtain. Here are the time-saving scripts I use every day, plus how you can steal ’em for your own freelancing business. Let’s go.
Automate Your Follow-Up Emails
If there’s one script that saved me the most sanity, it’s the follow-up email automation. You know how clients ghost sometimes? Or forget to send you that “one last thing” you need to wrap up a project? Well, instead of me wasting brainpower on remembering who I need to nudge, I let a script do it for me.
I use Zapier for this. Here’s how:
- When a client sends me an email request, I tag it in Gmail as “Follow-Up Needed.”
- Zapier scans Gmail every hour and logs those emails into a Google Sheet.
- If no reply or action happens in 3 days, Zapier triggers a prewritten email that gently reminds the client to respond, send files, or whatever I need from them.
This little workflow saves me at least 2 hours a week. Multiply that by 52 weeks, and yeah, you’re looking at over 100 hours saved annually. That’s two full workweeks back in my pocket. No more forgetting. No more chasing people down.
Automatically Generate Invoices
Here’s what I learned the hard way: The faster you send invoices, the faster you get paid. But sitting down to create, format, and send them? Ugh. It’s a time suck. So, I built a script to handle it.
For this, I use Google Sheets + Google Apps Script + QuickBooks. Here’s how it works:
- When I finish a task or project, I log the details in a Google Sheet (date, project name, hours worked, rate, etc.).
- A custom Google Apps Script automatically generates a polished invoice PDF based on that data.
- The script even emails the invoice directly to my client—complete with personalized subject lines and payment links.
I timed it. Pre-automation, this process took me 15 minutes per invoice. I send about 10 invoices a month, so that’s 150 minutes—2.5 hours—gone. Now? The whole thing takes 30 seconds. And my clients get their invoices faster, which means I get paid faster. Win-win.
Standardize Client Onboarding
First impressions matter, and a smooth onboarding process can set the tone for the entire client relationship. But honestly? I used to wing it. I’d forget to send contracts on time, or I’d realize mid-project that I didn’t have the branding assets I needed. So, I scripted it.
Enter Airtable. My client onboarding workflow looks like this:
- When a new client signs up, I fill out a quick Airtable form with their name, email, and project details.
- A script triggers tasks in my project manager (I use Notion) to prepare contracts, gather assets, and schedule the kickoff call.
- An email template is automatically sent to the client with a welcome note, a link to their onboarding form (Google Form), and a calendar invite.
What used to take me a scattered 3 days now happens in under an hour. No missed steps, no frantic “I need this yesterday” emails to clients. And the best part? Clients always comment on how “professional” it makes me look. (If only they knew it’s just a fancy Airtable workflow, ha.)
Schedule Social Media in Batches
Finally, let’s talk about social media. If you’re like me, you know you need to stay visible online…but who has time to post every day? The answer? You guessed it: scripts.
I use a combo of Buffer and a Python script for this. Here’s my setup:
- Once a month, I batch-write 30 posts in a Google Doc.
- The Python script pulls the content from the Doc and uploads it to Buffer, where I’ve pre-scheduled posting times for each platform (LinkedIn, Twitter, Instagram).
Total time spent: about 90 minutes per month. Compare that to the 10-15 minutes I used to waste every single day trying to think up and post something. That’s 5 hours a month saved—or 60 hours a year.
FAQ: Common Questions About Scripts and Automation
Do I need to know how to code to set this up?
Not really. Tools like Zapier, Make (formerly Integromat), and Airtable don’t require any coding knowledge. But if you do know a bit of Python or JavaScript, you’ll have even more flexibility. Start small!
How long does it take to set up these scripts?
Some workflows take 30 minutes to set up (like the follow-up emails via Zapier). Others, like the invoicing script, might take a few hours if you’re new to tools like Google Apps Script. Think of it as an investment—you’ll save way more time in the long run.
What if a script breaks?
It happens, though not often. Usually, it’s because the app you’re automating changed something (like an API update). Just check your logs, debug, and you’re good to go. I maybe spend 15 minutes a month on maintenance.
Look, automation won’t solve every freelance headache, but it can claw back hours of your week. And when you’re self-employed, those hours are priceless. Start with one script—just one—and you’ll never go back.
đź•’ Published: