Skip to main content

Google Drive Read Spreadsheet

Reads data from a specific range in a Google Spreadsheet using the Google Sheets API.

Category: Google Drive & Gmail · Group: Google Drive · Activity name: GoogleDriveReadSpreadsheet

The GoogleDriveReadSpreadsheet activity in the designer

Example

outputVariable = GoogleDriveReadSpreadsheet("<spreadsheetId>", "<range>")

Inputs

NameTypeRequiredDefaultDescription
Spreadsheet IdstringYesThe unique identifier of the Google Spreadsheet you want to read from. You can find it in the spreadsheet's URL.
RangestringYesThe cell range to read from, in A1 notation (e.g., 'Sheet1!A1:D10').

Outputs

NameTypeDescription
outputVariablearraySpecifies the name of the variable that will store the content of range.