{"id":14491,"date":"2022-10-18T16:38:53","date_gmt":"2022-10-18T07:38:53","guid":{"rendered":"https:\/\/docs.c-bot.pro\/?p=14491"},"modified":"2023-09-05T11:49:19","modified_gmt":"2023-09-05T02:49:19","slug":"use_case_05","status":"publish","type":"post","link":"https:\/\/docs.c-bot.pro\/en\/connect\/make\/use_case_05\/","title":{"rendered":"Adding group data obtained by BOT to a spreadsheet"},"content":{"rendered":"\n

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

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

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

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

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

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

\n

Iterator<\/strong>
The subsequent modules are executed sequentially for the number of rows of group data obtained by Watch BOT Done.<\/p>\n<\/div>\n\n\n\n

\n

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

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

Setting Cloud BOT<\/strong><\/h3>\n\n\n\n

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

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

2. Click \"+\" icon and type \"Cloud BOT\" in the search box to locate it.<\/p>\n\n\n\n

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

3.  Select \"Watch BOT Done\".<\/p>\n\n\n\n

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

4. Set the module. Refer to this page<\/a> about setting values.
*Create a Connection if it does not exist. Learn more about creating a Connection here<\/a>.<\/small><\/p>\n\n\n\n

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

Click \"Run Once\" to confirm the behavior. Execute the BOT on the Created BOT website.<\/p>\n\n\n\n

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

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

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

Setting Iterator<\/strong><\/h3>\n\n\n\n

1. Click \"Add another module\" next to the icon to add a new module. Search \"Flow Control\" in the search box and select it.<\/p>\n\n\n\n

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

2. Select \"Iterator\".<\/p>\n\n\n\n

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

3. Set the Iterator.
Specify the group data (Array) obtained from the cloud BOT in the \"Array\" field.<\/p>\n\n\n\n

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

Click \"Run Once\" to confirm the behavior. If you can confirm the execution result, the setting is complete.<\/p>\n\n\n\n

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

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

1. Click \"Add another module\" next to the icon to add a new module. Search \"Google Sheets\" in the search box and select it.<\/p>\n\n\n\n

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

2. Select \"Add a Row\".<\/p>\n\n\n\n

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

3. Set the module. Specify \"Choose a Method,\" \"Choose a Drive,\" \"Spreadsheet ID,\" \"Sheet Name,\" etc.
*Create a Connection if it does not exist.<\/small><\/p>\n\n\n\n

In this example, a spreadsheet to add a data row to is specified.<\/p>\n\n\n\n

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

4.  Specify the value in the \"Values\" field.
Extract the value from the output value of the cloud BOT by specifying \"Bundle order position\" of the Iterator as a key.<\/p>\n\n\n\n

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

Check the operation with \"Run Once\" and click \"Save\" when you are satisfied with the execution results. This completes the creation of the scenario.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n
<\/div>\n\n\n\n
\"\"<\/figure>\n\n\n\n
<\/div>\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 > Make > Adding group data obtained by BOT to a spreadsheet Creating a scenario Creates a scenario that sequentially writes to a spreadsheet using the list data obtained in the cloud BOT. Cloud BOT\uff08Watch BOT Done\uff09Retrieves the BOT execution result when a BOT has executed completely. IteratorThe subsequent modules are executed sequentially for the number of rows of group data obtained by Watch BOT Done. Google Sheets\uff08Add a Row\uff09Adds new row data fetched by the Iterator to the spreadsheet. Setting Cloud BOT 1.  Click \"Create a new scenario\" to create a scenario. 2. Click \"+\" icon and type \"Cloud BOT\" in the search box to locate it. 3.  Select \"Watch BOT Done\". 4. Set the module. Refer to this page about setting values.*Create a Connection if it does not exist. Learn more about creating a Connection here. Click \"Run Once\" to confirm the behavior. Execute the BOT on the Created BOT website. If you can confirm the execution result, the trigger setting is complete. Setting Iterator 1. Click \"Add another module\" next to the icon to add a new module. Search \"Flow Control\" in the search box and select it. 2. Select \"Iterator\". 3. Set the Iterator.Specify the […]<\/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=14323","footnotes":""},"categories":[43],"tags":[51],"class_list":["post-14491","post","type-post","status-publish","format-standard","hentry","category-make","tag-make","en-US"],"_links":{"self":[{"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/posts\/14491","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=14491"}],"version-history":[{"count":10,"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/posts\/14491\/revisions"}],"predecessor-version":[{"id":23432,"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/posts\/14491\/revisions\/23432"}],"wp:attachment":[{"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/media?parent=14491"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/categories?post=14491"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/tags?post=14491"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}