Google Apps Script
by Google LLC
Free JavaScript-based scripting platform for automating Google Workspace applications including Sheets, Gmail, Docs, Forms, Calendar, and Drive. Google Apps Script is a server-side JavaScript platform for automating and extending Google Workspace applications. Launched in 2009, Apps Script runs on Google Cloud infrastructure and provides direct access to Google Sheets, Gmail, Google Docs, Google Forms, Google Calendar, Google Drive, and Google Slides through built-in service objects.
Key Facts
technical
| Attribute | Value | As of | Source |
|---|---|---|---|
| Workspace account quotas (May 2026) | Google Workspace quotas: 30-minute execution limit, 6-hour daily runtime, 1,500 email recipients/day, 100,000 URL Fetch calls/day | May 2026 | Google Apps Script quotas documentation |
| Consumer account quotas (May 2026) | Consumer (Gmail) quotas: 6-minute execution limit, 90-minute daily runtime, 100 email recipients/day, 20,000 URL Fetch calls/day | May 2026 | Google Apps Script quotas documentation |
pricing
| Attribute | Value | As of | Source |
|---|---|---|---|
| Apps Script pricing (July 2026) | Google Apps Script re-confirmed free July 2026: no paid tiers and no per-execution charge; it is included with any Google account and with Google Workspace subscriptions. Organisational use is gated behind a Google Workspace plan (Business Starter/Standard/Plus), whose list prices are region-served. | Jul 2026 | Google Apps Script docs |
| Pricing model (May 2026) | Google Apps Script is free: no paid tiers and no per-execution charges; included with every Google account (consumer and Workspace) | May 2026 | Google Apps Script developer site |
General
| Attribute | Value | As of | Source |
|---|---|---|---|
| Launched | 2009 | May 2026 | |
| Pricing | Free — included with Google Workspace | Jul 2026 | Google Workspace Apps Script product page |
| Execution Limit | 6 minutes per execution (consumer and Workspace) | Jul 2026 | Google Apps Script quotas documentation |
| Daily Quota | 90 minutes total runtime/day (consumer accounts) | Jul 2026 | Google Apps Script quotas documentation |
| Language | JavaScript (V8 runtime engine) | May 2026 | |
| Triggers | Time-driven (cron) and event-driven triggers | Jul 2026 | Google Apps Script triggers documentation |
| Workspace Integration | Sheets, Docs, Gmail, Forms, Calendar, Drive, Slides | Jul 2026 | Google Workspace Apps Script product page |
| Deployment | Cloud-only (Google infrastructure) | May 2026 |
About Google Apps Script
Google Apps Script is a server-side JavaScript platform for automating and extending Google Workspace applications. Launched in 2009, Apps Script runs on Google Cloud infrastructure and provides direct access to Google Sheets, Gmail, Google Docs, Google Forms, Google Calendar, Google Drive, and Google Slides through built-in service objects. Scripts can create custom spreadsheet functions, automate email workflows, generate documents from templates, build simple web applications, and interact with external REST APIs.
Apps Script supports two types of triggers: time-driven triggers (equivalent to cron jobs, running scripts at specified intervals from every minute to monthly) and event-driven triggers (firing on form submissions, spreadsheet edits, calendar event changes, or document opens). The V8 runtime engine supports modern JavaScript syntax including arrow functions, template literals, destructuring, and async/await. Scripts can also use the UrlFetchApp service to call external REST APIs, enabling integration with third-party services.
Google Apps Script is included at no cost with every Google Workspace account (personal Gmail and paid Workspace plans). Execution limits apply: each script execution has a 6-minute maximum runtime for consumer accounts (30 minutes for Google Workspace accounts), and total daily runtime is capped at 90 minutes for consumer accounts. These quotas constrain large-scale data processing but are sufficient for most business automation use cases. There is no visual flow builder — all automation is created through code in a browser-based editor.
Integrations (8)
Other Spreadsheet Automation Tools
Airtable
Cloud platform combining spreadsheet interfaces with relational database structure and built-in automation
Spreadsheet AutomationCoda
All-in-one document platform combining documents, spreadsheets, and workflow automation
Spreadsheet AutomationCoefficient
Live two-way data sync from CRMs, databases, and ad platforms into Google Sheets and Microsoft Excel via a spreadsheet add-in.
Spreadsheet AutomationParabola
No-code data workflows for non-technical teams
Spreadsheet AutomationSee How It Ranks
Questions About Google Apps Script
How do you connect ChatGPT to Google Sheets?
ChatGPT connects to Google Sheets via the OpenAI API using Google Apps Script, via Zapier or Make with the OpenAI and Google Sheets modules, through dedicated Sheets add-ons like GPT for Sheets, or via the n8n OpenAI node. Apps Script offers the most control; add-ons like GPT for Sheets offer the lowest setup effort with inline formulas (=GPT("...")).
What is Retool?
Retool is a low-code platform for building internal tools and business applications. Founded in 2017 by David Hsu, it provides pre-built UI components that connect to databases, APIs, and SaaS applications, enabling developers to build admin panels, dashboards, and CRUD apps without front-end coding.
What are the best Coda alternatives in 2026?
The leading Coda alternatives are Notion (broader workspace features), Airtable (stronger database capabilities), ClickUp (project management focus), and Google Sheets with Apps Script (free and extensible). Notion is the closest feature match for document-database hybrid workflows.
What is Scheduling Automation?
Scheduling automation uses software to manage meeting coordination, appointment booking, resource allocation, and shift scheduling without manual email exchanges. Tools like Calendly save 12-15 minutes per meeting by allowing invitees to self-select available times, while automated reminders reduce no-shows by 20-30%.