Executing a BOT when a new row is added to a spreadsheet
![NO IMAGE](https://docs.c-bot.pro/wp-content/themes/lionblog/img/img_no.gif)
Home > Connect > Workato > Executing a BOT when a new row is added to a spreadsheet
Creating a recipe
Creates a recipe that executes a particular BOT when a new row is added to a spreadsheet.
![](https://docs.c-bot.pro/wp-content/uploads/2020/07/spreadsheet_cloudbot-1.png)
Google Sheets(New row in sheet in My Drive)
Triggered when adding a new row to a spreadsheet.
Cloud BOT(Execute BOT)
Executes any BOT.
Setting Google Sheets
1. Click "Create" to create a Recipe.
![](https://docs.c-bot.pro/wp-content/uploads/2023/08/workato_en_use_case_1_01.jpg)
2. Optionally type a recipe name in "Name" and specify "Location", then click "Start building".
![](https://docs.c-bot.pro/wp-content/uploads/2022/11/workato_use_case_1_02.jpg)
3. Search "Google Sheets" in the search box and select the Google Sheets app.
![](https://docs.c-bot.pro/wp-content/uploads/2023/08/workato_en_use_case_2_02.jpg)
4. Select a trigger type. In this example, select "New row in sheet in My Drive".
![](https://docs.c-bot.pro/wp-content/uploads/2023/08/workato_en_use_case_2_03.jpg)
5. Configure the "Connection" settings.
When the Connection is already created, the created connections list is displayed. Refer to this page about creation.
![](https://docs.c-bot.pro/wp-content/uploads/2023/08/workato_en_use_case_2_04.jpg)
6.Configure the "Setup" settings. Specify "Spreadsheet" and "Sheet".
![](https://docs.c-bot.pro/wp-content/uploads/2023/08/workato_en_use_case_2_05.jpg)
7. Click "Test" on the top menu (top right corner) to check if it works correctly. If you can confirm the execution result, the trigger setting is complete.
Raises a trigger when adding a new row to the end of the specified sheet.
![](https://docs.c-bot.pro/wp-content/uploads/2023/08/workato_en_use_case_2_11.jpg)
Setting Cloud BOT
1. Configure the "ACTIONS" settings. Click "+" then select "Action in an app".
![](https://docs.c-bot.pro/wp-content/uploads/2023/08/workato_en_use_case_2_06.jpg)
2. Type "Cloud BOT" in the search box and select the app.
![](https://docs.c-bot.pro/wp-content/uploads/2023/08/workato_en_use_case_2_07.jpg)
3. Select an action type. Here, select "Execute BOT".
![](https://docs.c-bot.pro/wp-content/uploads/2023/08/workato_en_use_case_2_08.jpg)
4. Configure the [Connection] settings.
When the Connection is already created, the created connections list is displayed. Refer to this page about creation.
![](https://docs.c-bot.pro/wp-content/uploads/2023/08/workato_en_use_case_2_09.jpg)
5. Configure the [Setup] settings. Refer to this page about setting values.
![](https://docs.c-bot.pro/wp-content/uploads/2023/08/workato_en_use_case_2_12.jpg)
6. Now the recipe is created. Click [Test] on the top menu (top right corner) to check if it works correctly. If you can confirm the execution result, the setting is complete.