Zappy

Spreadsheet Get 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.

Spreadsheet Get 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.