Skip to content

All projects

Apps Script Automation Kit

Ten automations ready to run in Google Workspace: mail merge, a PDF from a form, invoices from the inbox, backup and a weekly email.

The problem

The same ten jobs show up for a lot of people: an email from a sheet, a PDF, an invoice moved into Drive.

What I built

  • Mail merge from a sheet.
  • Form, then PDF, then email.
  • Invoices from the inbox into Drive and a sheet.
  • A Drive backup and a weekly indicator email.
  • A dry-run first, so you can see what it would send.

Stack

Google SheetsApps ScriptGmailDrive

Images

The Apps Script automation kit cover.
The list on the cover is what the kit contains.