Connect Google Sheets and PowerTools to power AI-driven automation

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 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 or creates a specific find worksheet.

Add an item to a collection

Determine if any items in a collection contain a specific string

Determine if any items in a collection start with a specific string

Convert a collection to an XML string

Filter a collection of strings by keyword

Remove an item from a collection

Sort a collection of strings

Convert a CSV string a JSON object

Filter a comma-delimited string using field names and/or regular expressions

Convert a JSON array to a CSV string

Convert a JSON array to an XML string

Query an XML string using an XPath expression

Convert an XML string to a JSON object

Retrieve useful date and time information, such as day of year, total seconds and ticks

Convert date and time from one time zone to another

Compress a file (20MB max)

Remove specified areas from an image

Flip an image (horizontal or vertical)

Retrieve EXIF metadata from an image

Change the dimensions of an image file

Add watermark text to an image

Apply currency symbol to a numeric value

Get current and historical stock price information

Retrieve the approximate latitude/longitude matching a full or partial address

Get time zone information for a full or partial address

Calculate the sum of two numbers

Calculate the cosine value of an angle

Calculate the logarithm of a number

Calculate the minimum or maximum value in a sequence of numbers

Calculate the product of two numbers

Raise number to a specified power

Calculate the square root of a number

Calculate the sum of two or more numbers

Calculate the variance of two or more numbers

Convert value from one measurement to another

Convert value from one measurement to another

Convert value from one measurement to another

Convert value from one measurement to another

Convert value from one measurement to another

Round a numeric value up or down

Automatically correct text (1024 char max)

Determine if a string contains another string

Decode a Base64 encoded string

Encode a string using Base64 encoding

Generate a hash value from a string

Join a collection of strings into a single string

Extract values from a string of text using Regular Expressions

Replace one value with another in a string

Convert audio file to text (10MB limit)

Create a file from a string of text

Translate a string into a different language

Decode an encoded URL

Determine if an email address is valid

Get general weather outlook near an address or location for certain types of activities

Get daily weather forecast near an address or location

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

Creates a new worksheet by copying an existing worksheet.

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.

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 lookup row.

Determine if any items in a collection contain a specific number

Determine if any items in a collection end with a specific string

Convert a collection to a named JSON object

Count a collection of items

Remove duplicates from a collection

Replace whole or partial strings in a collection

Split a collection of items by matching value or index

Convert a CSV string an XML string

Format (prettify) a string of JSON data

Convert a JSON array to an HTML table

Query a JSON object using a JSONPath expression

Determine if a JSON string represents a valid data object

Calculate the difference between two dates

Create a date/time string in a specific format

Layer a foreground image over a background image

Convert an image from one format to another

Convert a file to a Base64 string

Generate a QR code image

Scan image for adult or obscene content

Rotate an image by specified number of degrees

Calculate monetary value in a different currency

Get current and historical market index information

Physical location of a public IP address (by country)

Generate a map image from an address

Calculate the absolute value of a number

Calculate the average of two or more numbers

Calculate the quotient of two numbers

Calculate the median of two or more numbers

Calculate the remainder of dividing two numbers

Calculate the n-th root of a number

Calculate the sine value of an angle

Calculate the difference between two numbers

Calculate the tangent value of an angle

Convert value from one measurement to another