Read Row

Read the values from a specific row.

Options

Field Definition Type Required
Use Spreadsheet ID? Option to specify a Google Sheets spreadsheet by ID.

If you select No, select a spreadsheet from the Spreadsheet dropdown and ignore the Spreadsheet ID field.

If you select Yes, the list of spreadsheets from your account in the Spreadsheet dropdown will be depopulated; select -- Enter Spreadsheet ID -- from the Spreadsheet dropdown and enter an ID in the Spreadsheet ID field.

The Spreadsheet ID is the last string of characters in the URL for your spreadsheet. For example, in the URL https://docs.google.com/spreadsheets/d/1qpyC0XzvTcKT6EISywvqESX3A0MwQoFDE8p-Bll4hps/edit#gid=0, the spreadsheet ID is 1qpyC0XzvTcKT6EISywvqESX3A0MwQoFDE8p-Bll4hps.

 Dropdown TRUE
Spreadsheet List of spreadsheets in your Google Sheets account.
Caution

Due to an API limitation, a maximum of 100 spreadsheets are returned in a search. To search for a specific spreadsheet, use the Enter Spreadsheet ID option.

 Dropdown TRUE
Spreadsheet ID Unique identifier for your selected spreadsheet. String FALSE
Worksheets List of worksheet tabs in the spreadsheet. Dropdown TRUE

Input

Field Definition Type Required
Number Location number of the row. Number FALSE

Output

Value of each cell from the row number entered above. The output display names reflect the values of the column headers.

Related topics

© 2021 Okta, Inc. All Rights Reserved. Various trademarks held by their respective owners.

© 2021 Okta, Inc. All Rights Reserved. Various trademarks held by their respective owners.

Google Sheets API documentation