Skip to main content
Skip table of contents

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_IDAlphanumericNone-Name or ID of the sheet to clear data from.
Tab NameSHEETS_TAB_NAMEAlphanumericNone-Name of the tab in the sheet to clear data from. This field is case sensitive.
Shared Drive NameSHEETS_SHARED_DRIVE_NAMEAlphanumericNone-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_RANGEAlphanumericNone-Range to clear data from in the sheet formatted as `A1:B10`. If left blank the entire tab will be cleared.

YAML

Below is the YAML template

YAML

source:
  template: Google Sheets - Clear Data from Sheet
  inputs:
    SHEETS_SPREADSHEET_ID:
    SHEETS_TAB_NAME:
    SHEETS_SHARED_DRIVE_NAME:
    SHEETS_CELL_RANGE:
  type: TEMPLATE
guardrails:
  retry_count: 1
  retry_wait: 0h0m0s
  runtime_cutoff: 1h0m0s
  exclude_exit_code_ranges:
    - 101
    - 102
    - 200

      
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.