{"id":22550,"date":"2023-08-23T11:15:24","date_gmt":"2023-08-23T02:15:24","guid":{"rendered":"https:\/\/docs.c-bot.pro\/?p=22550"},"modified":"2023-08-23T16:35:05","modified_gmt":"2023-08-23T07:35:05","slug":"zapier_use_case_05","status":"publish","type":"post","link":"https:\/\/docs.c-bot.pro\/en\/connect\/zapier\/zapier_use_case_05\/","title":{"rendered":"Adding group data obtained by BOT to a spreadsheet"},"content":{"rendered":"\n

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

Creating a Zap<\/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\uff08BOT Done\uff09<\/strong>
Retrieves the BOT execution result when a BOT has executed completely.<\/p>\n<\/div>\n\n\n\n

\n

Spread Sheets\uff08Create Multiple Spreadsheet Rows\uff09<\/strong>
Create multiple rows in the spreadsheet.<\/p>\n<\/div>\n<\/div>\n\n\n\n

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

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

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

2. Search for 'Cloud BOT' in the search field of Trigger and click on the icon.<\/p>\n\n\n\n

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

3. Select \"BOT Done\", and click \"Continue\".<\/p>\n\n\n\n

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

4. Set the Trigger account and click \"Continue\".
*Create a Connect if it does not exist. Learn more about creating a Connect<\/small> here<\/a>.<\/small><\/p>\n\n\n\n

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

5. Set the Trigger and click \"Continue\". Refer to this page<\/a> about setting values.<\/p>\n\n\n\n

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

6. When the configuration is complete, click \"Test trigger\" to check the operation.<\/p>\n\n\n\n

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

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

1. Search for 'Google Sheets' in the search field of Action and click on the icon.<\/p>\n\n\n\n

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

2. Select \"Create Multiple Spreadsheet Rows\", and click \"Continue\".<\/p>\n\n\n\n

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

3. Set the Action account and click \"Continue\".
*Create a Connect if it does not exist<\/small>.<\/small><\/p>\n\n\n\n

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

4. Set the Action and click \"Continue\". 
In the image example, the rows of the execution results obtained from the <\/small>\"Execute BOT\" Output are specified.<\/small><\/p>\n\n\n\n

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

5. When the configuration is complete, click \"Test action\" to check the operation.<\/p>\n\n\n\n

\"\"<\/figure>\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 > 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. Cloud BOT\uff08BOT Done\uff09Retrieves the BOT execution result when a BOT has executed completely. Spread Sheets\uff08Create Multiple Spreadsheet Rows\uff09Create multiple rows in the spreadsheet. Setting Cloud BOT 1. Click \"Create\" to create a Zap. 2. Search for 'Cloud BOT' in the search field of Trigger and click on the icon. 3. Select \"BOT Done\", and click \"Continue\". 4. Set the Trigger account and click \"Continue\".*Create a Connect if it does not exist. Learn more about creating a Connect here. 5. Set the Trigger and click \"Continue\". Refer to this page about setting values. 6. 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 \"Create Multiple 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\". In the image example, the rows of the execution results obtained from […]<\/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=22314","footnotes":""},"categories":[61],"tags":[11,9,59],"class_list":["post-22550","post","type-post","status-publish","format-standard","hentry","category-zapier","tag-ipaas_connection","tag-zapier","tag-59","en-US"],"_links":{"self":[{"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/posts\/22550","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=22550"}],"version-history":[{"count":5,"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/posts\/22550\/revisions"}],"predecessor-version":[{"id":22616,"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/posts\/22550\/revisions\/22616"}],"wp:attachment":[{"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/media?parent=22550"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/categories?post=22550"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/tags?post=22550"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}