Google Sheets

Integrate your Workflow with Google Sheets

The Google Sheets integration allows you to create and retrieve Sheets within the connected Drive account.

Create Spreadsheet

1. Parent Folder (Optional): choose a folder to create the spreadsheet in

2. Title: the title of the created spreadsheet

3. JSON Data (Array of Objects): the content to populate the rows and columns, supports JSON

Example

Arcade

Retrieve Spreadsheet

1. Google Sheets URL Enter the full Google Sheets URL (e.g., https://docs.google.com/spreadsheets/d/1ABC123.../edit?gid=0)

2. Start Row Index (Optional) Optional starting row index (0-based). Leave empty to start from the beginning of the sheet.

3. End Row Index (Optional) Optional ending row index (exclusive). Leave empty to include all rows to the end of the sheet.

4. Start Column Index (Optional) Optional starting column index (0-based). Leave empty to start from the first column.

5. End Column Index (Optional) Optional ending column index (exclusive). Leave empty to include all columns to the end of the sheet.

Example

Example of Retrieve Spreadsheet Action