Creates a new spreadsheet row at the top of a spreadsheet (after the header row).

Apply conditional formatting to cells in a Google Sheets spreadsheet based on their values.

Creates a new worksheet in a Google Sheet.

Permanently delete a worksheet from a Google Sheets spreadsheet. Warning: This action cannot be undone.

Apply date, number, or style formatting (colors, bold, italic, strikethrough) to a range of cells in a Google Sheets spreadsheet.

Rename a worksheet in a Google Sheets spreadsheet.

Sort data within a specified range in Google Sheets by a chosen column in ascending or descending order.

Update one or more rows in a specific spreadsheet (with line item support).

Find up to 500 rows based on a column and value as line items.

Finds a worksheet by title.

Return up to 1,500 rows as a single JSON value or as line items.

Get a specific Google Spreadsheet by its ID. Returns the raw spreadsheet data from the Google Sheets API.

Finds a spreadsheet by name, or creates one if none is found.

Finds or creates a specific lookup row.

Triggers when a contact submits a form. A form with a keyword also triggers Keyword Applied, in either order.

Triggers when a contact leaves a Smart List: removed by hand or by the list's filters. Deleting a Smart List doesn't trigger it.

Adds a contact to a campaign, which schedules the campaign's messages for them.

Archives a contact. Archived contacts can't be sent messages or emails, and their incoming messages are rejected, until they're unarchived.

Removes a contact from a campaign and cancels the campaign's scheduled messages to them.

Sends a text, picture message, voicemail drop, or email template to a contact. It shows in your chat with the contact.

Updates an existing contact, found by phone number, email address, or contact ID. Fields left empty keep their current values.

Finds up to 100 contacts by tag and archived status.

Update Google Sheets properties like frozen rows/columns, sheet position, and visibility settings.

Copy data from one range to another within a Google Sheets spreadsheet, with options for what to paste (values, formatting, etc.).

Clears the contents of the selected row(s) while keeping the row(s) intact in the spreadsheet.

Deletes the selected row(s) from the spreadsheet. This action removes the row(s) and all associated data.

Format a row in a specific spreadsheet.

Set data validation rules on a range of cells in Google Sheets to control what data can be entered.

Update a row in a specific spreadsheet with optional formatting.

This is an advanced action which makes a raw HTTP request that includes this integration's authentication.

Finds a spreadsheet by name.

Get data from a specific range in a Google Spreadsheet using A1 notation (e.g., "A1:D10", "B2:E5").

Get a specific spreadsheet row by its row number (ID). Row 1 is typically the header row.

Find a specific spreadsheet row based on a column and value. If found, it returns the entire row.

Finds or creates a specific find worksheet.

Triggers when a contact texts a keyword, or a keyword is applied to a contact by you, the API, a campaign, or a form. If your account requires double opt-in, a contact who has not opted in triggers it when they opt in.

Triggers when a contact joins a Smart List: added by hand, by the list's filters, or by a keyword.

Adds one or more tags to a contact. Archived contacts are skipped.

Applies a keyword to a contact, running the keyword's actions as if the contact had texted it.

Creates a new contact. Use Find or Create Contact instead if the contact might already exist. Fails if an archived contact has the phone number.

Removes one or more tags from a contact. Tags the contact doesn't have are ignored.

Unarchives a contact, returning them to your contact lists. Their Do Not Message, Do Not Email, and Do Not Message Me settings are left as they are; use Update Contact to change them.

Finds a contact by phone number, email address, or contact ID. Archived contacts aren't found.

Finds a contact by phone number, email address, or contact ID, or creates one if none is found. Fails if an archived contact has the phone number; unarchive it in Project Broadcast first.