{"id":15195,"date":"2022-11-07T16:33:27","date_gmt":"2022-11-07T07:33:27","guid":{"rendered":"https:\/\/docs.c-bot.pro\/?p=15195"},"modified":"2023-08-30T19:30:51","modified_gmt":"2023-08-30T10:30:51","slug":"workato_use_case_02","status":"publish","type":"post","link":"https:\/\/docs.c-bot.pro\/en\/connect\/workato\/workato_use_case_02\/","title":{"rendered":"Executing a BOT when a new row is added to a spreadsheet"},"content":{"rendered":"\n<p><a href=\"https:\/\/docs.c-bot.pro\/en\/\"><i class=\"fas fa-book\"><\/i>&nbsp;Home<\/a> &gt; <a href=\"https:\/\/docs.c-bot.pro\/en\/connect\/\">Connect<\/a> &gt; <a href=\"https:\/\/docs.c-bot.pro\/en\/connect\/workato\">Workato<\/a> &gt; Executing a BOT when a new row is added to a spreadsheet<\/p>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 id=\"outline__1\" class=\"wp-block-heading\"><strong>Creating a recipe<\/strong><\/h2>\n\n\n\n<p>Creates a recipe that executes a particular BOT when a new row is added to a spreadsheet.<\/p>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/docs.c-bot.pro\/wp-content\/uploads\/2020\/07\/spreadsheet_cloudbot-1.png\" alt=\"\" class=\"wp-image-288\"\/><\/figure>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-9d6595d7 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p><strong>Google Sheets\uff08New row in sheet in My Drive\uff09<\/strong><br>Triggered when adding a new row to a spreadsheet.<\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p><strong><strong>Cloud BOT\uff08Execute BOT\uff09<\/strong><\/strong><br>Executes any BOT.<\/p>\n<\/div>\n<\/div>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 id=\"outline__1_1\" class=\"wp-block-heading\"><strong>Setting Google Sheets<\/strong><\/h3>\n\n\n\n<p>1. Click \"Create\" to create a Recipe.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1680\" height=\"905\" src=\"https:\/\/docs.c-bot.pro\/wp-content\/uploads\/2023\/08\/workato_en_use_case_1_01.jpg\" alt=\"\" class=\"wp-image-22747\"\/><\/figure>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>2. Optionally type a recipe name in \"Name\" and specify \"Location\", then click \"Start building\".<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1680\" height=\"905\" src=\"https:\/\/docs.c-bot.pro\/wp-content\/uploads\/2022\/11\/workato_use_case_1_02.jpg\" alt=\"\" class=\"wp-image-14821\"\/><\/figure>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>3. Search \"Google Sheets\" in the search box and select the Google Sheets app.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1680\" height=\"905\" src=\"https:\/\/docs.c-bot.pro\/wp-content\/uploads\/2023\/08\/workato_en_use_case_2_02.jpg\" alt=\"\" class=\"wp-image-22762\"\/><\/figure>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>4. Select a trigger type. In this example, select \"New row in sheet in My Drive\".<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1680\" height=\"905\" src=\"https:\/\/docs.c-bot.pro\/wp-content\/uploads\/2023\/08\/workato_en_use_case_2_03.jpg\" alt=\"\" class=\"wp-image-22763\"\/><\/figure>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>5. Configure the \"Connection\" settings.<br>When the Connection is already created, the created connections list is displayed. Refer to <a href=\"https:\/\/docs.c-bot.pro\/en\/connect\/workato\/workato_manual\/#outline__2_2\">this page<\/a> about creation.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1680\" height=\"905\" src=\"https:\/\/docs.c-bot.pro\/wp-content\/uploads\/2023\/08\/workato_en_use_case_2_04.jpg\" alt=\"\" class=\"wp-image-22764\"\/><\/figure>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>6.Configure the \"Setup\" settings. Specify \"Spreadsheet\" and \"Sheet\".<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1680\" height=\"905\" src=\"https:\/\/docs.c-bot.pro\/wp-content\/uploads\/2023\/08\/workato_en_use_case_2_05.jpg\" alt=\"\" class=\"wp-image-22765\"\/><\/figure>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>7. Click \"Test\" on the top menu (top right corner) to check if it works correctly. If you can confirm the execution result, the trigger setting is complete.<br><small>Raises a trigger when adding a new row to the end of the specified sheet.<\/small><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1680\" height=\"905\" src=\"https:\/\/docs.c-bot.pro\/wp-content\/uploads\/2023\/08\/workato_en_use_case_2_11.jpg\" alt=\"\" class=\"wp-image-22768\"\/><\/figure>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 id=\"outline__1_2\" class=\"wp-block-heading\"><strong>Setting Cloud BOT<\/strong><\/h3>\n\n\n\n<p>1. Configure the \"ACTIONS\" settings. Click \"+\" then select \"Action in an app\".<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1680\" height=\"905\" src=\"https:\/\/docs.c-bot.pro\/wp-content\/uploads\/2023\/08\/workato_en_use_case_2_06.jpg\" alt=\"\" class=\"wp-image-22769\"\/><\/figure>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>2.&nbsp;Type \"Cloud BOT\" in the search box and select the app.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1680\" height=\"905\" src=\"https:\/\/docs.c-bot.pro\/wp-content\/uploads\/2023\/08\/workato_en_use_case_2_07.jpg\" alt=\"\" class=\"wp-image-22770\"\/><\/figure>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>3. Select an action type. Here, select \"Execute BOT\".<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1680\" height=\"905\" src=\"https:\/\/docs.c-bot.pro\/wp-content\/uploads\/2023\/08\/workato_en_use_case_2_08.jpg\" alt=\"\" class=\"wp-image-22771\"\/><\/figure>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>4.&nbsp;Configure the [Connection] settings.<br>When the Connection is already created, the created connections list is displayed. Refer to <a href=\"https:\/\/docs.c-bot.pro\/en\/connect\/workato\/workato_manual\/#outline__2_2\">this page<\/a> about creation.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1680\" height=\"905\" src=\"https:\/\/docs.c-bot.pro\/wp-content\/uploads\/2023\/08\/workato_en_use_case_2_09.jpg\" alt=\"\" class=\"wp-image-22772\"\/><\/figure>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>5. Configure the [Setup] settings. Refer to <a href=\"https:\/\/docs.c-bot.pro\/en\/connect\/workato\/trigger_action\/#outline__1_2_1\">this page<\/a> about setting values.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1680\" height=\"905\" src=\"https:\/\/docs.c-bot.pro\/wp-content\/uploads\/2023\/08\/workato_en_use_case_2_12.jpg\" alt=\"\" class=\"wp-image-22773\"\/><\/figure>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>6. Now the recipe is created. Click [Test] on the top menu (top right corner) to check if it works correctly. If you can confirm the execution result, the setting is complete.<\/p>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp;Home &gt; Connect &gt; Workato &gt; Executing a BOT when a new row is added to a spreadsheet Creating a recipe Creates a recipe that executes a particular BOT when a new row is added to a spreadsheet. Google Sheets\uff08New row in sheet in My Drive\uff09Triggered when adding a new row to a spreadsheet. Cloud BOT\uff08Execute BOT\uff09Executes any BOT. Setting Google Sheets 1. Click \"Create\" to create a Recipe. 2. Optionally type a recipe name in \"Name\" and specify \"Location\", then click \"Start building\". 3. Search \"Google Sheets\" in the search box and select the Google Sheets app. 4. Select a trigger type. In this example, select \"New row in sheet in My Drive\". 5. Configure the \"Connection\" settings.When the Connection is already created, the created connections list is displayed. Refer to this page about creation. 6.Configure the \"Setup\" settings. Specify \"Spreadsheet\" and \"Sheet\". 7. Click \"Test\" on the top menu (top right corner) to check if it works correctly. If you can confirm the execution result, the trigger setting is complete.Raises a trigger when adding a new row to the end of the specified sheet. Setting Cloud BOT 1. Configure the \"ACTIONS\" settings. Click \"+\" then select \"Action in [&hellip;]<\/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=14882","footnotes":""},"categories":[48],"tags":[52],"class_list":["post-15195","post","type-post","status-publish","format-standard","hentry","category-workato","tag-workato","en-US"],"_links":{"self":[{"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/posts\/15195","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=15195"}],"version-history":[{"count":10,"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/posts\/15195\/revisions"}],"predecessor-version":[{"id":22882,"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/posts\/15195\/revisions\/22882"}],"wp:attachment":[{"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/media?parent=15195"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/categories?post=15195"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/tags?post=15195"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}