What you can automate with Google Workspace

Drag any of these 41 actions into a process – no code, no API wrangling.

Append Rows

Append rows to a sheet

Batch Update Spreadsheet

Batch update - add/delete sheets, format cells, merge, sort, etc.

Clear Sheet Range

Clear values from a range

Copy a file

Copy a Drive file, optionally under a new name or into another folder.

Create a document

Create an empty Google Doc. The answer holds its documentId; use Edit a document to add text.

Create a folder

Create a folder in Drive. The answer holds the folder's id.

Create Draft

Create an email draft (pass message.raw as base64url RFC 2822)

Create Event

Create a new calendar event

Create Spreadsheet

Create a new spreadsheet

Delete a file

Delete a Drive file or folder for good. To keep it recoverable, move it to the bin with Move or rename instead.

Delete Draft

Delete a draft permanently

Delete Event

Delete a calendar event

Download a file from Drive

Download a Drive file and store it, so later steps can read it. Use Export for Google Docs, Sheets and Slides: they have no bytes to download.

Edit a document

Change a Google Doc: insert text, replace text everywhere, delete a range, and so on, as Docs requests.

Export a Google file

Export a Google Doc, Sheet or Slides file to another format (PDF, Word, Excel, CSV, plain text) and store it.

Get Draft

Get a draft by ID

Get Email

Get a full email message by ID

Get Event

Get a calendar event by ID

Get file details

Get one Drive file's details: name, type, size, folders and link.

Get Spreadsheet

Get spreadsheet metadata

List Calendar Events

List events from a calendar

List Calendars

List available calendars

List Drafts

List email drafts

List Emails

List email messages

List files

List or search Drive files. Each item has the file's id, name and type.

List Labels

List Gmail labels

Modify Message Labels

Add or remove labels on an email message

Move or rename a file

Rename a Drive file, or move it to another folder.

Query Free/Busy

Query free/busy status for calendars

Read a document

Read a Google Doc's content and structure.

Read Sheet Range

Read values from a sheet range (e.g. Sheet1!A1:D10)

Send an email

Send an email from the connected Gmail account: To, Subject and Message.

Send Draft

Send an existing draft by ID

Send Email

Send an email (raw RFC 2822 base64url encoded)

Share a file

Give a person, a group or anyone with the link access to a Drive file or folder.

Trash Email

Move an email to trash

Untrash Email

Remove an email from trash

Update a row

Find the row whose column holds a value and change some of its cells, or add the row when none matches. Columns are named by the sheet's first row.

Update Event

Update an existing calendar event

Upload a file to Drive

Upload a stored file to Google Drive. The answer holds the new Drive file's id.

Write Sheet Range

Write values to a sheet range

Google Workspace Integration