Executing the list data obtained from the spreadsheet as the BOT input value (group data)

Home > Connect > Make > Executing the list data obtained from the spreadsheet as the BOT input value (group data)
Creating a scenario
Creates a scenario that sequentially writes to a spreadsheet using the list data obtained in the cloud BOT.

Google Sheets(Search Rows)
Obtain the row data of a spreadsheet.
Array aggregator
Convert the data for the number of rows obtained by Search Rows to an array.
Cloud BOT(Execute BOT)
Executes BOT with the array output by the Array aggregator as the input value (group data).
Setting Google Sheets
- Click "Create a new scenario".

2. Click "+" icon and type “Google Sheets” in the search box and select it.

3.Select "Search Rows".

4. Set the"Search Rows" settings.
In this case, set a spreadsheet with list data.
Create a Google connection and specify "Spreadsheet" and "Sheet".

5. Click "Run Once" to confirm the operation. If you can confirm the execution result, the setting is complete.

Setting Array aggregator
- Click“Add another module” next to the module, then type "Array aggregator" in the search box and select it.

2. Set the Array aggregator settings.
In this example, "Search Rows" set in the previous module is specified as "Source Module".
In "Aggregated fields", the columns required as data to be passed to the Cloud BOT from the column names in the sheet range specified in "Search Rows" are specified.


The execution result is as follows.

Setting Cloud BOT
- Click"Add another module" next to the module, then type “Cloud BOT" in the search box and select it.

2.Select "Execute BOT".

3. Create a Cloud BOT connection and set the Execute BOT settings. Refer to this page about detailed settings.

4. Specify the input value of the BOT.
Map is enabled so that array data can be specified directly.
The array data specified here is the array output from the Array aggregator using the map function and formatted so that it can be used as the input value (group data) for the Cloud BOT.


5.Now, the connection scenario is created. Click "Run Once" and confirm the operation.
The execution result is as follows.

