Executing a BOT when a new row is added to a spreadsheet

 Home > Connect > Make > Executing a BOT when a new row is added to a spreadsheet

Creating a scenario

Creates a scenario that executes a particular BOT when a new row is added to a spreadsheet.

Setting Google Sheets

1. Click "Create a new scenario".

2. Type “Google Sheets” in the search box to locate and set it as a trigger.

3. Select a trigger type. In this example, select "Watch Rows".

4. Click "Add" in the "Connection" section and click "Continue".

5. Create a Google Sheets connection.

In the authorization request screen, check the terms of use and privacy policy, then click the [Allow] button.

6.Set settings such as a trigger sheet, header settings, and range, click "OK".

7. Click "Run Once" to confirm the behavior.

8. If you can confirm the execution result, the trigger setting is complete.

Setting Cloud BOT

1. When you mouse over the icon on the right side of Google Sheets, "Add another module" is displayed. Click "Add another module" to add a new module. Search “Cloud BOT” in the search box and select it.

2. Select "Execute BOT".

3. Set "Connection", "Language", "Contract", "BOT" and input values for the BOT. Refer to this page about setting values.

4. Now the connection scenario is created. With "Run Once" confirm the behavior. If you can confirm the execution result, the setting is complete.