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

Spreadsheet Get Value


Suggested Edits are limited on API Reference Pages

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