Clear data from a Google Sheet step

# What to use the Clear data from a Google Sheet step for

This step clears the contents of the selected cell range while preserving formatting in a Google sheet. Use this step to clear data stored in a Google sheet rather than deleting rows.

You can use this step to:

  • Clear values from a Google Sheet

# How to configure the Clear data from a Google Sheet Step

# Spreadsheet

Select a Google Sheet to clear, or paste its URL here. You can also use 'Insert data' to pass spreadsheet URLs into this step.

# Sheet name

Leave blank to use the first sheet or select a sheet name.

# First cell

Enter a column and row number if you wish to start your write operation from a particular cell in your Google Sheet. For example, 'B10' will mean your bot will start reading data from the second column on the 10th row.

# Last Cell

Enter a column and row number combination if you wish to stop the write operation at a particular cell in your Google Sheet. For example, 'B100' will mean your bot will stop reading data at the 100th-row in the second column.

Configuration settings

    Step type

    Spreadsheet