Adding group data obtained by BOT to a spreadsheet

NO IMAGE

 Home > Connect > Make > Adding group data obtained by BOT to a spreadsheet

Creating a scenario

Creates a scenario that sequentially writes to a spreadsheet using the list data obtained in the cloud BOT.

Cloud BOT(Watch BOT Done)
Retrieves the BOT execution result when a BOT has executed completely.

Iterator
The subsequent modules are executed sequentially for the number of rows of group data obtained by Watch BOT Done.

Google Sheets(Add a Row)
Adds new row data fetched by the Iterator to the spreadsheet.

Setting Cloud BOT

1. Click [Create a new scenario].

2. Click [+] icon and type “Cloud BOT” in the search box to locate it.

3. Select [Watch BOT Done].

4. Configure the Watch BOT Done settings. Refer to this page about detailed settings.

5. Click [Run Once] to confirm the operation.

6. Execute the BOT on the Created BOT website.

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

Setting Iterator

1. Click [Add another module] next to the module, then type "Iterator" in the search box.

2. Specify the group data (Array) obtained from the cloud BOT in the [Array] field.

Setting Google Sheets

  1. Click [Add another module] next to the module, then type "Google Sheets" in the search box to locate it.

2. Select [Add a Row].

3.

Create a Google connection and specify [Choose a Method], [Choose a Drive], [Spreadsheet ID], [Sheet Name], etc.
In this example, a spreadsheet to add a data row to is specified.

4.  Specify the value in the [Values] field.
Extract the value from the output value of the cloud BOT by specifying [Bundle order position] of the Iterator as a key.

5. Now, the connection scenario is created. With [Run Once] confirm the behavior.

If you actually check the spreadsheet, it will be written as follows.