Delete Spreadsheet value


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

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