Delete row Version 3 (Net)

Action group: Google services

Description

The action deletes the specified row with upward shift.

Action icon

Settings of parameters 

Special conditions of use

The Google Sheets API has a limit of up to 60 read-requests per user per minute. To ensure that the action does not immediately generate an error when the limit on the number of requests is reached, the action includes a loop operation that will resend requests within a minute.

• If the request is completed in that time, the action will complete successfully.
• If the request cannot be sent in this time, the robot will terminate with an error.

Example of use

Task

There is a Google spreadsheet:

Delete row "4".

Solution

Use the "Context Google tables", "Delete row" actions.

Implementation

1. Assemble a robot scheme with the actions:
   
2. Set the "Context Google tables" action parameters.
   
   Fill in the "The file path" and "Application name" fields (more about filling in these fields in section Instructions for setting up a connection to Google Sheets/Docs/Drive).
3. Set the "Delete row" action parameters.
   
   In the ID field specify the part of the table's link.
   
4. Click "Start" in the top panel to start the robot.
   
   

Result

The program robot completed successfully.

The desired row is deleted.