Skip to main content

Google Sheets - Clear Data from Sheet

Overview​

Easily wipe data from a single tab on Google Sheet. Typically used to start fresh before inserting new data.

If you leave the cell range blank, data will be wiped from the entire tab.

If you leave the tab name blank, the data will be cleared from the first tab.

Variables​

NameReferenceTypeRequiredDefaultOptionsDescription
Google Sheet Name or IDSHEETS_SPREADSHEET_IDAlphanumericβœ…--Name or ID of the sheet to clear data from.
Tab NameSHEETS_TAB_NAMEAlphanumericβž–--Name of the tab in the sheet to clear data from. This field is case sensitive.
Shared Drive NameSHEETS_SHARED_DRIVE_NAMEAlphanumericβž–--Name of the Shared Drive the sheet exists in. This field is case sensitive. Leave blank if the file does not exist in a Shared Drive.
Cell RangeSHEETS_CELL_RANGEAlphanumericβž–--Range to clear data from in the sheet formatted as A1:B10. If left blank the entire tab will be cleared.
Service AccountGOOGLE_APPLICATION_CREDENTIALSPasswordβœ…--JSON from a Google Cloud Service account key.

YAML​

Below is the YAML template for this Blueprint and can be used in the Fleet YAML Editor.

source:
blueprint: Google Sheets - Clear Data from Sheet
inputs:
SHEETS_SPREADSHEET_ID: null ## REQUIRED
SHEETS_TAB_NAME: null
SHEETS_SHARED_DRIVE_NAME: null
SHEETS_CELL_RANGE: null
GOOGLE_APPLICATION_CREDENTIALS: null ## REQUIRED
type: BLUEPRINT
guardrails:
retry_count: 1
retry_wait: 0h0m0s
runtime_cutoff: 1h0m0s
exclude_exit_code_ranges:
- '101'
- '102'
- '200'