10 Admin Tasks You Should Automate Before Hiring a VA
The Premature Hire
You’re overwhelmed with admin. Your first thought is: “I need a Virtual Assistant.” Maybe you do. But before you hire someone to do tasks manually, check whether those tasks should be done by a machine.
Automating the right tasks first means: if you still need a VA, they spend their time on work that actually needs a brain. And if you don’t? You’ve just saved yourself a monthly expense.
Here are 10 admin tasks that Google Apps Script can handle before a VA needs to touch them.
1. Email Filing and Organisation
The manual task: Open inbox. Read emails. Decide where they belong. Apply labels. Move to folders. Repeat 50 times.
The automation: A script scans incoming emails by sender, subject, and keywords. It applies labels, stars important messages, and archives routine ones. Attachments are saved to Drive folders automatically. A daily summary email lists what came in and where it went.
Time saved: 20-40 minutes per day Difficulty to automate: Low
2. Form Response Processing
The manual task: Check Google Forms for new responses. Copy data to master spreadsheet. Add calculated fields (timestamps, IDs, status). Send confirmation to respondent.
The automation: An onFormSubmit trigger fires instantly when someone fills out a form. The script validates the data, adds it to the master sheet with a unique ID and timestamp, sends a personalised confirmation email, and notifies the relevant team member.
Time saved: 5-15 minutes per submission (adds up fast) Difficulty to automate: Low
3. Invoice and Receipt Filing
The manual task: Download invoice/receipt attachments from email. Rename them consistently. Upload to the correct Drive folder. Log details in a tracking spreadsheet.
The automation: A script scans Gmail for emails with invoice-related subjects or from known supplier addresses. It extracts attachments, renames them using a consistent convention (date-supplier-amount), files them in the correct Drive folder, and logs the entry in the tracking sheet.
Time saved: 5-10 minutes per invoice Difficulty to automate: Medium (pattern matching needs tuning)
4. Meeting Scheduling and Reminders
The manual task: Check calendar for availability. Propose times via email. Confirm and create event. Send reminder the day before. Share prep documents.
The automation: While the back-and-forth of scheduling often needs a human (or a tool like Calendly), the downstream tasks don’t. A script can: create prep document from a template when a meeting is created, send reminder emails 24 hours before with agenda and documents attached, and create follow-up tasks after the meeting.
Time saved: 10-15 minutes per meeting Difficulty to automate: Medium
5. Data Entry Between Spreadsheets
The manual task: Open Source Sheet A. Copy relevant rows. Open Destination Sheet B. Paste. Adjust formatting. Repeat.
The automation: A script reads from Source Sheet A, filters for the relevant rows based on criteria, and writes them to Destination Sheet B; formatted, deduplicated, and time-stamped. Runs on a schedule or on a trigger.
Time saved: 15-60 minutes per day (depending on volume) Difficulty to automate: Low
6. Client Onboarding Paperwork
The manual task: New client signs up. Create a folder in Drive. Copy template documents. Fill in client details on each template. Share folder with client. Send welcome email with next steps.
The automation: A form submission or spreadsheet status change triggers the entire sequence. Folder created. Templates copied and populated with client data. Sharing permissions set. Welcome email sent with links to their documents. Calendar event created for kickoff call.
Time saved: 30-45 minutes per new client Difficulty to automate: Medium
7. Report Generation
The manual task: Every Friday (or Monday, or month-end), pull data from multiple sheets. Calculate metrics. Build a report document or email. Format tables and highlights. Send to stakeholders.
The automation: A time-based trigger generates the report automatically. Data is pulled from all source sheets, metrics calculated, and a formatted HTML email (or Google Doc) is created and sent to the distribution list; complete with tables, colour-coded indicators, and week-over-week comparisons.
Time saved: 1-3 hours per report cycle Difficulty to automate: Medium to high (depends on report complexity)
8. Follow-Up Email Sequences
The manual task: After a meeting or enquiry, send a follow-up email. Then another 3 days later. Then a check-in at 7 days. Remember to personalise each one. Remember to track who got what.
The automation: A script manages the entire sequence. When a new contact enters the system (via form, spreadsheet update, or manual trigger), the script schedules and sends personalised follow-ups at the right intervals. It tracks what was sent, marks contacts who reply, and stops the sequence when a response is received.
Time saved: 10-20 minutes per contact (multiplied by volume) Difficulty to automate: Medium
9. Document Generation From Templates
The manual task: Open a Google Docs template. Replace placeholder text with client/project details. Adjust any conditional sections. Export as PDF. Save to the right folder. Email to the recipient.
The automation: A script reads data from a spreadsheet row, opens the template, replaces all placeholders, handles conditional sections (include/exclude paragraphs based on data values), converts to PDF, saves to Drive, and emails the PDF; all triggered by a status change or button click.
Time saved: 15-20 minutes per document Difficulty to automate: Medium
10. Overdue Item Chasing
The manual task: Check the spreadsheet for items past their deadline. Look up who’s responsible. Write and send a reminder email. Update the status. Check again tomorrow.
The automation: A daily trigger scans for overdue items. For each one, it sends a templated reminder to the responsible person (escalating in tone for repeated overdue items). It logs the reminder in the spreadsheet and updates the status. The next day, it checks again; automatically.
Time saved: 15-30 minutes per day Difficulty to automate: Low to medium
The Priority Matrix
Not sure where to start? Rank each task by:
| Factor | Question |
|---|---|
| Frequency | How often does this happen? (Daily > weekly > monthly) |
| Time per occurrence | How long does it take each time? |
| Error rate | How often do mistakes happen when done manually? |
| Simplicity | How rule-based is the task? (Pure data movement is easiest) |
Start with high-frequency, rule-based tasks. These give the fastest return with the lowest build complexity.
After Automation: Do You Still Need a VA?
Maybe. If after automating the robotic tasks you still have hours of work that needs human judgement; client communication, creative tasks, complex problem-solving; a VA is absolutely worth hiring.
But now your VA is doing VA work, not robot work. They’re more productive, more engaged, and delivering more value per hour.
And if the automation handles enough? You might find you don’t need a VA at all, or you need fewer hours than you thought.
Ready to Automate the Robots?
At Empower Automation, we help businesses automate the admin tasks that don’t need a human; so the humans can focus on work that does.
Book a free 15-minute automation audit →
Tell us which of these 10 tasks eat up your time. We’ll tell you which ones can be automated first and what it would cost.
Nicola Berry is the founder of Empower Automation, based in Falkirk, Scotland. Automating the admin so you can focus on the business.
Professional Email & Tools for Your Business
Get you@yourcompany.com, plus video meetings, secure cloud storage, and the powerful admin controls you need to scale. Same tools I use to build your automations.