{"id":2870,"date":"2020-08-10T06:04:48","date_gmt":"2020-08-09T21:04:48","guid":{"rendered":"https:\/\/hanami-web.tokyo.jp\/blog\/?p=2870"},"modified":"2020-08-10T06:04:53","modified_gmt":"2020-08-09T21:04:53","slug":"auto-gmail-to-sheet","status":"publish","type":"post","link":"https:\/\/hanami-web.tokyo.jp\/blog\/en\/website-running\/auto-gmail-to-sheet\/","title":{"rendered":"To combat labor shortages and cut labor costs! Automatically register and manage emails received via Gmail in a spreadsheet"},"content":{"rendered":"<p>How do you manage your emails?<\/p>\n\n\n\n<p>Are your registration emails and emails from customers mixed up in your inbox, or are you having trouble finding old emails?<\/p>\n\n\n\n<p>Why not use Zapier, a free task automation tool, to automatically register emails received via Gmail (you can also use it if you receive emails from your own domain via Gmail) into a Google spreadsheet and manage your customers properly?<\/p>\n\n\n\n<p>Also, for those who have been manually entering customer inquiries into Excel, you can expect to reduce labor costs and alleviate labor shortages by automating email management with the free task automation tool Zapier!<\/p>\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\/website-running\/auto-gmail-to-sheet\/#zapier%e3%81%a8%e3%81%af%ef%bc%9f\" >What is Zapier?<\/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\/website-running\/auto-gmail-to-sheet\/#zapier%e3%81%ae%e7%84%a1%e6%96%99%e6%9c%89%e6%96%99%e6%96%99%e9%87%91%e3%81%ae%e9%81%95%e3%81%84\" >Differences between Zapier&#039;s free and paid pricing<\/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\/website-running\/auto-gmail-to-sheet\/#zaiper%e6%96%b0%e8%a6%8f%e7%99%bb%e9%8c%b2%e6%96%b9%e6%b3%95\" >How to register for Zaiper<\/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\/website-running\/auto-gmail-to-sheet\/#zapier%e6%96%b0%e8%a6%8f%e7%99%bb%e9%8c%b2%e3%81%a7%e5%bf%85%e8%a6%81%e6%83%85%e5%a0%b1%e3%82%92%e5%85%a5%e5%8a%9b\" >Enter the required information when registering with Zapier<\/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\/website-running\/auto-gmail-to-sheet\/#zapier%e3%81%ab%e9%80%a3%e7%b5%90%e3%81%99%e3%82%8b%e3%82%a2%e3%83%97%e3%83%aa%e3%82%92%e7%99%bb%e9%8c%b2\" >Register an app to connect to Zapier<\/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\/website-running\/auto-gmail-to-sheet\/#gmail%e3%81%ab%e5%b1%8a%e3%81%84%e3%81%9f%e3%83%a1%e3%83%bc%e3%83%ab%e3%82%92google_spledsheet%e3%81%ab%e8%87%aa%e5%8b%95%e3%82%bf%e3%82%b9%e3%82%af%e8%bf%bd%e5%8a%a0%e3%81%99%e3%82%8b%e6%96%b9%e6%b3%95\" >How to automatically add emails received in Gmail to Google Spledsheet as tasks<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/hanami-web.tokyo.jp\/blog\/en\/website-running\/auto-gmail-to-sheet\/#%ef%bc%91%ef%bc%8ezapier%e3%81%a7%e3%82%bf%e3%82%b9%e3%82%af%e3%82%92%e9%96%8b%e5%a7%8b%e3%81%99%e3%82%8b%e3%82%a2%e3%83%97%e3%83%aa%e3%82%92%e9%81%b8%e6%8a%9e%e3%81%97%e3%81%be%e3%81%99\" >1. Select the app you want to start the task with in Zapier<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/hanami-web.tokyo.jp\/blog\/en\/website-running\/auto-gmail-to-sheet\/#%ef%bc%92%ef%bc%8e%e9%96%8b%e5%a7%8b%e3%81%97%e3%81%9f%e3%82%bf%e3%82%b9%e3%82%af%e3%82%92%e3%81%a9%e3%81%ae%e3%82%a2%e3%83%97%e3%83%aa%e3%81%ab%e8%87%aa%e5%8b%95%e9%80%a3%e6%90%ba%e3%81%99%e3%82%8b%e3%81%8b%e8%a8%ad%e5%ae%9a\" >2. Set which app to automatically link the started task to<\/a><\/li><\/ul><\/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\/website-running\/auto-gmail-to-sheet\/#%e3%81%be%e3%81%a8%e3%82%81\" >summary<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"zapier%e3%81%a8%e3%81%af%ef%bc%9f\"><\/span>What is Zapier?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>As of 2020, it is a very popular task management tool across the United States that can connect with over 2,000 apps to automatically manage various tasks.<\/p>\n\n\n\n<p>The reason for its popularity is that it is an excellent tool that allows you to easily connect various apps without the need for code and automate task management!<\/p>\n\n\n\n<p>Even better, it&#039;s basically free to use!<\/p>\n\n\n\n<div class=\"wp-block-cocoon-blocks-icon-box information-box common-icon-box block-box\">\n<p>You can easily connect with Google apps such as Gmail and Google Calendar, social networking sites such as Twitter, Facebook, Instagram, and many other apps!<\/p>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"zapier%e3%81%ae%e7%84%a1%e6%96%99%e6%9c%89%e6%96%99%e6%96%99%e9%87%91%e3%81%ae%e9%81%95%e3%81%84\"><\/span>Differences between Zapier&#039;s free and paid pricing<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>There are five different plans available, ranging from free to approximately 63,000 yen per month.<\/p>\n\n\n\n<p>The free plan allows you to manage up to 100 tasks per month. Data is updated every 15 minutes.<\/p>\n\n\n\n<p>The plan you need to sign up for will depend on your usage, such as the number of tasks you want to manage per month and the apps you want to use, which may be available only to paid subscribers.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img decoding=\"async\" width=\"795\" height=\"797\" src=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/08\/image-9.png\" alt=\"\u4eba\u4ef6\u8cbb\u30fb\u30b3\u30b9\u30c8\u5927\u5e45\u30ab\u30c3\u30c8\u3078\uff01\u30bf\u30b9\u30af\u81ea\u52d5\u7ba1\u7406\u30c4\u30fc\u30ebZapier\u306e\u7121\u6599\u30fb\u6709\u6599\u306e\u9055\u3044\" class=\"wp-image-2874\" srcset=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/08\/image-9.png 795w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/08\/image-9-100x100.png 100w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/08\/image-9-150x150.png 150w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/08\/image-9-300x300.png 300w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/08\/image-9-768x770.png 768w\" sizes=\"(max-width: 795px) 100vw, 795px\" \/><\/figure><\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"zaiper%e6%96%b0%e8%a6%8f%e7%99%bb%e9%8c%b2%e6%96%b9%e6%b3%95\"><\/span>How to register for Zaiper<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>You can easily complete the new registration by clicking [Sign Up with Google].<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img decoding=\"async\" width=\"1024\" height=\"525\" src=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/08\/image-6-1024x525.png\" alt=\"\u4eba\u4ef6\u8cbb\u30fb\u30b3\u30b9\u30c8\u5927\u5e45\u30ab\u30c3\u30c8\u3078\uff01\u30bf\u30b9\u30af\u81ea\u52d5\u7ba1\u7406\u30c4\u30fc\u30ebZapier\u306e\u65b0\u898f\u767b\u9332\u65b9\u6cd5\" class=\"wp-image-2871\" srcset=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/08\/image-6-1024x525.png 1024w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/08\/image-6-1536x788.png 1536w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/08\/image-6-300x154.png 300w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/08\/image-6-768x394.png 768w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/08\/image-6.png 1622w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"zapier%e6%96%b0%e8%a6%8f%e7%99%bb%e9%8c%b2%e3%81%a7%e5%bf%85%e8%a6%81%e6%83%85%e5%a0%b1%e3%82%92%e5%85%a5%e5%8a%9b\"><\/span>Enter the required information when registering with Zapier<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li>Choose a role<\/li><li>Choose an industry<\/li><li>And my company has this many employees<\/li><\/ul>\n\n\n\n<p>Finally, click [Continue]. You can also [Skip] without registering now.<\/p>\n\n\n\n<div class=\"wp-block-cocoon-blocks-icon-box information-box common-icon-box block-box\">\n<p>It&#039;s written in English, so it&#039;s easier to understand if you use your browser&#039;s translation function to translate it!<\/p>\n<\/div>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"397\" src=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/08\/image-7-1024x397.png\" alt=\"\u4eba\u4ef6\u8cbb\u30fb\u30b3\u30b9\u30c8\u5927\u5e45\u30ab\u30c3\u30c8\u3078\uff01\u30bf\u30b9\u30af\u81ea\u52d5\u7ba1\u7406\u30c4\u30fc\u30ebZapier\u306e\u65b0\u898f\u4f1a\u54e1\u767b\u9332\" class=\"wp-image-2872\" srcset=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/08\/image-7-1024x397.png 1024w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/08\/image-7-1536x595.png 1536w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/08\/image-7-300x116.png 300w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/08\/image-7-768x297.png 768w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/08\/image-7.png 1880w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><figcaption>Z<\/figcaption><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"zapier%e3%81%ab%e9%80%a3%e7%b5%90%e3%81%99%e3%82%8b%e3%82%a2%e3%83%97%e3%83%aa%e3%82%92%e7%99%bb%e9%8c%b2\"><\/span>Register an app to connect to Zapier<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Gmail\/Google Calendar\/Google Contacts... are already selected, so first delete any you don&#039;t need with an &quot;X&quot;, and then select the icon of the service you integrated with Zapier.<\/p>\n\n\n\n<p>Finally, click \u3010Dinish Setup\u3011 to complete the initial setup!<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img decoding=\"async\" width=\"1024\" height=\"582\" src=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/08\/image-8-1024x582.png\" alt=\"\u4eba\u4ef6\u8cbb\u30fb\u30b3\u30b9\u30c8\u5927\u5e45\u30ab\u30c3\u30c8\u3078\uff01\u30bf\u30b9\u30af\u81ea\u52d5\u7ba1\u7406\u30c4\u30fc\u30ebZapier\u3067\u81ea\u52d5\u5316\u3055\u305b\u308b\u30a2\u30d7\u30ea\u3092\u9078\u629e\" class=\"wp-image-2873\" srcset=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/08\/image-8-1024x582.png 1024w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/08\/image-8-120x68.png 120w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/08\/image-8-160x90.png 160w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/08\/image-8-300x171.png 300w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/08\/image-8-768x437.png 768w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/08\/image-8.png 1398w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n\n<p>Now let&#039;s set up the tasks we want to automate!<\/p>\n\n\n\n<p>The free plan only has 5 options, so start with<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"gmail%e3%81%ab%e5%b1%8a%e3%81%84%e3%81%9f%e3%83%a1%e3%83%bc%e3%83%ab%e3%82%92google_spledsheet%e3%81%ab%e8%87%aa%e5%8b%95%e3%82%bf%e3%82%b9%e3%82%af%e8%bf%bd%e5%8a%a0%e3%81%99%e3%82%8b%e6%96%b9%e6%b3%95\"><\/span>How to automatically add emails received in Gmail to Google Spledsheet as tasks<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Click [MAKE A ZAP] to register a new task.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img decoding=\"async\" width=\"1024\" height=\"500\" src=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/08\/image-11-1024x500.png\" alt=\"\u4eba\u4ef6\u8cbb\u30fb\u30b3\u30b9\u30c8\u5927\u5e45\u30ab\u30c3\u30c8\u3078\uff01\u30bf\u30b9\u30af\u81ea\u52d5\u7ba1\u7406\u30c4\u30fc\u30ebZapier\u3067Gmail\u3092\u81ea\u52d5\u3067\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3078\u8ffd\u52a0\u3059\u308b\u8a2d\u5b9a\" class=\"wp-image-2876\" srcset=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/08\/image-11-1024x500.png 1024w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/08\/image-11-1536x750.png 1536w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/08\/image-11-300x146.png 300w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/08\/image-11-768x375.png 768w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/08\/image-11.png 1872w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%ef%bc%91%ef%bc%8ezapier%e3%81%a7%e3%82%bf%e3%82%b9%e3%82%af%e3%82%92%e9%96%8b%e5%a7%8b%e3%81%99%e3%82%8b%e3%82%a2%e3%83%97%e3%83%aa%e3%82%92%e9%81%b8%e6%8a%9e%e3%81%97%e3%81%be%e3%81%99\"><\/span>1. Select the app you want to start the task with in Zapier<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>When this happens. Register the action that will occur when Zapier automatically starts the task.<\/p>\n\n\n\n<p>The app used is Gmail.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"657\" src=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/08\/image-12-1024x657.png\" alt=\"\u4eba\u4ef6\u8cbb\u30fb\u30b3\u30b9\u30c8\u5927\u5e45\u30ab\u30c3\u30c8\u3078\uff01\u30bf\u30b9\u30af\u81ea\u52d5\u7ba1\u7406\u30c4\u30fc\u30ebZapier\u3067Gmail\u3092\u81ea\u52d5\u3067\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3078\u8ffd\u52a0\u3059\u308b\u8a2d\u5b9a\" class=\"wp-image-2877\" srcset=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/08\/image-12-1024x657.png 1024w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/08\/image-12-300x193.png 300w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/08\/image-12-768x493.png 768w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/08\/image-12.png 1142w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\">Select an event in the app of your choice<\/h4>\n\n\n\n<p>Since I have some unnecessary emails, instead of managing all emails, I set it up to start when a label is added with [New label Email].<\/p>\n\n\n\n<div class=\"wp-block-cocoon-blocks-icon-box information-box common-icon-box block-box\">\n<p>I decided to automatically manage the inquiries emails received at info@~ and emails with customers.<\/p>\n\n\n\n<p>You need to create labels in Gmail to which the emails you want to manage will be assigned in advance.<\/p>\n<\/div>\n\n\n\n<p>Click [Continue].<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"537\" src=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/08\/image-13-1024x537.png\" alt=\"\u4eba\u4ef6\u8cbb\u30fb\u30b3\u30b9\u30c8\u5927\u5e45\u30ab\u30c3\u30c8\u3078\uff01\u30bf\u30b9\u30af\u81ea\u52d5\u7ba1\u7406\u30c4\u30fc\u30ebZapier\u3067Gmail\u3092\u81ea\u52d5\u3067\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3078\u8ffd\u52a0\u3059\u308b\u8a2d\u5b9a\" class=\"wp-image-2878\" srcset=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/08\/image-13-1024x537.png 1024w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/08\/image-13-300x157.png 300w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/08\/image-13-768x403.png 768w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/08\/image-13.png 1135w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\">Sign in to Gmail<\/h4>\n\n\n\n<p>Select the Gmail account you want to link tasks with via Zapier and click [Continue].<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"346\" src=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/08\/image-14-1024x346.png\" alt=\"\u4eba\u4ef6\u8cbb\u30fb\u30b3\u30b9\u30c8\u5927\u5e45\u30ab\u30c3\u30c8\u3078\uff01\u30bf\u30b9\u30af\u81ea\u52d5\u7ba1\u7406\u30c4\u30fc\u30ebZapier\u3067Gmail\u3092\u81ea\u52d5\u3067\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3078\u8ffd\u52a0\u3059\u308b\u8a2d\u5b9a\" class=\"wp-image-2879\" srcset=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/08\/image-14-1024x346.png 1024w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/08\/image-14-300x101.png 300w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/08\/image-14-768x259.png 768w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/08\/image-14.png 1146w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\">Zapier will run a test to see if it can connect to Gmail.<\/h4>\n\n\n\n<p>Click [Test trigger].<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"481\" src=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/08\/image-16-1024x481.png\" alt=\"\u4eba\u4ef6\u8cbb\u30fb\u30b3\u30b9\u30c8\u5927\u5e45\u30ab\u30c3\u30c8\u3078\uff01\u30bf\u30b9\u30af\u81ea\u52d5\u7ba1\u7406\u30c4\u30fc\u30ebZapier\u3067Gmail\u3092\u81ea\u52d5\u3067\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3078\u8ffd\u52a0\u3059\u308b\u8a2d\u5b9a\" class=\"wp-image-2881\" srcset=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/08\/image-16-1024x481.png 1024w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/08\/image-16-300x141.png 300w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/08\/image-16-768x361.png 768w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/08\/image-16.png 1106w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>The message \u3010Find Data\u3011 was displayed, confirming that the target data exists.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img decoding=\"async\" width=\"1024\" height=\"205\" src=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/08\/image-17-1024x205.png\" alt=\"\u4eba\u4ef6\u8cbb\u30fb\u30b3\u30b9\u30c8\u5927\u5e45\u30ab\u30c3\u30c8\u3078\uff01\u30bf\u30b9\u30af\u81ea\u52d5\u7ba1\u7406\u30c4\u30fc\u30ebZapier\u3067Gmail\u3092\u81ea\u52d5\u3067\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3078\u8ffd\u52a0\u3059\u308b\u8a2d\u5b9a\" class=\"wp-image-2882\" srcset=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/08\/image-17-1024x205.png 1024w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/08\/image-17-300x60.png 300w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/08\/image-17-768x154.png 768w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/08\/image-17.png 1035w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n\n<p>Click [Continue].<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%ef%bc%92%ef%bc%8e%e9%96%8b%e5%a7%8b%e3%81%97%e3%81%9f%e3%82%bf%e3%82%b9%e3%82%af%e3%82%92%e3%81%a9%e3%81%ae%e3%82%a2%e3%83%97%e3%83%aa%e3%81%ab%e8%87%aa%e5%8b%95%e9%80%a3%e6%90%ba%e3%81%99%e3%82%8b%e3%81%8b%e8%a8%ad%e5%ae%9a\"><\/span>2. Set which app to automatically link the started task to<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Select which app you want to link the launched Gmail app with.<\/p>\n\n\n\n<p>This time, select Google Sheets.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img decoding=\"async\" width=\"1024\" height=\"620\" src=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/08\/image-19-1024x620.png\" alt=\"\u4eba\u4ef6\u8cbb\u30fb\u30b3\u30b9\u30c8\u5927\u5e45\u30ab\u30c3\u30c8\u3078\uff01\u30bf\u30b9\u30af\u81ea\u52d5\u7ba1\u7406\u30c4\u30fc\u30ebZapier\u3067Gmail\u3092\u81ea\u52d5\u3067\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3078\u8ffd\u52a0\u3059\u308b\u8a2d\u5b9a\" class=\"wp-image-2884\" srcset=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/08\/image-19-1024x620.png 1024w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/08\/image-19-300x182.png 300w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/08\/image-19-768x465.png 768w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/08\/image-19.png 1111w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n\n<h4 class=\"wp-block-heading\">Select the event to be held on Google Sheets<\/h4>\n\n\n\n<p>This time, we will set it to add a new row to the spreadsheet. [Create Spredsheet Row]<\/p>\n\n\n\n<p>Click [Coninue].<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"407\" src=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/08\/image-20-1024x407.png\" alt=\"\u4eba\u4ef6\u8cbb\u30fb\u30b3\u30b9\u30c8\u5927\u5e45\u30ab\u30c3\u30c8\u3078\uff01\u30bf\u30b9\u30af\u81ea\u52d5\u7ba1\u7406\u30c4\u30fc\u30ebZapier\u3067Gmail\u3092\u81ea\u52d5\u3067\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3078\u8ffd\u52a0\u3059\u308b\u8a2d\u5b9a\" class=\"wp-image-2885\" srcset=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/08\/image-20-1024x407.png 1024w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/08\/image-20-300x119.png 300w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/08\/image-20-768x305.png 768w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/08\/image-20.png 1097w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h5 class=\"wp-block-heading\">Sign in to Google Sheets<\/h5>\n\n\n\n<p>Sign in to Google Sheets.<\/p>\n\n\n\n<p>Once you&#039;ve signed in, click Continue.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"384\" src=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/08\/image-21-1024x384.png\" alt=\"\u4eba\u4ef6\u8cbb\u30fb\u30b3\u30b9\u30c8\u5927\u5e45\u30ab\u30c3\u30c8\u3078\uff01\u30bf\u30b9\u30af\u81ea\u52d5\u7ba1\u7406\u30c4\u30fc\u30ebZapier\u3067Gmail\u3092\u81ea\u52d5\u3067\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3078\u8ffd\u52a0\u3059\u308b\u8a2d\u5b9a\" class=\"wp-image-2886\" srcset=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/08\/image-21-1024x384.png 1024w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/08\/image-21-300x112.png 300w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/08\/image-21-768x288.png 768w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/08\/image-21.png 1107w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\">Select the sheet to which you want to automatically add tasks via Zapier<\/h4>\n\n\n\n<p>Prepare a spreadsheet in advance<\/p>\n\n\n\n<ol class=\"wp-block-list\"><li>Create a new spreadsheet<\/li><li>Change the sheet names in the spreadsheet to make them easier to understand (optional)<\/li><li>Add a heading to the first line \u2013 in this case I used Data\/Name\/Subject\/Content.<\/li><\/ol>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"590\" height=\"315\" src=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/08\/image-25.png\" alt=\"\u4eba\u4ef6\u8cbb\u30fb\u30b3\u30b9\u30c8\u5927\u5e45\u30ab\u30c3\u30c8\u3078\uff01\u30bf\u30b9\u30af\u81ea\u52d5\u7ba1\u7406\u30c4\u30fc\u30ebZapier\u3067Gmail\u3092\u81ea\u52d5\u3067\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3078\u8ffd\u52a0\u3059\u308b\u8a2d\u5b9a\" class=\"wp-image-2890\" srcset=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/08\/image-25.png 590w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/08\/image-25-300x160.png 300w\" sizes=\"(max-width: 590px) 100vw, 590px\" \/><\/figure>\n\n\n\n<div class=\"wp-block-cocoon-blocks-icon-box alert-box common-icon-box block-box\">\n<p>When using Google Spreadsheets, you must add a heading containing text in the first row!<\/p>\n<\/div>\n\n\n\n<p>Once your spreadsheet is ready, you can set it up in Zapier.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Drive - Select the drive containing the sheet you want to automatically add<\/li><li>Spredsheet - Select file name<\/li><li>Worksheet - Select a sheet<\/li><\/ul>\n\n\n\n<p>This time, I created a Spredsheet named Info Email Management and created a sheet named 202008. When September comes, I plan to create a 202009 sheet and make changes so that it is automatically added to the new sheet.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"652\" src=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/08\/image-22-1024x652.png\" alt=\"\u4eba\u4ef6\u8cbb\u30fb\u30b3\u30b9\u30c8\u5927\u5e45\u30ab\u30c3\u30c8\u3078\uff01\u30bf\u30b9\u30af\u81ea\u52d5\u7ba1\u7406\u30c4\u30fc\u30ebZapier\u3067Gmail\u3092\u81ea\u52d5\u3067\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3078\u8ffd\u52a0\u3059\u308b\u8a2d\u5b9a\" class=\"wp-image-2887\" srcset=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/08\/image-22-1024x652.png 1024w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/08\/image-22-300x191.png 300w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/08\/image-22-768x489.png 768w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/08\/image-22.png 1118w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<div class=\"wp-block-cocoon-blocks-icon-box information-box common-icon-box block-box\">\n<p>When you select Worksheet, the headings will be loaded and the email items corresponding to the headings will be set. For example, select Data \u2192 Date when the email was received, and set it. I set it as follows.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Data - Data<\/li><li>Name - Raw Payload Headers From (name and email address)<\/li><li>Subject-Subject<\/li><li>Content-Row Snippetd (so that the content is displayed on a single line)<\/li><\/ul>\n\n\n\n<p>The content part is displayed on one line.<\/p>\n<\/div>\n\n\n\n<p>Finally, click [Continue].<\/p>\n\n\n\n<div class=\"wp-block-cocoon-blocks-icon-box information-box common-icon-box block-box\">\n<p>Since you can test it, the task setting is OFF by default, so switch it ON and actually test it to see how the data is automatically entered, and make corrections if the results are not what you expected.<\/p>\n<\/div>\n\n\n\n<p>Finally, click [Done edit] to finish the settings.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%e3%81%be%e3%81%a8%e3%82%81\"><\/span>summary<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>This was my first time using Zapier. The reason was that the instructions for using webhooks in WordPress included instructions on how to connect with Zapier.<\/p>\n\n\n\n<p>Recently, with the trend towards non-face-to-face meetings and working from home, many jobs need to be automated. Labor shortages are also becoming serious.<\/p>\n\n\n\n<p>In fact, on hanami-web<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/hanami-web.tokyo.jp\/blog\/en\/reservation-amelia-content\/\">Automate reservation management<\/a><\/li><li>Automating email management<\/li><\/ul>\n\n\n\n<p>I would like to continue sharing information that I find recommended.<\/p>","protected":false},"excerpt":{"rendered":"<p>\u7686\u3055\u3093\u306f\u30e1\u30fc\u30eb\u306e\u7ba1\u7406\u3069\u306e\u3088\u3046\u306b\u3057\u3066\u3044\u307e\u3059\u304b\uff1f \u4f1a\u54e1\u767b\u9332\u3092\u3057\u305f\u30e1\u30fc\u30eb\u3068\u304a\u5ba2\u69d8\u304b\u3089\u306e\u30e1\u30fc\u30eb\u304c\u53d7\u4fe1\u30dc\u30c3\u30af\u30b9\u306b\u6df7\u3056\u3063\u3066\u3044\u305f\u308a\u3001\u6614\u306e\u30e1\u30fc\u30eb\u3092\u78ba\u8a8d\u3059\u308b\u6642\u306b\u898b\u3064\u3051\u51fa\u305b\u306a\u304b\u3063\u305f\u308a\u3057\u3066\u3044\u307e\u305b\u3093\u304b\uff1f \u7121\u6599\u3067\u767b\u9332\u3067\u304d\u308b\u30bf\u30b9\u30af\u81ea\u52d5\u7ba1\u7406\u30c4\u30fc\u30ebZa [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":2871,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"content-type":"","_uag_custom_page_level_css":"","footnotes":""},"categories":[6],"tags":[],"class_list":["post-2870","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-website-running"],"blocksy_meta":[],"aioseo_notices":[],"uagb_featured_image_src":{"full":["https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/08\/image-6.png",1622,832,false],"thumbnail":["https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/08\/image-6-150x150.png",150,150,true],"medium":["https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/08\/image-6-300x154.png",300,154,true],"medium_large":["https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/08\/image-6-768x394.png",768,394,true],"large":["https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/08\/image-6-1024x525.png",1024,525,true],"1536x1536":["https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/08\/image-6-1536x788.png",1536,788,true],"2048x2048":["https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/08\/image-6.png",1622,832,false],"trp-custom-language-flag":["https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2020\/08\/image-6.png",18,9,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":"\u7686\u3055\u3093\u306f\u30e1\u30fc\u30eb\u306e\u7ba1\u7406\u3069\u306e\u3088\u3046\u306b\u3057\u3066\u3044\u307e\u3059\u304b\uff1f \u4f1a\u54e1\u767b\u9332\u3092\u3057\u305f\u30e1\u30fc\u30eb\u3068\u304a\u5ba2\u69d8\u304b\u3089\u306e\u30e1\u30fc\u30eb\u304c\u53d7\u4fe1\u30dc\u30c3\u30af\u30b9\u306b\u6df7\u3056\u3063\u3066&hellip;","brizy_media":[],"_links":{"self":[{"href":"https:\/\/hanami-web.tokyo.jp\/blog\/en\/wp-json\/wp\/v2\/posts\/2870","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=2870"}],"version-history":[{"count":0,"href":"https:\/\/hanami-web.tokyo.jp\/blog\/en\/wp-json\/wp\/v2\/posts\/2870\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hanami-web.tokyo.jp\/blog\/en\/wp-json\/wp\/v2\/media\/2871"}],"wp:attachment":[{"href":"https:\/\/hanami-web.tokyo.jp\/blog\/en\/wp-json\/wp\/v2\/media?parent=2870"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hanami-web.tokyo.jp\/blog\/en\/wp-json\/wp\/v2\/categories?post=2870"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hanami-web.tokyo.jp\/blog\/en\/wp-json\/wp\/v2\/tags?post=2870"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}