Google Sheets

Google Sheets is an online spreadsheet application that lets you create and manage spreadsheets and share them with other users.

Note: This connector currently uses a custom authentication scheme. To enable the default OAuth-based authentication, the associated OAuth application must first be approved by Google.

The approval process is ongoing, and once approved, the default authentication method will be enabled for this connector.

Triggers

  • New Spreadsheet Row: Triggers when a new row is added to the specified spreadsheet

Actions

  • Add Multiple Rows: Add multiple rows in the specified spreadsheet

  • Add Row: Add row to the specified spreadsheet

  • Create Sheets: Create one or more sheets in the specified spreadsheet

  • Create Spreadsheet: Create a new spreadsheet

  • Delete Rows Or Columns: Delete the specified rows or columns from the spreadsheet

  • Delete Sheets: Delete the specified sheets from a spreadsheet

  • Get Rows: Retrieve the specified rows from a spreadsheet

  • Get Sheets: Retrieve the details of specified sheets from a spreadsheet

  • Update Rows: Update specified rows of a spreadsheet

Common Questions

How to add multiple rows in a spreadsheet?

You can add multiple rows to a Google Sheets spreadsheet by using the 'Add Rows' or 'Update Rows' action. You can provide input for multiple rows by entering either multi line CSV values or an array of JSON array.