​
Add the ‘Delete Rows’ Tool step to your Tool

You can add the ‘Delete Rows’ Tool step to your Tool by:
  1. Creating a new Tool, then searching for the ‘Delete 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 delete the rows in.
    • Select the worksheet you would like to delete the rows in.
  4. Enter the row number you want to start deleting from.
  5. Enter the row number you want to stop deleting 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
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.Google Sheets Delete Rows

​
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).
You can use this tool to parse the worksheet, spreadsheet and drive IDs from a url
​
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=).
You can also use this tool to parse the worksheet, spreadsheet and drive IDs from a url
​
Start Row
number
required
The row number you want to start deleting from (inclusive).
​
End Row
number
required
The row number you want to stop deleting at (exclusive).
Example: If you want to delete rows 1 to 5, you would enter 1 for “Start Row” and 6 for “End Row”.

​
Frequently asked questions (FAQs)