{"id":14479,"date":"2022-10-18T16:35:34","date_gmt":"2022-10-18T07:35:34","guid":{"rendered":"https:\/\/docs.c-bot.pro\/?p=14479"},"modified":"2023-09-05T11:43:31","modified_gmt":"2023-09-05T02:43:31","slug":"use_case_02","status":"publish","type":"post","link":"https:\/\/docs.c-bot.pro\/en\/connect\/make\/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> > Make<\/a> > Executing a BOT when a new row is added to a spreadsheet<\/p>\n\n\n\n

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

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

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

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

Google Sheets\uff08Watch Rows\uff09<\/strong>
Execute by adding a new row to a spreadsheet.<\/p>\n<\/div>\n\n\n\n

\n

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

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

Setting Google Sheets<\/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 \"Google Sheets\" 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 Rows\".<\/p>\n\n\n\n

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

4. Set the module. In the image example, Setting up \"Spreadsheet ID\", \"Table contains headers\", \"Row with headers\" and other details.
*Create a Connection if it does not exist.<\/small><\/p>\n\n\n\n

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

Click \"Run Once\" to confirm the behavior.<\/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
<\/div>\n\n\n\n

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

1. When you mouse over the icon on the right side of Google Sheets, \"Add another module\" is displayed. Click \"Add another module\" to add a new module. Search \"Cloud BOT\" in the search box and select it.<\/p>\n\n\n\n

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

2. Type \"Gmail\" in the search box to locate and select it.<\/p>\n\n\n\n

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

3. Select \"Execute BOT\".<\/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

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
<\/div>\n","protected":false},"excerpt":{"rendered":"

 Home > Connect > Make > Executing a BOT when a new row is added to a spreadsheet Creating a scenario Creates a scenario that executes a particular BOT when a new row is added to a spreadsheet. Google Sheets\uff08Watch Rows\uff09Execute by adding a new row to a spreadsheet. Cloud BOT\uff08Execute BOT\uff09Execute any BOT. Setting Google Sheets 1. Click \"Create a new scenario\" to create a scenario. 2. Click \"+\" icon and type \"Google Sheets\" in the search box to locate it. 3. Select \"Watch Rows\". 4. Set the module. In the image example, Setting up \"Spreadsheet ID\", \"Table contains headers\", \"Row with headers\" and other details.*Create a Connection if it does not exist. Click \"Run Once\" to confirm the behavior. If you can confirm the execution result, the trigger setting is complete. Setting Cloud BOT 1. When you mouse over the icon on the right side of Google Sheets, \"Add another module\" is displayed. Click \"Add another module\" to add a new module. Search \"Cloud BOT\" in the search box and select it. 2. Type \"Gmail\" in the search box to locate and select it. 3. Select \"Execute BOT\". 4. Set the module. Refer to this page about setting values.*Create a […]<\/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=11568","footnotes":""},"categories":[43],"tags":[51],"class_list":["post-14479","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\/14479","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=14479"}],"version-history":[{"count":10,"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/posts\/14479\/revisions"}],"predecessor-version":[{"id":23422,"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/posts\/14479\/revisions\/23422"}],"wp:attachment":[{"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/media?parent=14479"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/categories?post=14479"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/tags?post=14479"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}