Automations
Automations that take out the busywork.
I build complex automations: Google Workspace systems with Apps Script, Google Forms, Sheets and Gmail, and PowerShell scripts for Microsoft 365. Behind each one are scripts, schedules, templates and checks working together, with a person approving anything important.
The Google Workspace examples were built for an online sleep products brand. Names and details are kept private, so the pictures are illustrations with details changed.
Refund request
Order number#10482Refund amount£24.00Sort code••-••-••Account number•••• 1234SubmitREF-2026-0014
Google Forms · Apps Script
Refund requests that file themselves.
A customer refund form run by a single script. It checks the details, creates a reference, sends a branded PDF to finance and confirms with the customer, without anyone touching it.
- Checks on bank details, with private details kept out of emails.
- Branded PDFs and emails created on their own.
- Rebuilds itself in one click if it is ever changed by mistake.
Google Forms · Apps Script
Creator payment details, checked and safe.
A payment details form for content creators in the UK, the US and elsewhere, with checks for each country’s bank details built in.
- Live checks on bank details as they are typed in.
- A branded PDF for finance, with a fraud check before paying.
- A masked confirmation sent back to the creator.
Creator payment details
BusinessPersonalBank countryUnited StatesRouting number9 digitsSWIFT / BIC8 or 11 charactersSubmitFor finance
- Spotting phishing
- Passwords and sign-in
- Safe payments
- Customer data
- Reporting an incident
Quiz
Question 8 of 12Passed · 11 of 12Next due in 6 monthsTraining tracker
Team member APassedTeam member BDue soonTeam member COverdueApps Script web app · Google Sheets · Live
Cyber safety training that runs itself.
A branded training site for the whole team, run from a Google Sheet, with lessons, a quiz and an incident report form.
- Tracks everyone’s progress, results and next due date on its own.
- Sends reminders, pass emails and an admin summary automatically.
- Doubles as the log for any security incidents.
Apps Script · Google Sheets · Gmail · In testing
Copycat listings, found and followed up.
A system that searches online for products using the brand’s name without permission, then prepares, sends and tracks formal notices, all from one Google Sheet.
- Searches marketplaces and online shops and grades every match.
- Builds branded notices from templates, sent only once approved.
- Follows up on its own and checks whether listings have been taken down.
Listings found
Listing AStrong matchListing BCheck by handListing CStrong matchListing DRemovedInfringement notice
Our ref NTC-0007Discount codes found
CODE-ANewCODE-BHigh matchCODE-CExpiredApps Script · Google Sheets · In testing
Discount codes shared online, spotted and chased.
A weekly search for the business’s discount codes shared on voucher sites without permission, feeding straight into cease and desist letters.
- Reads voucher pages and records every code it finds.
- Finds each site’s contact details automatically.
- Letters go through the same approval and follow-up steps.
Google Sheets
An improvements tracker that adds itself up.
One shared list of everything across the business that could be fixed, made easier or automated, reviewed together once a month.
- Overview counts that update themselves.
- Overdue items highlighted automatically.
- A record of every review meeting and what was agreed.
Improvements tracker
Supplier tax details
US businessNon-US individualFull nameSupplier ACountryUnited KingdomTax number••••••••Sign and submitForm W-8BEN
Ref TAX-0007e-signedGoogle Forms · Apps Script · IRS forms · In testing
US tax forms that fill themselves in.
One form that collects W-9 and W-8 details from suppliers, contractors and creators, then fills in the official IRS form for them. It takes the back-and-forth out of setting up new suppliers and helps keep the business compliant.
- Asks a few simple questions, then routes each person to the right IRS form for where they are based.
- Fills in the official PDF, adds an electronic signature record and files it with its own reference.
- Checks the details as they go and flags anything that needs a second look.
PowerShell · Command line · Microsoft Graph API
PowerShell scripts that look after Microsoft 365.
Scripts run from the command line that handle Microsoft 365 jobs in bulk, connecting to the Microsoft Graph API with API keys.
- Sets up users, access and licences for new starters in one go.
- Moved users and mailboxes across during a company-wide domain migration.
- Pulls reports of users, licences and mailboxes straight into a spreadsheet.
licence-report.csv
User ALicensedUser BLicensedUser CNew starterHow an automation project works
Tell me the boring bit. We can make it run itself.
A chat
What takes too long, gets forgotten or relies on someone remembering to do it.
Map it out
Who fills what in, where it needs to go and who needs to know.
Build and test
Forms, scripts, sheets and emails, tested with real examples before anyone relies on them.
Switch it on
Set up in your own Google account, so it stays yours.
Handover
A short guide, and help when something needs changing.
Got a job that should run itself?
Tell me what you do over and over again. If it can be automated, I will show you how.
Get in touch