{"id":8073,"date":"2026-01-26T08:18:41","date_gmt":"2026-01-26T01:18:41","guid":{"rendered":"https:\/\/inrealitysolutions.com\/make-automation-email-parsing-google-sheets\/"},"modified":"2026-01-28T09:59:25","modified_gmt":"2026-01-28T02:59:25","slug":"make-automation-email-parsing-google-sheets","status":"publish","type":"post","link":"https:\/\/inrealitysolutions.com\/id\/make-automation-email-parsing-google-sheets\/","title":{"rendered":"Make Automation Email Parsing Google Sheets \u2014 Make Workflow Step by Step"},"content":{"rendered":"<h1 id=\"make-automation-email-parsing-google-sheets-cara-make-workflow-langkah-demi-langkah\"><img fetchpriority=\"high\" decoding=\"async\" class=\"aligncenter size-full wp-image-8113\" src=\"http:\/\/inrealitysolutions.com\/wp-content\/uploads\/2026\/01\/Prod-25.jpg\" alt=\"\" width=\"1080\" height=\"1080\" srcset=\"https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2026\/01\/Prod-25.jpg 1080w, https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2026\/01\/Prod-25-300x300.jpg 300w, https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2026\/01\/Prod-25-1024x1024.jpg 1024w, https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2026\/01\/Prod-25-150x150.jpg 150w, https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2026\/01\/Prod-25-768x768.jpg 768w, https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2026\/01\/Prod-25-12x12.jpg 12w\" sizes=\"(max-width: 1080px) 100vw, 1080px\" \/>Make Automation Email Parsing Google Sheets \u2014 Make Workflow Step by Step<\/h1>\n<ul class=\"key-takeaways\">\n<li>Otomasi parsing email ke Google Sheets untuk mengurangi input manual dan mempercepat alur data.<\/li>\n<li>Gunakan modul Watch Emails \u2192 Parse \u2192 Search Rows (dedupe) \u2192 Append Row di Make (Integromat).<\/li>\n<li>Regex siap-pakai dan strategi dedupe (unique key \/ hash \/ time-window) membantu menjaga kualitas data.<\/li>\n<li>Uji dengan sample .eml\/.txt, aktifkan logging, dan gunakan notifikasi untuk monitoring operasi.<\/li>\n<\/ul>\n<nav class=\"toc\" aria-label=\"Daftar isi\"><strong>Daftar isi<\/strong><\/p>\n<ul>\n<li><a href=\"#pendahuluan\">Pendahuluan<\/a><\/li>\n<li><a href=\"#gambaran-alur-make-automation-untuk-parse-email\">Gambaran Alur<\/a><\/li>\n<li><a href=\"#prasyarat-dan-persiapan-cara-make-workflow\">Prasyarat &amp; Persiapan<\/a><\/li>\n<li><a href=\"#skenario-contoh-pakai-sepanjang-panduan\">Skenario contoh<\/a><\/li>\n<li><a href=\"#make-tutorial-step-by-step-cara-make-workflow\">Make tutorial \u2014 Step-by-step<\/a><\/li>\n<li><a href=\"#contoh-regex-dan-template-parsing\">Contoh regex &amp; template parsing<\/a><\/li>\n<li><a href=\"#strategi-dedupe-pendekatan-dan-rekomendasi\">Strategi dedupe<\/a><\/li>\n<li><a href=\"#error-handling-testing-dan-monitoring\">Error handling, testing &amp; monitoring<\/a><\/li>\n<li><a href=\"#checklist-implementasi-cepat-one-page\">Checklist implementasi cepat<\/a><\/li>\n<li><a href=\"#faq-singkat-5\">FAQ<\/a><\/li>\n<li><a href=\"#mengapa-inreality-solutions-cocok-untuk-proyek-otomasi-anda\">Mengapa InReality Solutions<\/a><\/li>\n<li><a href=\"#konsultasi-demo-ai-automations-agentic-ai-cta\">Konsultasi &amp; Demo (CTA)<\/a><\/li>\n<li><a href=\"#kesimpulan-ringkas-manfaat\">Kesimpulan<\/a><\/li>\n<\/ul>\n<\/nav>\n<h2 id=\"pendahuluan\">Pendahuluan<\/h2>\n<p>Make automation email parsing google sheets akan menghemat waktu tim Anda dengan mengotomatiskan proses input data dari email ke Google Sheets. Artikel ini memberikan panduan praktis: bagaimana parse email, lakukan dedupe, dan append row otomatis menggunakan Make (sebelumnya Integromat) \u2014 cocok untuk tim e\u2011commerce, marketing, atau operasional. Untuk contoh teknis dan demo parsing, referensi yang dipakai berasal dari <a href=\"https:\/\/community.make.com\/t\/map-email-body-data-into-google-sheets-row\/85149\">dokumentasi komunitas Make<\/a> dan <a href=\"https:\/\/www.youtube.com\/watch?v=-3ENIZyWkeg\">tutorial video terkait<\/a>. Bahan referensi tambahan tersedia di <a href=\"https:\/\/inrealitysolutions.com\/id\/mailchimp-automation-email-parsing-google-sheets\/\">InReality Solutions \u2014 Mailchimp automation<\/a>.<\/p>\n<h2 id=\"gambaran-alur-make-automation-untuk-parse-email\">Gambaran Alur Make automation untuk parse email<\/h2>\n<p>Tujuan: Beri gambaran langkah-langkah utama sehingga Anda paham flow sebelum masuk teknis.<\/p>\n<p>Alur singkat: Email masuk (Gmail\/IMAP) \u2192 Make Scenario: Watch Emails \u2192 Parse email (regex\/email2sheet) \u2192 Search Rows (dedupe) \u2192 Append Row ke Google Sheets \u2192 Notifikasi\/log. Contoh kasus serupa dan diskusi mapping tersedia di thread komunitas Make: <a href=\"https:\/\/community.make.com\/t\/map-email-body-data-into-google-sheets-row\/85149\">Map Email Body Data into Google Sheets Row<\/a>. Referensi implementasi lainnya di <a href=\"https:\/\/inrealitysolutions.com\/id\/make-automation-appointment-booking-whatsapp\/\">InReality Solutions \u2014 Make automation appointment booking<\/a>.<\/p>\n<h2 id=\"prasyarat-dan-persiapan-cara-make-workflow\">Prasyarat &amp; Persiapan (cara make workflow)<\/h2>\n<p>Tujuan: Daftar aset &amp; izin yang harus disiapkan.<\/p>\n<ul>\n<li>Akun Make (freemium\/berbayar) \u2014 perhatikan batas operasi di tier Anda (lihat <a href=\"https:\/\/www.youtube.com\/watch?v=-3ENIZyWkeg\">tutorial video<\/a>).<\/li>\n<li>Koneksi Gmail atau IMAP dan otorisasi Google Sheets (OAuth). Dokumentasi terkait import Gmail\u2192Sheets disertakan untuk pengecekan izin: <a href=\"https:\/\/support.google.com\/docs\/thread\/244962799\/is-it-possible-to-automatically-import-data-from-gmail-into-google-sheets?hl=en\">Google Support thread<\/a>.<\/li>\n<li>Google Sheets template dengan header sesuai kebutuhan (mis. Order ID, Customer Name, Item, Price, Order Date). Contoh template dan praktik form\u2192CRM di <a href=\"https:\/\/inrealitysolutions.com\/id\/google-sheets-automation-form-crm\/\">InReality Solutions \u2014 Google Sheets Automation<\/a>.<\/li>\n<li>Contoh email sample (.eml\/.txt) untuk testing.<\/li>\n<\/ul>\n<h2 id=\"skenario-contoh-pakai-sepanjang-panduan\">Skenario contoh (pakai sepanjang panduan)<\/h2>\n<p>Tujuan: Tetapkan dua skenario nyata yang akan di-parse.<\/p>\n<ul>\n<li><strong>Contoh A \u2014 E\u2011commerce<\/strong> (sender: orders@tokoprofittoko.co.id): fields = order_id, customer_name, item, price, order_date. Sample body:\n<pre><code>Subject: Order Confirmation #12345\nDear John Doe,\nYour order: Laptop, Total: $999.00\nDate: 2026-01-26<\/code><\/pre>\n<\/li>\n<li><strong>Contoh B \u2014 Lead capture<\/strong> (sender: leads@kampus.ac.id): fields = name, email, phone, source. Referensi enrichment di <a href=\"https:\/\/inrealitysolutions.com\/id\/google-sheets-automation-lead-enrichment\/\">Google Sheets Automation: Lead Enrichment<\/a>.<\/li>\n<\/ul>\n<h2 id=\"make-tutorial-step-by-step-cara-make-workflow\">Make tutorial \u2014 Step-by-step: cara make workflow<\/h2>\n<p>Tujuan: Instruksi praktis supaya pembaca dapat meniru.<\/p>\n<h3 id=\"buat-new-scenario-di-make\">1) Buat New Scenario di Make<\/h3>\n<p>Login ke <a href=\"https:\/\/www.make.com\">Make.com<\/a> \u2192 Scenarios \u2192 Create a new scenario. Pilih trigger Gmail atau IMAP. (lihat <a href=\"https:\/\/www.youtube.com\/watch?v=-3ENIZyWkeg\">video tutorial<\/a>).<\/p>\n<h3 id=\"modul-1-watch-emails-parse-email\">2) Modul 1 \u2014 Watch Emails (parse email)<\/h3>\n<p>Konfigurasi filter: Subject contains &#8220;Order Confirmation&#8221; atau Label &#8220;Orders&#8221;, Sender specific. Set limit per run sesuai operasi Anda. (Referensi Watch Emails di <a href=\"https:\/\/www.youtube.com\/watch?v=-3ENIZyWkeg\">video<\/a>).<\/p>\n<h3 id=\"modul-2-parse-email-regex-email2sheet\">3) Modul 2 \u2014 Parse Email (regex\/email2sheet)<\/h3>\n<p>Jika email terstruktur buruk, gunakan regex; untuk pola relatif konsisten, built-in parser bisa dipakai. Video tutorial menunjukkan penggunaan Text Parser\/Match Pattern (<a href=\"https:\/\/www.youtube.com\/watch?v=-3ENIZyWkeg\">lihat<\/a>).<\/p>\n<p>Contoh regex per field:<\/p>\n<pre><code>order_id: Order #(\\w+)\ncustomer_name: Dear\\s+([A-Za-z\\s]+),\nitem: Your order:\\s+(.+?)(?:,|Total)\nprice: Total:\\s*\\$?([\\d,]+\\.?\\d*)\norder_date: Date:\\s*(\\d{4}-\\d{2}-\\d{2})<\/code><\/pre>\n<p>Contoh gabungan:<\/p>\n<pre><code>Order #(\\w+).*?Dear\\s+([A-Za-z\\s]+).*?Your order:\\s+(.+?),.*?Total:\\s*\\$?([\\d,]+\\.?\\d*).*?Date:\\s*(\\d{4}-\\d{2}-\\d{2})<\/code><\/pre>\n<p>Untuk email dengan attachment berbentuk PDF (mis. invoice), pertimbangkan pipeline OCR sebelum mapping\u2014lihat contoh OCR di panduan Zapier OCR Invoice: <a href=\"https:\/\/inrealitysolutions.com\/id\/zapier-automation-ocr-invoice\/\">Zapier OCR Invoice (InReality Solutions)<\/a>.<\/p>\n<h3 id=\"modul-3-google-sheets-search-rows-dedupe\">4) Modul 3 \u2014 Google Sheets: Search Rows (dedupe)<\/h3>\n<p>Cari berdasarkan unique key (Order ID atau hash composite). Gunakan Search Rows di Google Sheets dan periksa property seperti <code>total_number_of_rows<\/code> untuk menentukan ada\/tidaknya duplikat. Referensi mapping di komunitas Make: <a href=\"https:\/\/community.make.com\/t\/map-email-body-data-into-google-sheets-row\/85149\">Map Email Body Data into Google Sheets Row<\/a>.<\/p>\n<h3 id=\"logika-dedupe-router-if-condition\">5) Logika dedupe (Router \/ If condition)<\/h3>\n<p>If <code>{{4.total_number_of_rows &gt; 0}}<\/code> \u2192 jalur duplikat: skip atau update; else \u2192 Append Row.<\/p>\n<pre><code>if (search.total &gt; 0) {\n  log(\"Duplikat\");\n} else {\n  append_row(data);\n}<\/code><\/pre>\n<h3 id=\"modul-4-google-sheets-append-row\">6) Modul 4 \u2014 Google Sheets: Append Row (append row)<\/h3>\n<p>Mapping field ke kolom (Order ID \u2192 A, Customer \u2192 B, Price \u2192 D). Pastikan sheet berbagi dengan akun OAuth sebagai Editor. Lakukan format untuk kolom date\/number. Praktik mapping form\u2192CRM di <a href=\"https:\/\/inrealitysolutions.com\/id\/google-sheets-automation-form-crm\/\">InReality Solutions \u2014 form to CRM<\/a>.<\/p>\n<h3 id=\"opsional-notifikasi-logging\">7) Opsional: Notifikasi &amp; Logging<\/h3>\n<p>Tambah Slack\/Email notification pada jalur sukses atau simpan log ke sheet terpisah. Contoh implementasi reporting harian dan pengiriman ke Slack\/WhatsApp: <a href=\"https:\/\/inrealitysolutions.com\/id\/apps-script-automation-daily-report\/\">Apps Script Daily Report<\/a>.<\/p>\n<h3 id=\"activate-test\">8) Activate &amp; Test (cara make workflow)<\/h3>\n<p>Run once dengan sample email, cek run history dan output module untuk debugging (lihat <a href=\"https:\/\/www.youtube.com\/watch?v=-3ENIZyWkeg\">video<\/a>).<\/p>\n<h2 id=\"contoh-regex-dan-template-parsing\">Contoh regex &amp; template parsing<\/h2>\n<p>Tujuan: Berikan pola siap pakai dan alat uji.<\/p>\n<p>Uji regex di tools seperti <a href=\"https:\/\/regex101.com\">regex101<\/a>. Contoh input email \u2192 output variabel yang siap di-map ke Sheets.<\/p>\n<h2 id=\"strategi-dedupe-pendekatan-dan-rekomendasi\">Strategi dedupe: pendekatan &amp; rekomendasi<\/h2>\n<p>Tujuan: Beri opsi agar data bersih.<\/p>\n<ul>\n<li>Strategi 1: Search Rows by unique key (Order ID). (lihat thread <a href=\"https:\/\/community.make.com\/t\/map-email-body-data-into-google-sheets-row\/85149\">community.make.com<\/a>).<\/li>\n<li>Strategi 2: Hash composite key (customer_name + date + price) dan cari kolom hash.<\/li>\n<li>Strategi 3: Time window search (hindari double processing saat retry).<\/li>\n<li>Normalisasi: <code>trim()<\/code>, lowercase sebelum search. Untuk tahap enrichment setelah append lihat <a href=\"https:\/\/inrealitysolutions.com\/id\/google-sheets-automation-lead-enrichment\/\">Google Sheets Automation Lead Enrichment<\/a>.<\/li>\n<\/ul>\n<h2 id=\"error-handling-testing-dan-monitoring\">Error handling, testing &amp; monitoring<\/h2>\n<p>Tujuan: Langkah konkret untuk reliability.<\/p>\n<ul>\n<li>Aktifkan logging, set retries di scenario settings, gunakan run history untuk debug.<\/li>\n<li>Periksa koneksi OAuth bila Append Row gagal: <a href=\"https:\/\/support.google.com\/docs\/thread\/244962799\/is-it-possible-to-automatically-import-data-from-gmail-into-google-sheets?hl=en\">Google Support thread<\/a>.<\/li>\n<\/ul>\n<h2 id=\"checklist-implementasi-cepat-one-page\">Checklist implementasi cepat (one\u2011page)<\/h2>\n<p>Tujuan: Ringkasan actionable.<\/p>\n<ul>\n<li><label><input disabled=\"disabled\" type=\"checkbox\" \/> Siapkan sheet &amp; header<\/label><\/li>\n<li><label><input disabled=\"disabled\" type=\"checkbox\" \/> Setup Watch Emails + filter<\/label><\/li>\n<li><label><input disabled=\"disabled\" type=\"checkbox\" \/> Tambah Regex parser (copy patterns)<\/label><\/li>\n<li><label><input disabled=\"disabled\" type=\"checkbox\" \/> Search Rows untuk dedupe<\/label><\/li>\n<li><label><input disabled=\"disabled\" type=\"checkbox\" \/> If logic + Append Row<\/label><\/li>\n<li><label><input disabled=\"disabled\" type=\"checkbox\" \/> Test run \u2192 Aktifkan<\/label><\/li>\n<\/ul>\n<h2 id=\"faq-singkat-5\">FAQ singkat<\/h2>\n<div class=\"faq\">\n<h3 id=\"faq-1-regex-vs-built-in-parser\">1. Regex vs built-in parser?<\/h3>\n<p>Regex untuk email yang tidak terstruktur atau sangat bervariasi; built-in parser lebih cepat dan lebih mudah untuk format yang konsisten. Referensi penggunaan di <a href=\"https:\/\/www.youtube.com\/watch?v=-3ENIZyWkeg\">video tutorial<\/a>.<\/p>\n<h3 id=\"faq-2-bisa-pakai-imap-non-gmail\">2. Bisa pakai IMAP non\u2011Gmail?<\/h3>\n<p>Ya \u2014 ganti modul trigger ke IMAP di Make dan konfigurasi koneksi sesuai server Anda.<\/p>\n<h3 id=\"faq-3-attachment-bisa-diproses\">3. Attachment bisa diproses?<\/h3>\n<p>Ya \u2014 download attachment (PDF) lalu jalankan OCR pipeline sebelum parsing jika diperlukan. Lihat contoh OCR di <a href=\"https:\/\/inrealitysolutions.com\/id\/zapier-automation-ocr-invoice\/\">Zapier OCR Invoice<\/a>.<\/p>\n<h3 id=\"faq-4-estimasi-operasi-make-per-run\">4. Bagaimana estimasi operasi Make per run?<\/h3>\n<p>Tergantung jumlah modul dan data yang diproses; pantau run history untuk melihat hitungan operasi dan biaya pada tier akun Anda. Video tutorial memberikan gambaran praktik terbaik: <a href=\"https:\/\/www.youtube.com\/watch?v=-3ENIZyWkeg\">lihat<\/a>.<\/p>\n<h3 id=\"faq-5-keamanan-data-pii\">5. Keamanan data PII?<\/h3>\n<p>Batasi akses sheet, gunakan akun service\/ OAuth dengan scope minimum, enkripsi bila perlu, dan konsultasikan tim legal untuk kepatuhan data.<\/p>\n<\/div>\n<h2 id=\"mengapa-inreality-solutions-cocok-untuk-proyek-otomasi-anda\">Mengapa InReality Solutions cocok untuk proyek otomasi Anda<\/h2>\n<p>InReality Solutions menawarkan keahlian integrasi Make automation dengan pendekatan Agentic AI dan Otomasi Proses Bisnis (BPA), kemampuan integrasi ke CRM\/ERP, kontrol keamanan data, dan dukungan end\u2011to\u2011end dari audit proses hingga deployment. Untuk portofolio dan layanan otomasi AI lihat <a href=\"\/id\/layanan\/otomasi-ai\/\">\/layanan\/otomasi-ai<\/a> dan <a href=\"\/id\/portofolio\/\">\/portofolio<\/a>.<\/p>\n<h2 id=\"konsultasi-demo-ai-automations-agentic-ai-cta\">Konsultasi &amp; Demo AI Automations \/ Agentic AI (CTA)<\/h2>\n<p>Ingin implementasi cepat atau audit workflow Anda? Hubungi tim InReality Solutions untuk sesi demo dan estimasi implementasi kustom. Kirim request demo atau audit via email tim: <a href=\"mailto:hello@inreality.co\">hello@inreality.co<\/a> (atau form di halaman layanan).<\/p>\n<h2 id=\"kesimpulan-ringkas-manfaat\">Kesimpulan \u2014 ringkas manfaat<\/h2>\n<p>Make automation untuk email parsing ke Google Sheets menyederhanakan alur data, mengurangi input manual, dan mempercepat aliran informasi ke tim operasional. Mulai dengan checklist di atas, uji regex, lalu scale ke notifikasi dan monitoring.<\/p>\n<p><strong>Ringkasan CTA:<\/strong> Siap uji workflow Anda? Minta demo &amp; audit gratis dari InReality Solutions untuk desain skenario Make yang sesuai kebutuhan bisnis Anda.<\/p>","protected":false},"excerpt":{"rendered":"<p>Make Automation Email Parsing Google Sheets \u2014 Make Workflow Step by Step Otomasi parsing email ke Google Sheets untuk mengurangi input manual dan mempercepat alur data. Gunakan modul Watch Emails \u2192 Parse \u2192 Search Rows (dedupe) \u2192 Append Row di Make (Integromat). Regex siap-pakai dan strategi dedupe (unique key \/ hash \/ time-window) membantu menjaga [&hellip;]<\/p>","protected":false},"author":16,"featured_media":8113,"comment_status":"closed","ping_status":"open","sticky":false,"template":"elementor_canvas","format":"standard","meta":{"_uag_custom_page_level_css":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"disabled","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"set","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[170],"tags":[],"class_list":["post-8073","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-ai-automations"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v22.5 (Yoast SEO v23.3) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Make Automation Email Parsing Google Sheets \u2014 Step by Step<\/title>\n<meta name=\"description\" content=\"Tutorial make automation email parsing Google Sheets: workflow step by step, regex siap pakai, dedupe data, dan monitoring di Make.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/inrealitysolutions.com\/id\/make-automation-email-parsing-google-sheets\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Make Automation Email Parsing Google Sheets \u2014 Make Workflow Step by Step\" \/>\n<meta property=\"og:description\" content=\"Tutorial make automation email parsing Google Sheets: workflow step by step, regex siap pakai, dedupe data, dan monitoring di Make.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/inrealitysolutions.com\/id\/make-automation-email-parsing-google-sheets\/\" \/>\n<meta property=\"og:site_name\" content=\"InReality Solutions \u2014 AR\/VR, Virtual Tours &amp; AI Automations Indonesia\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/InRealitySolutions\/\" \/>\n<meta property=\"article:published_time\" content=\"2026-01-26T01:18:41+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-01-28T02:59:25+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2026\/01\/Prod-25.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1080\" \/>\n\t<meta property=\"og:image:height\" content=\"1080\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Maya Ananta\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Ditulis oleh\" \/>\n\t<meta name=\"twitter:data1\" content=\"Maya Ananta\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/inrealitysolutions.com\/make-automation-email-parsing-google-sheets\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/inrealitysolutions.com\/make-automation-email-parsing-google-sheets\/\"},\"author\":{\"name\":\"Maya Ananta\",\"@id\":\"https:\/\/inrealitysolutions.com\/id\/#\/schema\/person\/8bf31cc88af0e2066d9d0f57dd52a80a\"},\"headline\":\"Make Automation Email Parsing Google Sheets \u2014 Make Workflow Step by Step\",\"datePublished\":\"2026-01-26T01:18:41+00:00\",\"dateModified\":\"2026-01-28T02:59:25+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/inrealitysolutions.com\/make-automation-email-parsing-google-sheets\/\"},\"wordCount\":1108,\"publisher\":{\"@id\":\"https:\/\/inrealitysolutions.com\/id\/#organization\"},\"image\":{\"@id\":\"https:\/\/inrealitysolutions.com\/make-automation-email-parsing-google-sheets\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2026\/01\/Prod-25.jpg\",\"articleSection\":[\"AI Automations\"],\"inLanguage\":\"id\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/inrealitysolutions.com\/make-automation-email-parsing-google-sheets\/\",\"url\":\"https:\/\/inrealitysolutions.com\/make-automation-email-parsing-google-sheets\/\",\"name\":\"Make Automation Email Parsing Google Sheets \u2014 Step by Step\",\"isPartOf\":{\"@id\":\"https:\/\/inrealitysolutions.com\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/inrealitysolutions.com\/make-automation-email-parsing-google-sheets\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/inrealitysolutions.com\/make-automation-email-parsing-google-sheets\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2026\/01\/Prod-25.jpg\",\"datePublished\":\"2026-01-26T01:18:41+00:00\",\"dateModified\":\"2026-01-28T02:59:25+00:00\",\"description\":\"Tutorial make automation email parsing Google Sheets: workflow step by step, regex siap pakai, dedupe data, dan monitoring di Make.\",\"breadcrumb\":{\"@id\":\"https:\/\/inrealitysolutions.com\/make-automation-email-parsing-google-sheets\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/inrealitysolutions.com\/make-automation-email-parsing-google-sheets\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/inrealitysolutions.com\/make-automation-email-parsing-google-sheets\/#primaryimage\",\"url\":\"https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2026\/01\/Prod-25.jpg\",\"contentUrl\":\"https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2026\/01\/Prod-25.jpg\",\"width\":1080,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/inrealitysolutions.com\/make-automation-email-parsing-google-sheets\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/inrealitysolutions.com\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Make Automation Email Parsing Google Sheets \u2014 Make Workflow Step by Step\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/inrealitysolutions.com\/id\/#website\",\"url\":\"https:\/\/inrealitysolutions.com\/id\/\",\"name\":\"InReality Solutions \u2014 AR\/VR, Virtual Tours &amp; AI Automations Indonesia\",\"description\":\"Transforming Businesses Through AR\/VR, Virtual Tours &amp; AI Innovation\",\"publisher\":{\"@id\":\"https:\/\/inrealitysolutions.com\/id\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/inrealitysolutions.com\/id\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"id\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/inrealitysolutions.com\/id\/#organization\",\"name\":\"InReality Solutions \u2014 AR\/VR, Virtual Tours &amp; AI Automations Indonesia\",\"url\":\"https:\/\/inrealitysolutions.com\/id\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/inrealitysolutions.com\/id\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2021\/09\/Inreality-Solutions-logo.png\",\"contentUrl\":\"https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2021\/09\/Inreality-Solutions-logo.png\",\"width\":1006,\"height\":319,\"caption\":\"InReality Solutions \u2014 AR\/VR, Virtual Tours &amp; AI Automations Indonesia\"},\"image\":{\"@id\":\"https:\/\/inrealitysolutions.com\/id\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/InRealitySolutions\/\",\"https:\/\/www.linkedin.com\/company\/inreality-solutions\/\",\"https:\/\/www.instagram.com\/inreality_solutions\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/inrealitysolutions.com\/id\/#\/schema\/person\/8bf31cc88af0e2066d9d0f57dd52a80a\",\"name\":\"Maya Ananta\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/inrealitysolutions.com\/id\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/48f96fb33f8c03241bdaccaf1a39bbc773261c3363a2dc04d2d46adccd9b6c70?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/48f96fb33f8c03241bdaccaf1a39bbc773261c3363a2dc04d2d46adccd9b6c70?s=96&d=mm&r=g\",\"caption\":\"Maya Ananta\"},\"url\":\"https:\/\/inrealitysolutions.com\/id\/author\/mayaananta\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Make Automation Email Parsing Google Sheets \u2014 Step by Step","description":"Tutorial make automation email parsing Google Sheets: workflow step by step, regex siap pakai, dedupe data, dan monitoring di Make.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/inrealitysolutions.com\/id\/make-automation-email-parsing-google-sheets\/","og_locale":"id_ID","og_type":"article","og_title":"Make Automation Email Parsing Google Sheets \u2014 Make Workflow Step by Step","og_description":"Tutorial make automation email parsing Google Sheets: workflow step by step, regex siap pakai, dedupe data, dan monitoring di Make.","og_url":"https:\/\/inrealitysolutions.com\/id\/make-automation-email-parsing-google-sheets\/","og_site_name":"InReality Solutions \u2014 AR\/VR, Virtual Tours &amp; AI Automations Indonesia","article_publisher":"https:\/\/www.facebook.com\/InRealitySolutions\/","article_published_time":"2026-01-26T01:18:41+00:00","article_modified_time":"2026-01-28T02:59:25+00:00","og_image":[{"width":1080,"height":1080,"url":"https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2026\/01\/Prod-25.jpg","type":"image\/jpeg"}],"author":"Maya Ananta","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Maya Ananta","Estimasi waktu membaca":"6 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/inrealitysolutions.com\/make-automation-email-parsing-google-sheets\/#article","isPartOf":{"@id":"https:\/\/inrealitysolutions.com\/make-automation-email-parsing-google-sheets\/"},"author":{"name":"Maya Ananta","@id":"https:\/\/inrealitysolutions.com\/id\/#\/schema\/person\/8bf31cc88af0e2066d9d0f57dd52a80a"},"headline":"Make Automation Email Parsing Google Sheets \u2014 Make Workflow Step by Step","datePublished":"2026-01-26T01:18:41+00:00","dateModified":"2026-01-28T02:59:25+00:00","mainEntityOfPage":{"@id":"https:\/\/inrealitysolutions.com\/make-automation-email-parsing-google-sheets\/"},"wordCount":1108,"publisher":{"@id":"https:\/\/inrealitysolutions.com\/id\/#organization"},"image":{"@id":"https:\/\/inrealitysolutions.com\/make-automation-email-parsing-google-sheets\/#primaryimage"},"thumbnailUrl":"https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2026\/01\/Prod-25.jpg","articleSection":["AI Automations"],"inLanguage":"id"},{"@type":"WebPage","@id":"https:\/\/inrealitysolutions.com\/make-automation-email-parsing-google-sheets\/","url":"https:\/\/inrealitysolutions.com\/make-automation-email-parsing-google-sheets\/","name":"Make Automation Email Parsing Google Sheets \u2014 Step by Step","isPartOf":{"@id":"https:\/\/inrealitysolutions.com\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/inrealitysolutions.com\/make-automation-email-parsing-google-sheets\/#primaryimage"},"image":{"@id":"https:\/\/inrealitysolutions.com\/make-automation-email-parsing-google-sheets\/#primaryimage"},"thumbnailUrl":"https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2026\/01\/Prod-25.jpg","datePublished":"2026-01-26T01:18:41+00:00","dateModified":"2026-01-28T02:59:25+00:00","description":"Tutorial make automation email parsing Google Sheets: workflow step by step, regex siap pakai, dedupe data, dan monitoring di Make.","breadcrumb":{"@id":"https:\/\/inrealitysolutions.com\/make-automation-email-parsing-google-sheets\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/inrealitysolutions.com\/make-automation-email-parsing-google-sheets\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/inrealitysolutions.com\/make-automation-email-parsing-google-sheets\/#primaryimage","url":"https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2026\/01\/Prod-25.jpg","contentUrl":"https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2026\/01\/Prod-25.jpg","width":1080,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/inrealitysolutions.com\/make-automation-email-parsing-google-sheets\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/inrealitysolutions.com\/id\/"},{"@type":"ListItem","position":2,"name":"Make Automation Email Parsing Google Sheets \u2014 Make Workflow Step by Step"}]},{"@type":"WebSite","@id":"https:\/\/inrealitysolutions.com\/id\/#website","url":"https:\/\/inrealitysolutions.com\/id\/","name":"InReality Solutions \u2014 AR\/VR, Virtual Tours &amp; AI Automations Indonesia","description":"Transforming Businesses Through AR\/VR, Virtual Tours &amp; AI Innovation","publisher":{"@id":"https:\/\/inrealitysolutions.com\/id\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/inrealitysolutions.com\/id\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"id"},{"@type":"Organization","@id":"https:\/\/inrealitysolutions.com\/id\/#organization","name":"InReality Solutions \u2014 AR\/VR, Virtual Tours &amp; AI Automations Indonesia","url":"https:\/\/inrealitysolutions.com\/id\/","logo":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/inrealitysolutions.com\/id\/#\/schema\/logo\/image\/","url":"https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2021\/09\/Inreality-Solutions-logo.png","contentUrl":"https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2021\/09\/Inreality-Solutions-logo.png","width":1006,"height":319,"caption":"InReality Solutions \u2014 AR\/VR, Virtual Tours &amp; AI Automations Indonesia"},"image":{"@id":"https:\/\/inrealitysolutions.com\/id\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/InRealitySolutions\/","https:\/\/www.linkedin.com\/company\/inreality-solutions\/","https:\/\/www.instagram.com\/inreality_solutions\/"]},{"@type":"Person","@id":"https:\/\/inrealitysolutions.com\/id\/#\/schema\/person\/8bf31cc88af0e2066d9d0f57dd52a80a","name":"Maya Ananta","image":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/inrealitysolutions.com\/id\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/48f96fb33f8c03241bdaccaf1a39bbc773261c3363a2dc04d2d46adccd9b6c70?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/48f96fb33f8c03241bdaccaf1a39bbc773261c3363a2dc04d2d46adccd9b6c70?s=96&d=mm&r=g","caption":"Maya Ananta"},"url":"https:\/\/inrealitysolutions.com\/id\/author\/mayaananta\/"}]}},"uagb_featured_image_src":{"full":["https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2026\/01\/Prod-25.jpg",1080,1080,false],"thumbnail":["https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2026\/01\/Prod-25-150x150.jpg",150,150,true],"medium":["https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2026\/01\/Prod-25-300x300.jpg",300,300,true],"medium_large":["https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2026\/01\/Prod-25-768x768.jpg",768,768,true],"large":["https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2026\/01\/Prod-25-1024x1024.jpg",1024,1024,true],"1536x1536":["https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2026\/01\/Prod-25.jpg",1080,1080,false],"2048x2048":["https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2026\/01\/Prod-25.jpg",1080,1080,false],"trp-custom-language-flag":["https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2026\/01\/Prod-25-12x12.jpg",12,12,true]},"uagb_author_info":{"display_name":"Maya Ananta","author_link":"https:\/\/inrealitysolutions.com\/id\/author\/mayaananta\/"},"uagb_comment_info":0,"uagb_excerpt":"Make Automation Email Parsing Google Sheets \u2014 Make Workflow Step by Step Otomasi parsing email ke Google Sheets untuk mengurangi input manual dan mempercepat alur data. Gunakan modul Watch Emails \u2192 Parse \u2192 Search Rows (dedupe) \u2192 Append Row di Make (Integromat). Regex siap-pakai dan strategi dedupe (unique key \/ hash \/ time-window) membantu menjaga&hellip;","_links":{"self":[{"href":"https:\/\/inrealitysolutions.com\/id\/wp-json\/wp\/v2\/posts\/8073","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/inrealitysolutions.com\/id\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/inrealitysolutions.com\/id\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/inrealitysolutions.com\/id\/wp-json\/wp\/v2\/users\/16"}],"replies":[{"embeddable":true,"href":"https:\/\/inrealitysolutions.com\/id\/wp-json\/wp\/v2\/comments?post=8073"}],"version-history":[{"count":2,"href":"https:\/\/inrealitysolutions.com\/id\/wp-json\/wp\/v2\/posts\/8073\/revisions"}],"predecessor-version":[{"id":8114,"href":"https:\/\/inrealitysolutions.com\/id\/wp-json\/wp\/v2\/posts\/8073\/revisions\/8114"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/inrealitysolutions.com\/id\/wp-json\/wp\/v2\/media\/8113"}],"wp:attachment":[{"href":"https:\/\/inrealitysolutions.com\/id\/wp-json\/wp\/v2\/media?parent=8073"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/inrealitysolutions.com\/id\/wp-json\/wp\/v2\/categories?post=8073"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/inrealitysolutions.com\/id\/wp-json\/wp\/v2\/tags?post=8073"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}