Zappy Docs

Get Spreadsheet Value


Get value/text from set cell of Google Spreadsheet.



SpreadsheetId – Id of the Google Spreadsheet.
(If we are using this Google Spreadsheet
Then Spreadsheet Id is 1lsOQPyREfFyyKWldbda4icaXq9aCsnTvBIMUCERcqtk)

SheetName – Google Spreadsheet name.

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

JsonFilePathofSheet – Path of the .json file.


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


Suggested Edits are limited on API Reference Pages

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