{"id":22563,"date":"2023-08-23T14:39:39","date_gmt":"2023-08-23T05:39:39","guid":{"rendered":"https:\/\/docs.c-bot.pro\/?p=22563"},"modified":"2023-08-23T22:12:25","modified_gmt":"2023-08-23T13:12:25","slug":"zapier_use_case_06","status":"publish","type":"post","link":"https:\/\/docs.c-bot.pro\/en\/connect\/zapier\/zapier_use_case_06\/","title":{"rendered":"Executing the list data obtained from the spreadsheet as the BOT input value (group data)"},"content":{"rendered":"\n

<\/i> Home<\/a> > Connect<\/a> > Zapier<\/a> > Executing the list data obtained from the spreadsheet as the BOT input value (group data)<\/p>\n\n\n\n

Creating a Zap<\/h2>\n\n\n\n

Creates a Zap that executes the list data obtained from the spreadsheet as the BOT input value (group data).<\/p>\n\n\n\n

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

Schedule<\/strong>
Activate a trigger based on the specified schedule.<\/p>\n<\/div>\n\n\n\n

\n

Spread Sheets\uff08Get Many Spreadsheet Rows\uff09<\/strong>
Get spreadsheet details and row items with the specified number of rows.<\/p>\n<\/div>\n\n\n\n

\n

Cloud BOT\uff08Execute BOT\uff09
<\/strong>Execute arbitrary bots.<\/p>\n<\/div>\n<\/div>\n\n\n\n

Setting Schedule<\/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. Click the Schedule icon.<\/p>\n\n\n\n

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

3. Set the Trigger account and click \"Continue\".<\/p>\n\n\n\n

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

4. 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 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

2. Select \"Get Many 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><\/p>\n\n\n\n

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

4. Set the Action and click \"Continue\".<\/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
<\/div>\n\n\n\n

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

1. Search for 'Cloud BOT' 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 \"Execute BOT\", 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. 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

4. Set the Action and click \"Continue\". Refer to here<\/a> about setting values.
In the image example, the row items obtained from \"Get Many Spreadsheet Rows<\/small>\" of 'Google Sheets' 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
<\/div>\n\n\n\n

The execution results can be checked in the Execution log of the Cloud BOT.<\/p>\n\n\n\n

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

 Home > Connect > Zapier > Executing the list data obtained from the spreadsheet as the BOT input value (group data) Creating a Zap Creates a Zap that executes the list data obtained from the spreadsheet as the BOT input value (group data). ScheduleActivate a trigger based on the specified schedule. Spread Sheets\uff08Get Many Spreadsheet Rows\uff09Get spreadsheet details and row items with the specified number of rows. Cloud BOT\uff08Execute BOT\uff09Execute arbitrary bots. Setting Schedule 1. Click \"Create\" to create a Zap. 2. Click the Schedule icon. 3. Set the Trigger account and click \"Continue\". 4. 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 \"Get Many 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\". 5. When the configuration is complete, click \"Test action\" to check the operation. Setting Cloud BOT 1. Search for 'Cloud BOT' in the search field of action and click on the icon. 2. Select \"Execute BOT\", and click \"Continue\". 3. Set the Action account and […]<\/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=22343","footnotes":""},"categories":[61],"tags":[11,9,59],"class_list":["post-22563","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\/22563","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=22563"}],"version-history":[{"count":4,"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/posts\/22563\/revisions"}],"predecessor-version":[{"id":22624,"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/posts\/22563\/revisions\/22624"}],"wp:attachment":[{"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/media?parent=22563"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/categories?post=22563"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/tags?post=22563"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}