Skip to main content
Go to the Studio
Spreadsheets

Get spreadsheet

Get spreadsheet

Gets the metadata of a spreadsheet by its ID.


Options​

Google Sheets connection​

Select the Connection action set up in the flow.

Spreadsheet ID​

Enter the ID of the spreadsheet to get. The ID can be found in the spreadsheet URL: docs.google.com/spreadsheets/d/{spreadsheetId}/edit.

Returns​

Javascript code​

js
actions["action-id"].spreadsheetId // ID of the spreadsheet read (Text)
actions["action-id"].title // Title of the spreadsheet read (Text)
actions["action-id"].spreadsheetUrl // URL of the spreadsheet read (Text)
actions["action-id"].sheets // List with the id, title and index of the spreadsheet's tabs (List)

Field selection​

  • spreadsheetId — ID of the spreadsheet read (Text)
  • title — Title of the spreadsheet read (Text)
  • spreadsheetUrl — URL of the spreadsheet read (Text)
  • sheets — List with the id, title and index of the spreadsheet's tabs (List)

Rules and Conditions​

  • The Google Sheets connection and Spreadsheet ID fields are required.
  • If the given spreadsheet is not found (a response with no ID or URL), the robot stops with an error.