Clears values from a spreadsheet. The caller must specify the spreadsheet ID and range. Only values are cleared -- all other properties of the cell (such as formatting, data validation, etc..) are kept.
Add a step and choose the Google Sheets connector.
Pick the Sheets.spreadsheets.values.clear action (under spreadsheets).
Fill in the fields below, then reference the result from later steps as {{sheetsSpreadsheetsValuesClear.response.data}}.
Request
Path parameters
spreadsheetIdstringrequired
The ID of the spreadsheet to update.
rangestringrequired
The [A1 notation or R1C1 notation](/sheets/api/guides/concepts#cell) of the values to clear.
Query parameters
$.xgafvstring
V1 error format.
One of12
access_tokenstring
OAuth access token.
altstring
Data format for response.
One ofjsonmediaproto
callbackstring
JSONP
fieldsstring
Selector specifying which fields to include in a partial response.
keystring
API key. Your API key identifies your project and provides you with API access, quota, and reports. Required unless you provide an OAuth 2.0 token.
oauth_tokenstring
OAuth 2.0 token for the current user.
prettyPrintboolean
Returns response with indentations and line breaks.
quotaUserstring
Available to use for quota purposes for server-side applications. Can be any arbitrary string assigned to a user, but should not exceed 40 characters.
upload_protocolstring
Upload protocol for media (e.g. "raw", "multipart").
uploadTypestring
Legacy upload protocol for media (e.g. "media", "multipart").
Response
Returns 200 with an object. Read it in later steps with {{sheetsSpreadsheetsValuesClear.response.data.<field>}}.
clearedRangestring
The range (in A1 notation) that was cleared. (If the request was for an unbounded range or a ranger larger than the bounds of the sheet, this will be the actual range that was cleared, bounded to the sheet's limits.)
