Clear Rows

The Clear Rows tool step allows you to clear rows in your Google Sheet

Add the ‘Clear Rows’ Tool step to your Tool

You can add the ‘Clear Rows’ Tool step to your Tool by:

1. Creating a new Tool, then searching for the ‘Clear Rows’ Tool step
2. Click ‘Expand’ to see the full Tool step
3. Using the dropdown menu:
   • Select the Google account you would like to use.
   • Select the Drive you would like to use (defaults to “My Drive”).
   • Select the Spreadsheet you would like to clear the rows in.
   • Select the worksheet you would like to clear the rows in.
4. Enter the row number you want to start clearing from.
5. Enter the row number you want to stop clearing at.
6. Click ‘Run step’ to test out the Tool

Using in an Agent

There are 3 ways to configure the tool step when using in an agent

Using dropdown menus

This is the easiest way to configure the tool step. You can select the Drive, Spreadsheet and Worksheet from a list of options via the dropdown menu.

Parameters

Drive · string

The Drive you want to use. By default, the tool uses “My Drive”.

Spreadsheet ID · string · required

To get the spreadsheet ID, navigate to your Google Sheet and copy the ID from the URL (the long string between /d/ and /edit).

Worksheet ID · string · required

To get the worksheet ID, open the specific worksheet you want to use and copy the ID from the URL (appears after #gid=).

Start Index · number · required

The row number you want to start clearing from (inclusive).

End Index · number · required

The row number you want to stop clearing at (exclusive).

Example: If you want to clear rows 1 to 5, you would enter 1 for “Start Index” and 6 for “End Index”.

Frequently asked questions (FAQs)

What is the difference between using the green input variables and the dropdown menu?

The dropdown menu is the easiest way to configure the tool step. You can select the Drive, Spreadsheet and Worksheet from a list of options via the dropdown menu.

The input variables offer more flexibility e.g. you can use the same tool step for multiple Google Sheets, however you will need to manually provide the necessary Google Sheet IDs.

Can I use a mix of both dropdown menu and green input variables?

If you are using the tool in an agent, this is the recommended approach. You can use the dropdown menu to select the Drive, Spreadsheet and Worksheet that don’t need to change, and then use the green input variables for “Start Index” and “End Index” to allow the agent to dynamically clear different rows in your Google sheet.

What is the difference between the Google Sheets clear row and Delete rows tool step?

When you use Delete Rows, the remaining rows shift up to fill the gap. When you use Clear row, the rows are cleared in place (the data is removed, but the rows themselves remain the same).