{"id":3268,"date":"2020-12-08T07:32:46","date_gmt":"2020-12-07T22:32:46","guid":{"rendered":"https:\/\/hanami-web.tokyo.jp\/blog\/?p=3268"},"modified":"2023-03-13T17:20:52","modified_gmt":"2023-03-13T08:20:52","slug":"amelia-webhook2","status":"publish","type":"post","link":"https:\/\/hanami-web.tokyo.jp\/blog\/en\/reservation-plugin\/amelia-webhook2\/","title":{"rendered":"Illustrated guide on how to link the WordPress reservation management system Amelia with Google Spreadsheet!"},"content":{"rendered":"<p>WordPress booking system plugin<a href=\"https:\/\/tms-plugins.sjv.io\/c\/3221912\/1426257\/16534?subId1=wpDataTables%20WordPress%20Plugin&amp;u=https%3A%2F%2Fwpamelia.com%2F\" target=\"_blank\" rel=\"noreferrer noopener\">Amelia<\/a>I would like to use the webhook function of (link to the Amelia official website) to try managing reservations from WordPress using a spreadsheet!<\/p>\n\n\n\n<p>Last time, I tried to integrate with Zapier, which was introduced in the official documentation, and store reservation data in a Google Spreadsheet, but I found out that I couldn&#039;t use Zapier&#039;s webhooks function unless I became a paid member.<\/p>\n\n\n\n<p>I was determined to find a way to automatically save reservation data in a spreadsheet, so I did some research and finally made it happen.<\/p>\n\n\n<div class=\"sc\"><a href=\"https:\/\/hanami-web.tokyo.jp\/blog\/en\/reservation-amelia-content\/\" title=\"Amelia Explanation Table of Contents\">\r\n\t<p class=\"sc-txt01\">Our company&#039;s reservation system also uses Amelia.<\/p>\r\n\t<p class=\"sc-txt01\">How to create a reservation website using WordPress<\/p>\r\n\t<p class=\"sc-txt02\">Amelia Explanation Index \u2192<\/p>\r\n<\/a><\/div>\r\n<br><br>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 ez-toc-wrap-center counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">table of contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #000000;color:#000000\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #000000;color:#000000\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewbox=\"0 0 24 24\" version=\"1.2\" baseprofile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/hanami-web.tokyo.jp\/blog\/en\/reservation-plugin\/amelia-webhook2\/#webhook%e3%82%92%e5%88%a9%e7%94%a8\" >Using webhooks<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/hanami-web.tokyo.jp\/blog\/en\/reservation-plugin\/amelia-webhook2\/#pabbly%e3%81%b8%e3%83%ad%e3%82%b0%e3%82%a4%e3%83%b3\" >Log in to Pabbly<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/hanami-web.tokyo.jp\/blog\/en\/reservation-plugin\/amelia-webhook2\/#create_workflow\" >Create Workflow<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/hanami-web.tokyo.jp\/blog\/en\/reservation-plugin\/amelia-webhook2\/#workflow%e3%81%ab%e5%90%8d%e5%89%8d%e3%82%92%e3%81%a4%e3%81%91%e3%82%8b\" >Name your workflow<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/hanami-web.tokyo.jp\/blog\/en\/reservation-plugin\/amelia-webhook2\/#%e4%bd%95%e3%81%a8%e6%8e%a5%e7%b6%9a%e3%81%99%e3%82%8b%e3%81%ae%e3%81%8b%e9%81%b8%e6%8a%9e\" >Choose what to connect to<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/hanami-web.tokyo.jp\/blog\/en\/reservation-plugin\/amelia-webhook2\/#amelia%e3%81%ae%e7%ae%a1%e7%90%86%e7%94%bb%e9%9d%a2%e3%81%a7webhook_url%e5%85%a5%e5%8a%9b\" >Enter webhook URL on Amelia&#039;s administration screen<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/hanami-web.tokyo.jp\/blog\/en\/reservation-plugin\/amelia-webhook2\/#pabbly%e3%81%b8%e6%88%bb%e3%82%8a%e3%80%81capture_webhook_response%e3%82%92%e3%82%af%e3%83%aa%e3%83%83%e3%82%af\" >Return to Pabbly and click Capture Webhook Response.<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/hanami-web.tokyo.jp\/blog\/en\/reservation-plugin\/amelia-webhook2\/#trigger%e3%81%ae%e5%be%8c%e3%80%81%e4%bd%95%e3%82%92%e3%81%99%e3%82%8b%e3%81%8b%e3%82%92%e8%a8%ad%e5%ae%9a\" >Set what to do after the trigger<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/hanami-web.tokyo.jp\/blog\/en\/reservation-plugin\/amelia-webhook2\/#%e4%ba%8b%e5%89%8d%e3%81%abgoogle_spreadsheet%e3%82%92%e4%bd%9c%e6%88%90\" >Create a Google spreadsheet in advance<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/hanami-web.tokyo.jp\/blog\/en\/reservation-plugin\/amelia-webhook2\/#google_spreadsheet%e3%81%a8%e6%8e%a5%e7%b6%9a\" >Connect to Google Spreadsheet<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/hanami-web.tokyo.jp\/blog\/en\/reservation-plugin\/amelia-webhook2\/#amelia%e3%81%a8%e3%82%b9%e3%83%97%e3%83%ac%e3%83%83%e3%83%89%e3%82%b7%e3%83%bc%e3%83%88%e3%81%ae%e7%b4%90%e3%81%a5%e3%81%91\" >Linking Amelia to a spreadsheet<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/hanami-web.tokyo.jp\/blog\/en\/reservation-plugin\/amelia-webhook2\/#%e4%bf%9d%e5%ad%98%e3%82%92%e3%81%97%e3%81%a6%e6%8e%a5%e7%b6%9a%e5%ae%8c%e4%ba%86%ef%bc%81\" >Save and connect!<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/hanami-web.tokyo.jp\/blog\/en\/reservation-plugin\/amelia-webhook2\/#%e4%bb%95%e7%b5%84%e3%81%bf%e4%bd%9c%e3%82%8a%e3%81%ab%e3%81%a4%e3%81%84%e3%81%a6\" >About the mechanism<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"webhook%e3%82%92%e5%88%a9%e7%94%a8\"><\/span>Using webhooks<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>I&#039;m sure there are many people who are wondering, &quot;What is a webhook?&quot; I myself have recently come to understand webhooks and mastered how to use them.<\/p>\n\n\n\n<p>I discovered a free service that allows you to use webhooks like Zapier.<\/p>\n\n\n\n<p><a href=\"https:\/\/accounts.pabbly.com\/\" target=\"_blank\" rel=\"noreferrer noopener\">Pabbly<\/a><\/p>\n\n\n\n<p>Although the only explanations available were in English, I was able to successfully connect to Amelia on my own, using my past experience and similar cases as a reference!<\/p>\n\n\n\n<p>I recently enrolled in this course because I wanted to be able to use the LINE Developer tool freely.<a href=\"https:\/\/protoout.studio\/\" target=\"_blank\" rel=\"noreferrer noopener\">Proto Out Studio<\/a>This is the result of my studies at the University of Tokyo. Instead of creating a service from scratch for the self-satisfaction of engineers, I combine existing services to quickly and easily create a new service. This is the prototyping technique.<\/p>\n\n\n\n<p>If you don&#039;t know the technology, you can&#039;t combine existing services, so I&#039;m studying the technology intensively. In the process, I&#039;ve acquired knowledge of webhooks and APIs, which are essential for combining the technologies. Recently, I&#039;ve been feeling more and more positive about the results!<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"571\" src=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/12\/image-18-1024x571.png\" alt=\"\" class=\"wp-image-3269\" srcset=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/12\/image-18-1024x571.png 1024w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/12\/image-18-120x68.png 120w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/12\/image-18-160x90.png 160w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/12\/image-18-300x167.png 300w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/12\/image-18-768x428.png 768w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/12\/image-18.png 1441w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"pabbly%e3%81%b8%e3%83%ad%e3%82%b0%e3%82%a4%e3%83%b3\"><\/span>Log in to Pabbly<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>I logged in with my Google account.<\/p>\n\n\n\n<p>Once you log in, you will be taken to a screen like this, so click Access Now under [Connect].<\/p>\n\n\n\n<section class=\"wp-block-uagb-section uagb-section__wrap uagb-section__background-undefined uagb-block-393310fd\"><div class=\"uagb-section__overlay\"><\/div><div class=\"uagb-section__inner-wrap\">\n<p>Immediately after creating the account, I received a connect error several times. It started appearing while clicking and going back and forth to other email marketing sites.<\/p>\n<\/div><\/section>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"624\" src=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/12\/image-19-1024x624.png\" alt=\"\" class=\"wp-image-3270\" srcset=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/12\/image-19-1024x624.png 1024w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/12\/image-19-300x183.png 300w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/12\/image-19-768x468.png 768w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/12\/image-19.png 1277w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"create_workflow\"><\/span>Create Workflow<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Create a new workflow.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"159\" src=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/12\/image-20-1024x159.png\" alt=\"\" class=\"wp-image-3271\" srcset=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/12\/image-20-1024x159.png 1024w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/12\/image-20-1536x239.png 1536w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/12\/image-20-300x47.png 300w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/12\/image-20-768x119.png 768w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/12\/image-20.png 1877w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"workflow%e3%81%ab%e5%90%8d%e5%89%8d%e3%82%92%e3%81%a4%e3%81%91%e3%82%8b\"><\/span>Name your workflow<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Give it a name to identify what workflow it is. This is the name that will be displayed on the management screen. In my case, I named it [Amelia_R].<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"623\" height=\"297\" src=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/12\/image-21.png\" alt=\"\" class=\"wp-image-3272\" srcset=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/12\/image-21.png 623w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/12\/image-21-300x143.png 300w\" sizes=\"(max-width: 623px) 100vw, 623px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%e4%bd%95%e3%81%a8%e6%8e%a5%e7%b6%9a%e3%81%99%e3%82%8b%e3%81%ae%e3%81%8b%e9%81%b8%e6%8a%9e\"><\/span>Choose what to connect to<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>The first thing to do is to set the Trigger, which is what to connect to.<\/p>\n\n\n\n<p>Please select [Webhook]. I&#039;m really happy because Zapier charges for Webhooks.<\/p>\n\n\n\n<p>Copy the Webhook URL and enter it into Ameila.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"996\" height=\"606\" src=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/12\/image-22.png\" alt=\"\" class=\"wp-image-3273\" srcset=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/12\/image-22.png 996w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/12\/image-22-300x183.png 300w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/12\/image-22-768x467.png 768w\" sizes=\"(max-width: 996px) 100vw, 996px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"amelia%e3%81%ae%e7%ae%a1%e7%90%86%e7%94%bb%e9%9d%a2%e3%81%a7webhook_url%e5%85%a5%e5%8a%9b\"><\/span>Enter webhook URL on Amelia&#039;s administration screen<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Click [Settings] &gt; [Integrations].<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"410\" src=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/12\/image-23-1024x410.png\" alt=\"\" class=\"wp-image-3274\" srcset=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/12\/image-23-1024x410.png 1024w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/12\/image-23-1536x615.png 1536w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/12\/image-23-300x120.png 300w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/12\/image-23-768x307.png 768w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/12\/image-23.png 1627w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>[Add New Web Hook]<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"671\" height=\"310\" src=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/12\/image-24.png\" alt=\"\" class=\"wp-image-3275\" srcset=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/12\/image-24.png 671w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/12\/image-24-300x139.png 300w\" sizes=\"(max-width: 671px) 100vw, 671px\" \/><\/figure>\n\n\n\n<p>Enter the required information<\/p>\n\n\n\n<ol class=\"wp-block-list\"><li>Name - Anything goes, I called it Pabbly so I wouldn&#039;t get confused about what it&#039;s connecting to.<\/li><li>URL - Paste the Webhook URL you copied earlier here.<\/li><li>Type - Set whether you want to receive information about schedules (services) or events.<\/li><li>Action - Set the timing to receive the value. In this case, it is Booking Completed. This is when the reservation is made.<\/li><\/ol>\n\n\n\n<section class=\"wp-block-uagb-section uagb-section__wrap uagb-section__background-undefined uagb-block-fdcedc8c\"><div class=\"uagb-section__overlay\"><\/div><div class=\"uagb-section__inner-wrap\">\n<p>Since you can only choose between service reservations or event reservations, you will need to set up two webhooks if you want to receive data from both, connecting one for a service and one for an event in the same process.<\/p>\n<\/div><\/section>\n\n\n\n<p>Don&#039;t forget to click Save at the end.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"621\" height=\"796\" src=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/12\/image-25.png\" alt=\"\" class=\"wp-image-3276\" srcset=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/12\/image-25.png 621w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/12\/image-25-234x300.png 234w\" sizes=\"(max-width: 621px) 100vw, 621px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"pabbly%e3%81%b8%e6%88%bb%e3%82%8a%e3%80%81capture_webhook_response%e3%82%92%e3%82%af%e3%83%aa%e3%83%83%e3%82%af\"><\/span>Return to Pabbly and click Capture Webhook Response.<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>We will check whether we can receive data from Amelia properly.<\/p>\n\n\n\n<section class=\"wp-block-uagb-section uagb-section__wrap uagb-section__background-undefined uagb-block-804e82d6\"><div class=\"uagb-section__overlay\"><\/div><div class=\"uagb-section__inner-wrap\">\n<p>While you are clicking [Capture Webhook Response], please make an actual reservation. Take action and receive data.<\/p>\n<\/div><\/section>\n\n\n\n<p>Once you receive the data, click [save]<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"996\" height=\"606\" src=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/12\/image-22.png\" alt=\"\" class=\"wp-image-3273\" srcset=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/12\/image-22.png 996w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/12\/image-22-300x183.png 300w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/12\/image-22-768x467.png 768w\" sizes=\"(max-width: 996px) 100vw, 996px\" \/><\/figure>\n\n\n\n<p>Once the data is received, it will be displayed in a list. The left side is the variable, and the right side is the actual value.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"506\" height=\"578\" src=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/12\/image-33.png\" alt=\"\" class=\"wp-image-3284\" srcset=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/12\/image-33.png 506w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/12\/image-33-263x300.png 263w\" sizes=\"(max-width: 506px) 100vw, 506px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"trigger%e3%81%ae%e5%be%8c%e3%80%81%e4%bd%95%e3%82%92%e3%81%99%e3%82%8b%e3%81%8b%e3%82%92%e8%a8%ad%e5%ae%9a\"><\/span>Set what to do after the trigger<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>After receiving the data from Amelia, we will set what to do. In this case, we will store the data in a Google Spreadsheet, so search for Google Spreadsheet in Choose App.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"332\" src=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/12\/image-26-1024x332.png\" alt=\"\" class=\"wp-image-3277\" srcset=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/12\/image-26-1024x332.png 1024w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/12\/image-26-300x97.png 300w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/12\/image-26-768x249.png 768w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/12\/image-26.png 1038w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"465\" height=\"456\" src=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/12\/image-27.png\" alt=\"\" class=\"wp-image-3278\" srcset=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/12\/image-27.png 465w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/12\/image-27-300x294.png 300w\" sizes=\"(max-width: 465px) 100vw, 465px\" \/><\/figure>\n\n\n\n<p>When you select Google Sheets, the Action Event selection screen will appear, so this time I selected [Add New Row] to add a new row.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1008\" height=\"381\" src=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/12\/image-29.png\" alt=\"\" class=\"wp-image-3280\" srcset=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/12\/image-29.png 1008w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/12\/image-29-300x113.png 300w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/12\/image-29-768x290.png 768w\" sizes=\"(max-width: 1008px) 100vw, 1008px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%e4%ba%8b%e5%89%8d%e3%81%abgoogle_spreadsheet%e3%82%92%e4%bd%9c%e6%88%90\"><\/span>Create a Google spreadsheet in advance<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Please create a Google spreadsheet in advance. Also, please add text in the first line that will be the heading for the values you want to receive.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"112\" src=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/12\/image-30-1024x112.png\" alt=\"\" class=\"wp-image-3281\" srcset=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/12\/image-30-1024x112.png 1024w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/12\/image-30-300x33.png 300w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/12\/image-30-768x84.png 768w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/12\/image-30.png 1028w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"google_spreadsheet%e3%81%a8%e6%8e%a5%e7%b6%9a\"><\/span>Connect to Google Spreadsheet<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Click [Connect With Google Sheets].<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1008\" height=\"381\" src=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/12\/image-28.png\" alt=\"\" class=\"wp-image-3279\" srcset=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/12\/image-28.png 1008w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/12\/image-28-300x113.png 300w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/12\/image-28-768x290.png 768w\" sizes=\"(max-width: 1008px) 100vw, 1008px\" \/><\/figure>\n\n\n\n<p>Connect to the Google account where you created the spreadsheet.<\/p>\n\n\n\n<ol class=\"wp-block-list\"><li>Spreadsheet - Select the file name. If you create a new one after displaying this screen, click Refresh to reflect the name and make it available for selection.<\/li><li>Sheet \u2013 Select the sheet name.<\/li><\/ol>\n\n\n\n<p><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"912\" height=\"307\" src=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/12\/image-31.png\" alt=\"\" class=\"wp-image-3282\" srcset=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/12\/image-31.png 912w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/12\/image-31-300x101.png 300w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/12\/image-31-768x259.png 768w\" sizes=\"(max-width: 912px) 100vw, 912px\" \/><\/figure>\n\n\n\n<p>The heading written in the first line will be read.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"762\" height=\"777\" src=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/12\/image-32.png\" alt=\"\" class=\"wp-image-3283\" srcset=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/12\/image-32.png 762w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/12\/image-32-294x300.png 294w\" sizes=\"(max-width: 762px) 100vw, 762px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"amelia%e3%81%a8%e3%82%b9%e3%83%97%e3%83%ac%e3%83%83%e3%83%89%e3%82%b7%e3%83%bc%e3%83%88%e3%81%ae%e7%b4%90%e3%81%a5%e3%81%91\"><\/span>Linking Amelia to a spreadsheet<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>For example, link the last name column written in the spreadsheet to the last name Amelia.<\/p>\n\n\n\n<p>Click on the three lines on the right<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"783\" height=\"217\" src=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/12\/image-34.png\" alt=\"\" class=\"wp-image-3285\" srcset=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/12\/image-34.png 783w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/12\/image-34-300x83.png 300w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/12\/image-34-768x213.png 768w\" sizes=\"(max-width: 783px) 100vw, 783px\" \/><\/figure>\n\n\n\n<p>Look at the Last Name field from the expanded items and select it. In this way, you can link the items you want to receive values from.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"413\" height=\"326\" src=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/12\/image-35.png\" alt=\"\" class=\"wp-image-3286\" srcset=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/12\/image-35.png 413w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/12\/image-35-300x237.png 300w\" sizes=\"(max-width: 413px) 100vw, 413px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%e4%bf%9d%e5%ad%98%e3%82%92%e3%81%97%e3%81%a6%e6%8e%a5%e7%b6%9a%e5%ae%8c%e4%ba%86%ef%bc%81\"><\/span>Save and connect!<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Click [Save &amp; Send Test Request] to complete the connection.<\/p>\n\n\n\n<p>Now, when a reservation is made from Amelia, the data will be automatically entered into the Google spreadsheet.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"951\" height=\"132\" src=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/12\/image-36.png\" alt=\"\" class=\"wp-image-3287\" srcset=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/12\/image-36.png 951w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/12\/image-36-300x42.png 300w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/12\/image-36-768x107.png 768w\" sizes=\"(max-width: 951px) 100vw, 951px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%e4%bb%95%e7%b5%84%e3%81%bf%e4%bd%9c%e3%82%8a%e3%81%ab%e3%81%a4%e3%81%84%e3%81%a6\"><\/span>About the mechanism<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>This action is added to the spreadsheet when the reservation is completed, so it will not work if the reservation is canceled or the date is changed.<\/p>\n\n\n\n<p>Create a sheet for cancellations and record the actions to be taken when a cancellation occurs. Create a sheet for schedule changes and record the actions to be taken when a schedule change occurs. I think it is necessary to create several types of workflows.<\/p>\n\n\n\n<p>Free consultations are available at any time.<\/p>","protected":false},"excerpt":{"rendered":"<p>wordpress\u4e88\u7d04\u30b7\u30b9\u30c6\u30e0\u30d7\u30e9\u30b0\u30a4\u30f3amelia(amelia\u516c\u5f0f\u30b5\u30a4\u30c8\u3078\u30ea\u30f3\u30af\u3057\u3066\u3044\u307e\u3059)\u306ewebhook\u6a5f\u80fd\u3092\u5229\u7528\u3057\u3066\u3001wordpress\u304b\u3089\u306e\u4e88\u7d04\u3092\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306e\u7ba1\u7406\u306b\u30c1\u30e3\u30ec\u30f3\u30b8\u3057\u305f\u3044\u3068\u601d\u3044\u307e\u3059\uff01 \u524d\u56de\u3001\u516c [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":8905,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"content-type":"","_uag_custom_page_level_css":"","footnotes":""},"categories":[168],"tags":[171,182],"class_list":["post-3268","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-reservation-plugin","tag-amelia","tag-182"],"blocksy_meta":[],"aioseo_notices":[],"uagb_featured_image_src":{"full":["https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/12\/thumnail-7.png",720,540,false],"thumbnail":["https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/12\/thumnail-7-150x150.png",150,150,true],"medium":["https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/12\/thumnail-7-300x225.png",300,225,true],"medium_large":["https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/12\/thumnail-7.png",720,540,false],"large":["https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/12\/thumnail-7.png",720,540,false],"1536x1536":["https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/12\/thumnail-7.png",720,540,false],"2048x2048":["https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/12\/thumnail-7.png",720,540,false],"trp-custom-language-flag":["https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/12\/thumnail-7.png",16,12,false]},"uagb_author_info":{"display_name":"\u682a\u5f0f\u4f1a\u793eHanamiWEB \u4ee3\u8868\u53d6\u7de0\u5f79 \u677e\u6d66\u307f\u3055","author_link":"https:\/\/hanami-web.tokyo.jp\/blog\/en\/author\/hanami\/"},"uagb_comment_info":0,"uagb_excerpt":"wordpress\u4e88\u7d04\u30b7\u30b9\u30c6\u30e0\u30d7\u30e9\u30b0\u30a4\u30f3amelia(amelia\u516c\u5f0f\u30b5\u30a4\u30c8\u3078\u30ea\u30f3\u30af\u3057\u3066\u3044\u307e\u3059)\u306ewebhoo&hellip;","brizy_media":[],"_links":{"self":[{"href":"https:\/\/hanami-web.tokyo.jp\/blog\/en\/wp-json\/wp\/v2\/posts\/3268","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hanami-web.tokyo.jp\/blog\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hanami-web.tokyo.jp\/blog\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hanami-web.tokyo.jp\/blog\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/hanami-web.tokyo.jp\/blog\/en\/wp-json\/wp\/v2\/comments?post=3268"}],"version-history":[{"count":0,"href":"https:\/\/hanami-web.tokyo.jp\/blog\/en\/wp-json\/wp\/v2\/posts\/3268\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hanami-web.tokyo.jp\/blog\/en\/wp-json\/wp\/v2\/media\/8905"}],"wp:attachment":[{"href":"https:\/\/hanami-web.tokyo.jp\/blog\/en\/wp-json\/wp\/v2\/media?parent=3268"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hanami-web.tokyo.jp\/blog\/en\/wp-json\/wp\/v2\/categories?post=3268"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hanami-web.tokyo.jp\/blog\/en\/wp-json\/wp\/v2\/tags?post=3268"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}