{"id":136,"date":"2018-09-04T05:55:12","date_gmt":"2018-09-04T05:55:12","guid":{"rendered":"http:\/\/isr.sg\/singapore-property-blog\/?p=136"},"modified":"2018-09-04T11:00:43","modified_gmt":"2018-09-04T11:00:43","slug":"using-zapier-to-automate-data","status":"publish","type":"post","link":"https:\/\/isr.sg\/singapore-property-blog\/2018\/09\/04\/using-zapier-to-automate-data\/","title":{"rendered":"Using Zapier to automate data (entry, process, analysis)"},"content":{"rendered":"<h2>Zapier is Awesome! And it can help save you so much time!<\/h2>\n<p>But more importantly<\/p>\n<ul>\n<li>Is it easy?<\/li>\n<li>Is it useful for Real Estate Agents?<\/li>\n<\/ul>\n<h3>What exactly is Zapier?<\/h3>\n<blockquote><p>Zapier is the &#8220;glue&#8221; that connects more than 1000 web apps<\/p><\/blockquote>\n<p>It&#8217;s an automation tool that can link up the different online applications that you are already using.<\/p>\n<p><strong>Getting &#8220;clean data&#8221; out of your emails<br \/>\n<\/strong><\/p>\n<p>You might be using Gmail, and you receive lots of repetitive emails (bills, enquiries, contracts, etc).<\/p>\n<ul>\n<li>Bills &#8211; related to business or property expenses<\/li>\n<li>Enquiries &#8211; from property portals, referrals, past clients<\/li>\n<li>Contracts &#8211; existing transactions<\/li>\n<\/ul>\n<p>And you are thinking of a way to &#8220;collect and organise&#8221; these information properly. Perhaps,\u00a0 you thought &#8220;labels and folders&#8221; was the way to organise?<\/p>\n<p><strong>Well, yes &#8230; but!<\/strong><\/p>\n<p>You now have the ability to <strong>Transfer\/Transform Data from email into a spreadsheet<\/strong> (such as Airtable) which will offer much more functions for control, organising, automation, retrieval and re-production.<\/p>\n<p>Using specific formula in a spreadsheet to<\/p>\n<ol>\n<li>Control the dates<\/li>\n<li>Split data cells, extracting only the necessary<\/li>\n<li>Applying relevant tags or @mentions for your team users&#8217; attention<\/li>\n<\/ol>\n<p><strong>An example<\/strong><\/p>\n<p>Below, we show how the data from Gmail can be =&gt; sent through Zapier =&gt; into Airtable.<\/p>\n<p>Airtable will then auto-calculate some important dates based on the formula you input.<\/p>\n<p>And send the data through Zapier into Google Calendar, which can be preset with email\/pop-up reminders.<\/p>\n<p><img loading=\"lazy\" class=\"alignnone size-full wp-image-137\" src=\"http:\/\/isr.sg\/singapore-property-blog\/wp-content\/uploads\/2018\/09\/20180904_133847.gif\" alt=\"\" width=\"1304\" height=\"728\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Zapier is Awesome! And it can help save you so much time! But more importantly Is it easy? Is it useful for Real Estate Agents? What exactly is Zapier? Zapier[&#8230;]<\/p>\n","protected":false},"author":1,"featured_media":139,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[7],"tags":[29,8,27,9,43],"_links":{"self":[{"href":"https:\/\/isr.sg\/singapore-property-blog\/wp-json\/wp\/v2\/posts\/136"}],"collection":[{"href":"https:\/\/isr.sg\/singapore-property-blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/isr.sg\/singapore-property-blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/isr.sg\/singapore-property-blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/isr.sg\/singapore-property-blog\/wp-json\/wp\/v2\/comments?post=136"}],"version-history":[{"count":10,"href":"https:\/\/isr.sg\/singapore-property-blog\/wp-json\/wp\/v2\/posts\/136\/revisions"}],"predecessor-version":[{"id":149,"href":"https:\/\/isr.sg\/singapore-property-blog\/wp-json\/wp\/v2\/posts\/136\/revisions\/149"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/isr.sg\/singapore-property-blog\/wp-json\/wp\/v2\/media\/139"}],"wp:attachment":[{"href":"https:\/\/isr.sg\/singapore-property-blog\/wp-json\/wp\/v2\/media?parent=136"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/isr.sg\/singapore-property-blog\/wp-json\/wp\/v2\/categories?post=136"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/isr.sg\/singapore-property-blog\/wp-json\/wp\/v2\/tags?post=136"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}