{"id":18836,"date":"2023-04-14T11:23:37","date_gmt":"2023-04-14T02:23:37","guid":{"rendered":"https:\/\/docs.c-bot.pro\/?p=18836"},"modified":"2023-08-28T16:10:02","modified_gmt":"2023-08-28T07:10:02","slug":"ifttt_use_case_02","status":"publish","type":"post","link":"https:\/\/docs.c-bot.pro\/en\/connect\/ifttt\/ifttt_use_case_02\/","title":{"rendered":"Execute BOT when a new row is added to the 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\/ifttt\">IFTTT<\/a> &gt; Execute BOT when a new row is added to the spreadsheet<\/p>\n\n\n\n<h2 id=\"outline__1\" class=\"wp-block-heading\">Creating a applet<\/h2>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>Create an applet that executes a specific BOT when a new row is added to the spreadsheet.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"300\" src=\"https:\/\/docs.c-bot.pro\/wp-content\/uploads\/2023\/04\/ifttt_use_02_12-1024x300.jpg\" alt=\"\" class=\"wp-image-18611\"\/><\/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 added to spreadsheet\uff09<\/strong><br>Gets the row string when a new row is added to the specified 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>Cloud BOT\uff08 Execute BOT\uff09<\/strong><br>Execute the BOT with the obtained text string as the input value.<\/p>\n<\/div>\n<\/div>\n\n\n\n<h3 id=\"outline__1_1\" class=\"wp-block-heading\"><strong>Setting Google Sheets<\/strong><\/h3>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>1. Click \"Create\" from the menu on the screen.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"494\" src=\"https:\/\/docs.c-bot.pro\/wp-content\/uploads\/2023\/04\/iftttt_sh_01-1024x494.jpg\" alt=\"\" class=\"wp-image-18539\"\/><\/figure>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>2. After moving to the applet creation screen, click \"Add\" under \"If This\".<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"494\" src=\"https:\/\/docs.c-bot.pro\/wp-content\/uploads\/2023\/04\/iftttt_sh_02-1024x494.jpg\" alt=\"\" class=\"wp-image-18540\"\/><\/figure>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>3. Search for \"Google sheets\" and click the icon.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"403\" src=\"https:\/\/docs.c-bot.pro\/wp-content\/uploads\/2023\/04\/ifttt_use_02_01-1024x403.jpg\" alt=\"\" class=\"wp-image-18586\"\/><\/figure>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>4. Click \"New row added to spreadsheet\".<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"571\" src=\"https:\/\/docs.c-bot.pro\/wp-content\/uploads\/2023\/04\/ifttt_use_02_02-1024x571.jpg\" alt=\"\" class=\"wp-image-18587\"\/><\/figure>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>5. Set the trigger. Specify any sheet.<br><small>*Create a Connect if it does not exist.<\/small><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"893\" src=\"https:\/\/docs.c-bot.pro\/wp-content\/uploads\/2023\/04\/ifttt_use_02_03-1024x893.jpg\" alt=\"\" class=\"wp-image-18588\"\/><\/figure>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>6. Click \"Create trigger\" after setting.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"134\" src=\"https:\/\/docs.c-bot.pro\/wp-content\/uploads\/2023\/04\/ifttt_use_02_04-1024x134.jpg\" alt=\"\" class=\"wp-image-18589\"\/><\/figure>\n\n\n\n<h3 id=\"outline__1_2\" class=\"wp-block-heading\">Setting Cloud BOT<\/h3>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>1. Click \"Add\" in \"Then That\" on the screen after setting the trigger.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"274\" src=\"https:\/\/docs.c-bot.pro\/wp-content\/uploads\/2023\/04\/ifttt_use_02_05-1024x274.jpg\" alt=\"\" class=\"wp-image-18590\"\/><\/figure>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>2. Search for \"Cloud BOT\" and click the icon.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"402\" src=\"https:\/\/docs.c-bot.pro\/wp-content\/uploads\/2023\/04\/ifttt_use_01_01-1024x402.jpg\" alt=\"\" class=\"wp-image-18542\"\/><\/figure>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>3. Click \"Execute BOT\".<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"571\" src=\"https:\/\/docs.c-bot.pro\/wp-content\/uploads\/2023\/04\/ifttt_use_02_06-1024x571.jpg\" alt=\"\" class=\"wp-image-18591\"\/><\/figure>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>4. Set the action. Refer to\u00a0<a href=\"https:\/\/docs.c-bot.pro\/en\/connect\/ifttt\/ifttt_trigger_action\/#outline__1_2_1\">this page<\/a>\u00a0about setting values.<br><small>*Create a Connect if it does not exist. Learn more about creating a Connect\u00a0<a href=\"https:\/\/docs.c-bot.pro\/en\/connect\/ifttt\/ifttt_manual\/#outline__2_1\">here<\/a>.<\/small><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"642\" height=\"1024\" src=\"https:\/\/docs.c-bot.pro\/wp-content\/uploads\/2023\/08\/IFTTT_en_image_11-642x1024.jpg\" alt=\"\" class=\"wp-image-22687\"\/><\/figure>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p><small>*In this example, Column is assigned as follows.<\/small><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"955\" height=\"136\" src=\"https:\/\/docs.c-bot.pro\/wp-content\/uploads\/2023\/08\/IFTTT_en_image_12.jpg\" alt=\"\" class=\"wp-image-22688\"\/><\/figure>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>5.Click \"Create action\".<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"134\" src=\"https:\/\/docs.c-bot.pro\/wp-content\/uploads\/2023\/04\/ifttt_use_02_09-1024x134.jpg\" alt=\"\" class=\"wp-image-18594\"\/><\/figure>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>6. Click \"Continue\" button.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"410\" src=\"https:\/\/docs.c-bot.pro\/wp-content\/uploads\/2023\/04\/ifttt_use_02_11-2-1024x410.jpg\" alt=\"\" class=\"wp-image-18602\"\/><\/figure>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>7. Set your notifications and click \"Finish\".<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"201\" src=\"https:\/\/docs.c-bot.pro\/wp-content\/uploads\/2023\/04\/iftttt_sh_03-1024x201.jpg\" alt=\"\" class=\"wp-image-18555\"\/><\/figure>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>An applet has been created.<br>Check the actual operation. You can check the execution result by \u201dCheck the log of your Applet runs \"view activity\"\".<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"563\" src=\"https:\/\/docs.c-bot.pro\/wp-content\/uploads\/2023\/04\/iftttt_sh_00-1024x563.jpg\" alt=\"\" class=\"wp-image-18556\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"332\" src=\"https:\/\/docs.c-bot.pro\/wp-content\/uploads\/2023\/08\/IFTTT_en_image_13-1024x332.jpg\" alt=\"\" class=\"wp-image-22689\"\/><\/figure>\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; IFTTT &gt; Execute BOT when a new row is added to the spreadsheet Creating a applet Create an applet that executes a specific BOT when a new row is added to the spreadsheet. Google sheets\uff08New row added to spreadsheet\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\" from the menu on the screen. 2. After moving to the applet creation screen, click \"Add\" under \"If This\". 3. Search for \"Google sheets\" and click the icon. 4. Click \"New row added to spreadsheet\". 5. Set the trigger. Specify any sheet.*Create a Connect if it does not exist. 6. Click \"Create trigger\" after setting. Setting Cloud BOT 1. Click \"Add\" in \"Then That\" on the screen after setting the trigger. 2. Search for \"Cloud BOT\" and click the icon. 3. Click \"Execute BOT\". 4. Set the action. Refer to\u00a0this page\u00a0about setting values.*Create a Connect if it does not exist. Learn more about creating a Connect\u00a0here. *In this example, Column is assigned as follows. 5.Click \"Create action\". 6. Click \"Continue\" button. 7. Set [&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=18354","footnotes":""},"categories":[58],"tags":[13,59],"class_list":["post-18836","post","type-post","status-publish","format-standard","hentry","category-ifttt","tag-ifttt","tag-59","en-US"],"_links":{"self":[{"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/posts\/18836","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=18836"}],"version-history":[{"count":9,"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/posts\/18836\/revisions"}],"predecessor-version":[{"id":22694,"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/posts\/18836\/revisions\/22694"}],"wp:attachment":[{"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/media?parent=18836"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/categories?post=18836"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/tags?post=18836"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}