9 Google Apps Script Automations That Save Hours in Google Workspace

If your business runs on Google Workspace, you already have a free automation engine built in. Google Apps Script automation uses JavaScript to connect Sheets, Gmail, Docs, Drive, Calendar and Forms, and it can call outside APIs too. No extra subscription is required, which makes it ideal for small teams that want to remove repetitive admin without adding another tool.

What is Google Apps Script?

Apps Script is a cloud-based scripting platform from Google. Scripts run on Google's servers, either attached to a file (a bound script) or as a standalone project. They can be started manually, from a custom menu, or automatically by triggers.

Types of triggers

• Simple triggers such as onOpen and onEdit run automatically but have limited permissions.

• Installable triggers can run on form submission, on edit, on calendar changes or on a time schedule, with full permissions.

• Time-driven triggers run every few minutes, hourly, daily or weekly, which is perfect for reports and clean-ups.

9 practical automations

1. Form submission to email and CRM

When someone submits a Google Form, a script emails the right team member, adds a row to a lead tracker and sends the lead to your CRM through a webhook.

2. Generate PDFs from a Docs template

Fill a Google Docs template with data from a spreadsheet row, such as a proposal, contract or certificate, convert it to PDF, save it to Drive and email it to the client.

3. Daily KPI report by email

A time-driven trigger collects yesterday's numbers from several sheets and emails a formatted summary to managers each morning.

4. Overdue task reminders

A script scans a task sheet for due dates in the past and status not marked done, then emails each owner a list of their overdue items.

5. Invoice and payment follow-up

Track invoices in a sheet and send polite reminders at set intervals after the due date. See automated payment reminders for message timing.

6. Gmail parsing and labelling

Read incoming emails from a specific sender, extract order numbers or amounts, write them to a sheet and apply a label so the inbox stays tidy.

7. Calendar booking summaries

Pull upcoming meetings from a shared calendar and post a daily schedule to a team chat or email.

8. Data cleaning and deduplication

Standardise phone formats, trim spaces, fix capitalisation and flag duplicate rows on a schedule.

9. Sync with external APIs

Using UrlFetchApp, a script can pull data from tools like GoHighLevel, Stripe or a shipping provider, or push sheet data into them.

Mid-article CTA: Have a spreadsheet process your team repeats every week? Book a free audit call and we will tell you whether Apps Script can automate it.

Limits you should know

Apps Script is free but has quotas. Notable ones include a maximum run time per execution (currently six minutes for most accounts), daily limits on emails sent and on URL fetch calls, and limits on trigger run time per day. Workspace accounts usually get higher limits than free Gmail accounts. Check Google's current quota page before designing high-volume automations.

Apps Script vs n8n, Make or Zapier

A common pattern is to use Apps Script for Google-native tasks and a workflow platform for cross-app orchestration.

Best practices

• Store API keys in Script Properties, never in the code.

• Add error handling with try and catch, and email yourself on failures.

• Process data in batches using getValues and setValues instead of reading cells one by one.

• Keep a changelog and use version history.

• Share scripts from a company account, not a personal one, so automations survive staff changes.

Frequently asked questions

Is Google Apps Script free? Yes, it is included with Google accounts and Workspace, within daily quotas.

Do I need to know how to code? Basic JavaScript helps. Many simple scripts can be adapted from examples, but business-critical automations benefit from a developer.

Can Apps Script connect to my CRM? Yes. It can send and receive data from any CRM with a REST API or webhooks.

What happens if the person who created the script leaves? Triggers run under the creator's account. Transfer ownership to a shared company account before staff leave.

Get more from Google Workspace

Calari Solutions builds reliable Google Apps Script automations with error alerts and documentation, and connects them to your CRM and other tools. Schedule a free audit call to find the spreadsheet tasks costing your team the most time.