Zappy Docs

Delete Spreadsheet value

Zappy.ZappyActions.GoogleSpreadSheet

Delete the value or values from the selected range in 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.

Range –
Range can be set in two ways:

  1. Set as !A2:F means from 1st column 2nd row to 6th column 2nd row.
  2. To set text for particular cell set as !A3 i.e. 1st column and 3rd row.

JsonFilePathofSheet – Path of the .json file.

📘

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 3 months ago


Delete 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.