Zappy Docs

Delete Google Spread Sheet Entry


Delete the value or values from the selected range in Google Spreadsheet.



SpreadsheetId – Id of the Google Spreadsheet.
(If we are using this Google Spreadsheet
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 6 months ago

Delete Google Spread Sheet Entry


Suggested Edits are limited on API Reference Pages

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