Apps Script APIs

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.

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

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

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

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

Create Google Forms and read or update form responses.

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

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

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

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

Detect language and translate text with Google's translation service.

Model and solve linear and mixed-integer linear optimization problems.

Serialize concurrent script execution with document, user, or script locks.

Write messages to the Apps Script execution log for debugging.

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

Geocode addresses, get directions, sample elevation, and build static map images.

Reference common MIME type constants for blobs, files, and exports.