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

 Home > Connect > Zapier > Executing the list data obtained from the spreadsheet as the BOT input value (group data)

Creating a Zap

Creates a Zap that executes the list data obtained from the spreadsheet as the BOT input value (group data).

Setting Schedule

1. Click "Create" to create a Zap.

2. Click the Schedule icon.

3. Set the Trigger account and click "Continue".

4. When the configuration is complete, click "Test trigger" to check the operation.

Setting Google sheets

1. Search for 'Google Sheets' in the search field of Action and click on the icon.

2. Select "Get Many Spreadsheet Rows", and click "Continue".

3. Set the Action account and click "Continue".
*Create a Connect if it does not exist.

4. Set the Action and click "Continue".

5. When the configuration is complete, click "Test action" to check the operation.

Setting Cloud BOT

1. Search for 'Cloud BOT' in the search field of action and click on the icon.

2. Select "Execute BOT", and click "Continue".

3. Set the Action account and click "Continue".
*Create a Connect if it does not exist. Learn more about creating a Connect here.

4. Set the Action and click "Continue". Refer to here about setting values.
In the image example, the row items obtained from "Get Many Spreadsheet Rows" of 'Google Sheets' are specified.

5. When the configuration is complete, click "Test action" to check the operation.

The execution results can be checked in the Execution log of the Cloud BOT.