Apps Script APIs

Create, open, and modify Google Sheets files, ranges, sheets, and formatting.

Create, open, and edit Google Docs content and structure.

Create Google Forms and read or update form responses.

Write messages to the Apps Script execution log for debugging.

Hash, encode, decode, format dates, sleep, and other helper utilities.

Send email as the user running the script without full Gmail API access.

Make HTTP requests to external APIs and webhooks.

Return text, JSON, XML, or other output from web app doGet and doPost handlers.

Create, find, and manage files and folders in Google Drive.

Search, read, label, and send email in a user's Gmail account.

Manage triggers, OAuth tokens, authorization info, and script publishing.

Serve HTML, CSS, and client JavaScript for dialogs, sidebars, and web apps.

Create and update Google Slides presentations and slide content.

Build Gmail, Calendar, Drive, and Chat add-on action responses and compose actions.

Show simple alert, confirm, and input dialog boxes in Google Sheets.

Temporarily cache expensive computation results for faster repeat runs.

Read and write events on the user's Google Calendar.

Build card-based UIs for Google Workspace add-ons in Gmail, Calendar, and Drive.

Build embedded charts in Google Sheets from script.

Build conferencing data for Calendar add-ons that connect to meeting providers.

Read and update Google Contacts for people and contact groups.

Build and configure Looker Studio (Data Studio) community connector responses.

Query Google Groups membership, roles, and group email addresses.

Connect to external JDBC-compliant SQL databases from Apps Script.