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.

Illustrative, details changed

Refund request

Order number#10482Refund amount£24.00Sort code••-••-••Account number•••• 1234Submit
PDF

REF-2026-0014

Finance inboxHubdocXero
Confirmation sent to the customer

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
  • PDF
  • Gmail
  • Hubdoc and Xero

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.
  • Google Forms
  • Apps Script
  • Validation
  • Fraud checks
Illustrative, details changed

Creator payment details

BusinessPersonalBank countryUnited StatesRouting number9 digitsSWIFT / BIC8 or 11 charactersSubmit
PDF

For finance

Before payingBank details changed? Call to check before you pay.
Illustrative, details changed
Cyber safety training
  1. Spotting phishing
  2. Passwords and sign-in
  3. Safe payments
  4. Customer data
  5. Reporting an incident

Quiz

Question 8 of 12Passed · 11 of 12Next due in 6 months

Training tracker

Team member APassedTeam member BDue soonTeam member COverdue

Apps 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
  • Web app
  • Google Sheets
  • Google Forms
  • UK GDPR

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.
  • Apps Script
  • Google Sheets
  • Gmail
  • Google Drive
  • Web search
  • PDF
Illustrative, details changed

Listings found

Listing AStrong matchListing BCheck by handListing CStrong matchListing DRemoved
PDF

Infringement notice

Our ref NTC-0007
ApprovedSentReplyFollow-up
Illustrative, details changed
Voucher site
10% off everythingCODE-A15% off your orderCODE-BExpiredCODE-C

Discount codes found

CODE-ANewCODE-BHigh matchCODE-CExpired
Contact email found

Apps 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.
  • Apps Script
  • Google Sheets
  • Web search
  • Gmail

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.
  • Google Sheets
  • Formulas
  • Dropdowns
  • Process improvement
Illustrative, details changed

Improvements tracker

12Open4In progress2Overdue3Done this month
IMP-001Link the shop to the accountsIn progressIMP-002Bank transfer refund formDoneIMP-003Supplier price checksOverdueIMP-004Onboarding checklistOpen
Illustrative, details changed

Supplier tax details

US businessNon-US individualFull nameSupplier ACountryUnited KingdomTax number••••••••Sign and submit
PDF

Form W-8BEN

Ref TAX-0007e-signed
Filed in DriveRegister updated

Google 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.
  • Google Forms
  • Apps Script
  • IRS W-9 and W-8
  • PDF
  • Compliance

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.
  • PowerShell
  • Command line
  • Microsoft Graph API
  • API keys
  • Microsoft 365
Illustrative, details changed
PowerShell
PS C:\Scripts> Connect-MgGraphPS C:\Scripts> .\New-Starters.ps1 -File starters.csv✓ 3 users created, licences assignedPS C:\Scripts> .\Licence-Report.ps1✓ Saved licence-report.csv

licence-report.csv

User ALicensedUser BLicensedUser CNew starter

How an automation project works

Tell me the boring bit. We can make it run itself.

  1. A chat

    What takes too long, gets forgotten or relies on someone remembering to do it.

  2. Map it out

    Who fills what in, where it needs to go and who needs to know.

  3. Build and test

    Forms, scripts, sheets and emails, tested with real examples before anyone relies on them.

  4. Switch it on

    Set up in your own Google account, so it stays yours.

  5. Handover

    A short guide, and help when something needs changing.

  • Google Apps Script
  • Google Forms
  • Google Sheets
  • Gmail
  • Google Workspace
  • PowerShell
  • Microsoft Graph API

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