Resources / Automation Tools

Google Apps Script

Write JavaScript that automates Google Sheets, Docs, Gmail, Forms and Calendar.

Google Apps Script is a free scripting platform from Google that runs JavaScript on Google's servers. It lets you add custom functions, menus and automations to Google Workspace apps without setting up any hosting.

Good for

  • A shop's stock spreadsheet that emails the owner when an item falls below a set level
  • A school's admissions form in Google Forms that sends each parent a confirmation email
  • Building a weekly summary in Google Docs from figures in a sheet
  • Small web apps or webhook endpoints that write incoming data into a sheet

Good to know

Apps Script is free with a Google account, but Google applies daily quotas, such as limits on emails sent and on how long a script may run. Scripts belong to the account that created them, so keep important ones under a shared business account rather than one staff member's.

Works well with: JavaScript, n8n and Make.

More like this

Trending Freemium

n8n

Visual workflow automation for apps, APIs and AI, self-hosted or in the cloud.

#automation #workflows #self-hosted

Freemium

Zapier

Connects web apps so an event in one app runs actions in others, with no code.

#automation #no-code #integrations

Freemium

Make

A visual builder for multi-step automations, with branching, filters and data mapping.

#automation #no-code #workflows

Paid

Microsoft Power Automate

Microsoft's tool for automating work across Microsoft 365, other apps and Windows.

#automation #microsoft #rpa

You're offline. Some things won't load until you reconnect.
Chat on WhatsApp

SparkWorld

+254 110 757 810

Chat with us on WhatsApp

Before we open WhatsApp, leave your name and number.

Why we ask

  • On a computer, WhatsApp only opens if WhatsApp Web is linked to your phone, and you may not be logged in.
  • So we don't lose you: if the chat doesn't start, we'll message you first.
  • We only use your details to reply to you.
Skip and open WhatsApp now