Zappy Docs

Get Spreadsheet Value

Zappy.ZappyActions.GoogleSpreadSheet

Get value/text from set cell of Google Spreadsheet.

Properties

INPUT

SpreadsheetId – Id of the Google Spreadsheet.
(If we are using this Google Spreadsheet https://docs.google.com/spreadsheets/d/1lsOQPyREfFyyKWldbda4icaXq9aCsnTvBIMUCERcqtk/edit#gid=1384351220
Then Spreadsheet Id is 1lsOQPyREfFyyKWldbda4icaXq9aCsnTvBIMUCERcqtk)

SheetName – Google Spreadsheet name.

CellAddress – Address of the cell (eg !A2).

JsonFilePathofSheet – Path of the .json file.

OUTPUT

Value – Value of the set address.

📘

To get json file follow the steps below:

  1. Go to the Google APIs Console.
  2. Create a new project.
  3. Click Enable API. Search for and enable the Google Drive API and the Google Sheets API.
  4. Create credentials for a Web Server to access Application Data.
  5. Name the service account and grant it a Project Role of Editor.
  6. Download the JSON file.

Updated about a year ago


Get Spreadsheet Value


Zappy.ZappyActions.GoogleSpreadSheet

Suggested Edits are limited on API Reference Pages

You can only suggest edits to Markdown body content, but not to the API spec.