Connect Pensight and Google Sheets to unlock the power of automation

Create a new row in a specific spreadsheet.

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

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

Format a row in a specific spreadsheet.

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.

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

Finds or creates a specific find worksheet.

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

Creates a new worksheet by copying an existing worksheet.

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

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.

Find a specific spreadsheet row based on a column and value. If found, it returns the entire row. Optionally, create a new row if no match is found.

Finds or creates a specific lookup row.