{"id":22511,"date":"2023-08-22T15:50:02","date_gmt":"2023-08-22T06:50:02","guid":{"rendered":"https:\/\/docs.c-bot.pro\/?p=22511"},"modified":"2023-08-23T15:47:21","modified_gmt":"2023-08-23T06:47:21","slug":"zapier_use_case_02","status":"publish","type":"post","link":"https:\/\/docs.c-bot.pro\/en\/connect\/zapier\/zapier_use_case_02\/","title":{"rendered":"Executing a BOT when a new row is added to a spreadsheet"},"content":{"rendered":"\n

<\/i> Home<\/a> > Connect<\/a> > Zapier<\/a> > Executing a BOT when a new row is added to a spreadsheet<\/p>\n\n\n\n

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

Creates a Zap that executes a particular BOT when a new row is added to a spreadsheet.<\/p>\n\n\n\n

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

Google sheets\uff08 New Spreadsheets Row \uff09<\/strong>
Gets the row string when a new row is added to the specified spreadsheet.<\/p>\n<\/div>\n\n\n\n

\n

Cloud BOT\uff08 Execute BOT\uff09<\/strong>
Execute the BOT with the obtained text string as the input value.<\/p>\n<\/div>\n<\/div>\n\n\n\n

Setting Google sheets<\/h3>\n\n\n\n
<\/div>\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 'Google Sheets' 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 \"New Spreadsheets Row\", 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\". \n
*Create a Connect if it does not exist.<\/small>\n<\/p>\n\n\n\n

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

5. Set the Trigger and click \"Continue\". 
Setting up \"Spreadsheets\", \"Worksheet\".<\/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 Cloud BOT<\/h3>\n\n\n\n
<\/div>\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\".\n
*Create a Connect if it does not exist. Learn more about creating a Connect here<\/a>.<\/small>\n<\/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.<\/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

You can see the results of the run, then click \"Publish\". This completes the creation of the Zap.<\/p>\n","protected":false},"excerpt":{"rendered":"

 Home > Connect > Zapier > Executing a BOT when a new row is added to a spreadsheet Creating a Zap Creates a Zap that executes a particular BOT when a new row is added to a spreadsheet. Google sheets\uff08 New Spreadsheets Row \uff09Gets the row string when a new row is added to the specified spreadsheet. Cloud BOT\uff08 Execute BOT\uff09Execute the BOT with the obtained text string as the input value. Setting Google sheets 1. Click \"Create\" to create a Zap. 2. Search for 'Google Sheets' in the search field of Trigger and click on the icon. 3. Select \"New Spreadsheets Row\", and click \"Continue\". 4. Set the Trigger account and click \"Continue\". *Create a Connect if it does not exist. 5. Set the Trigger and click \"Continue\". Setting up \"Spreadsheets\", \"Worksheet\". 6. When the configuration is complete, click \"Test trigger\" 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 click \"Continue\". *Create a Connect if it does not exist. Learn more about creating a Connect here. 4. Set the Action and click […]<\/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=22225","footnotes":""},"categories":[61],"tags":[11,9,59],"class_list":["post-22511","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\/22511","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=22511"}],"version-history":[{"count":8,"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/posts\/22511\/revisions"}],"predecessor-version":[{"id":22593,"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/posts\/22511\/revisions\/22593"}],"wp:attachment":[{"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/media?parent=22511"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/categories?post=22511"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/tags?post=22511"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}