{"id":15201,"date":"2022-11-07T16:40:19","date_gmt":"2022-11-07T07:40:19","guid":{"rendered":"https:\/\/docs.c-bot.pro\/?p=15201"},"modified":"2023-08-30T19:29:10","modified_gmt":"2023-08-30T10:29:10","slug":"workato_use_case_05","status":"publish","type":"post","link":"https:\/\/docs.c-bot.pro\/en\/connect\/workato\/workato_use_case_05\/","title":{"rendered":"Adding group data obtained by BOT to a spreadsheet"},"content":{"rendered":"\n

<\/i> Home<\/a> > Connect<\/a> > Workato<\/a> > Adding group data obtained by BOT to a spreadsheet<\/p>\n\n\n\n

Creating a recipe<\/strong><\/h2>\n\n\n\n

Creates a recipe that sequentially writes to a spreadsheet using the list data obtained in the cloud BOT.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n
\n
\n

Cloud BOT\uff08When BOT execution is completed\uff09<\/strong>
Retrieves the BOT execution result when a BOT has executed completely.<\/p>\n<\/div>\n\n\n\n

\n

Repeat action<\/strong>
The subsequent actions are executed sequentially for the number of rows of group data obtained by \u201cWhen BOT execution is completed\u201d.<\/p>\n<\/div>\n\n\n\n

\n

Google Sheets\uff08Add Row\uff09<\/strong>
Adds new row data to the spreadsheet.<\/p>\n<\/div>\n<\/div>\n\n\n\n

Setting Cloud BOT (When BOT execution is completed)<\/strong><\/h3>\n\n\n\n

1. Click \"Create\" to create a Recipe.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n
<\/div>\n\n\n\n

2. Optionally type a recipe name in \"Name\" and specify \"Location\", then click \"Start building\".<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n
<\/div>\n\n\n\n

3. Search \u201cCloud BOT\u201d in the search box and select the Cloud BOT app. The Cloud BOT connector must be installed. Click here<\/a> for details.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n
<\/div>\n\n\n\n

4. Configure the \"Connection\" settings.
When the Connection is already created, the created connections list is displayed. Refer to this page<\/a> about creation.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n
<\/div>\n\n\n\n

5. Configure the \"Setup\" settings. Refer to this page<\/a> about setting values.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n
<\/div>\n\n\n\n

6. Click \"Test\" on the top menu (top right corner) to check if it works correctly. Execute the BOT on the Created BOT website.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

If you can confirm the execution result, the trigger setting is complete.<\/p>\n\n\n\n

<\/div>\n\n\n\n

Setting Repeat action<\/strong><\/h3>\n\n\n\n

1. Configure the \"ACTIONS\" settings. Click \"+\" then select \"Repeat action\".<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n
<\/div>\n\n\n\n

2. Specify the group data (list) obtained from the Cloud BOT in the \"Input list\".
In this example, a datapill of Recipe data is used.<\/small><\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n
<\/div>\n\n\n\n

Setting Google Sheets<\/strong>
<\/h3>\n\n\n\n

1. Set the Repeat action app in [Select an app and action]. Search \u201cGoogle Sheets\u201d in the search box and select the app.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n
<\/div>\n\n\n\n

2. Select an action type. In this example, select \"Add row\".<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n
<\/div>\n\n\n\n

4. Configure the \"Connection\" settings.
When the Connection is already created, the created connections list is displayed. Refer to this page<\/a> about creation.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n
<\/div>\n\n\n\n

5. Configure the \"Setup\" settings.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n
<\/div>\n\n\n\n

In the image example, the value is extracted by changing the \"Columns\" field to \"Formula\" and specifying the Repeat action index as the key from the output value of the Cloud BOT.<\/small><\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n
<\/div>\n\n\n\n

6. 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.<\/p>\n\n\n\n

If you actually check the spreadsheet, it will be written as follows.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n
<\/div>\n","protected":false},"excerpt":{"rendered":"

 Home > Connect > Workato > Adding group data obtained by BOT to a spreadsheet Creating a recipe Creates a recipe that sequentially writes to a spreadsheet using the list data obtained in the cloud BOT. Cloud BOT\uff08When BOT execution is completed\uff09Retrieves the BOT execution result when a BOT has executed completely. Repeat actionThe subsequent actions are executed sequentially for the number of rows of group data obtained by \u201cWhen BOT execution is completed\u201d. Google Sheets\uff08Add Row\uff09Adds new row data to the spreadsheet. Setting Cloud BOT (When BOT execution is completed) 1. Click \"Create\" to create a Recipe. 2. Optionally type a recipe name in \"Name\" and specify \"Location\", then click \"Start building\". 3. Search \u201cCloud BOT\u201d in the search box and select the Cloud BOT app. The Cloud BOT connector must be installed. Click here for details. 4. Configure the \"Connection\" settings.When the Connection is already created, the created connections list is displayed. Refer to this page about creation. 5. Configure the \"Setup\" settings. Refer to this page about setting values. 6. Click \"Test\" on the top menu (top right corner) to check if it works correctly. Execute the BOT on the Created BOT website. If you can confirm […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_locale":"en_US","_original_post":"https:\/\/docs.c-bot.pro\/?p=15047","footnotes":""},"categories":[48],"tags":[52],"class_list":["post-15201","post","type-post","status-publish","format-standard","hentry","category-workato","tag-workato","en-US"],"_links":{"self":[{"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/posts\/15201","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/comments?post=15201"}],"version-history":[{"count":9,"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/posts\/15201\/revisions"}],"predecessor-version":[{"id":22880,"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/posts\/15201\/revisions\/22880"}],"wp:attachment":[{"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/media?parent=15201"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/categories?post=15201"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/tags?post=15201"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}