Adding group data obtained by BOT to a spreadsheet
![NO IMAGE](https://docs.c-bot.pro/wp-content/themes/lionblog/img/img_no.gif)
Home > Connect > Zapier > Adding group data obtained by BOT to a spreadsheet
Creating a Zap
Creates a recipe that sequentially writes to a spreadsheet using the list data obtained in the cloud BOT.
![](https://docs.c-bot.pro/wp-content/uploads/2023/08/zapier_usecase05_image_01-1024x300.png)
Cloud BOT(BOT Done)
Retrieves the BOT execution result when a BOT has executed completely.
Spread Sheets(Create Multiple Spreadsheet Rows)
Create multiple rows in the spreadsheet.
Setting Cloud BOT
1. Click "Create" to create a Zap.
![](https://docs.c-bot.pro/wp-content/uploads/2023/08/zapier_common_image_02-1024x569.png)
2. Search for 'Cloud BOT' in the search field of Trigger and click on the icon.
![](https://docs.c-bot.pro/wp-content/uploads/2023/08/zapier_email_image_02-1024x569.png)
3. Select "BOT Done", and click "Continue".
![](https://docs.c-bot.pro/wp-content/uploads/2023/08/zapier_email_image_16-1024x569.jpg)
4. Set the Trigger account and click "Continue".
*Create a Connect if it does not exist. Learn more about creating a Connect here.
![](https://docs.c-bot.pro/wp-content/uploads/2023/08/zapier_email_image_21-1024x569.jpg)
5. Set the Trigger and click "Continue". Refer to this page about setting values.
![](https://docs.c-bot.pro/wp-content/uploads/2023/08/zapier_en_image_17-1024x569.jpg)
6. When the configuration is complete, click "Test trigger" to check the operation.
![](https://docs.c-bot.pro/wp-content/uploads/2023/08/zapier_usecase05_image_08-1024x569.jpg)
Setting Google sheets
1. Search for 'Google Sheets' in the search field of Action and click on the icon.
![](https://docs.c-bot.pro/wp-content/uploads/2023/08/zapier_usecase05_image_07-1024x569.jpg)
2. Select "Create Multiple Spreadsheet Rows", and click "Continue".
![](https://docs.c-bot.pro/wp-content/uploads/2023/08/zapier_usecase05_image_03-1024x569.jpg)
3. Set the Action account and click "Continue".
*Create a Connect if it does not exist.
![](https://docs.c-bot.pro/wp-content/uploads/2023/08/zapier_usecase05_image_04-1024x569.jpg)
4. Set the Action and click "Continue".
In the image example, the rows of the execution results obtained from the "Execute BOT" Output are specified.
![](https://docs.c-bot.pro/wp-content/uploads/2023/08/zapier_en_image_18-1024x786.jpg)
5. When the configuration is complete, click "Test action" to check the operation.
![](https://docs.c-bot.pro/wp-content/uploads/2023/08/zapier_en_image_19-1024x569.jpg)
If you actually check the spreadsheet, it will be written as follows.
![](https://docs.c-bot.pro/wp-content/uploads/2023/08/zapier_en_image_20-1024x115.jpg)