{"id":7326,"date":"2025-12-28T08:17:42","date_gmt":"2025-12-28T01:17:42","guid":{"rendered":"https:\/\/inrealitysolutions.com\/mailchimp-automation-email-parsing-google-sheets\/"},"modified":"2026-03-03T16:43:15","modified_gmt":"2026-03-03T09:43:15","slug":"mailchimp-automation-email-parsing-google-sheets","status":"publish","type":"post","link":"https:\/\/inrealitysolutions.com\/id\/mailchimp-automation-email-parsing-google-sheets\/","title":{"rendered":"Mailchimp Automation Email Parsing Google Sheets \u2014 Panduan langkah demi langkah"},"content":{"rendered":"<h1 id=\"mailchimp-automation-email-parsing-google-sheets-panduan-langkah-demi-langkah\"><img fetchpriority=\"high\" decoding=\"async\" class=\"aligncenter size-full wp-image-8550\" src=\"https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2025\/12\/Prod-1.jpg\" alt=\"\" width=\"1080\" height=\"1080\" srcset=\"https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2025\/12\/Prod-1.jpg 1080w, https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2025\/12\/Prod-1-300x300.jpg 300w, https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2025\/12\/Prod-1-1024x1024.jpg 1024w, https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2025\/12\/Prod-1-150x150.jpg 150w, https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2025\/12\/Prod-1-768x768.jpg 768w, https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2025\/12\/Prod-1-12x12.jpg 12w\" sizes=\"(max-width: 1080px) 100vw, 1080px\" \/>Mailchimp Automation Email Parsing Google Sheets \u2014 Panduan langkah demi langkah<\/h1>\n<ul class=\"key-takeaways\">\n<li>Gunakan webhook\/API (direkomendasikan) untuk payload JSON real\u2011time dan parsing minim.<\/li>\n<li>Parse email (regex\/email2sheet) adalah fallback bila API\/webhook tidak tersedia, tapi lebih rentan terhadap perubahan template.<\/li>\n<li>Implementasi meliputi struktur Sheet, endpoint Apps Script, dedupe, dan monitoring\/quota handling.<\/li>\n<\/ul>\n<nav class=\"toc\" aria-label=\"Daftar isi\"><strong>Daftar Isi<\/strong><\/p>\n<ul>\n<li><a href=\"#pembuka\">Pembuka<\/a><\/li>\n<li><a href=\"#contoh-skenario-nyata-untuk-bisnis-indonesia\">Contoh skenario nyata untuk bisnis Indonesia<\/a><\/li>\n<li><a href=\"#prasyarat-dan-alat-yang-diperlukan\">Prasyarat &amp; alat yang diperlukan<\/a><\/li>\n<li><a href=\"#strategi-pemilihan-metode-webhookapi-vs-parse-email\">Strategi pemilihan metode: Webhook\/API vs Parse Email<\/a><\/li>\n<li><a href=\"#implementasi-langkah-demi-langkah---metode-a-mailchimp-webhook-&gt;-google-sheets-direkomendasikan\">Implementasi langkah demi langkah \u2014 Metode A (Webhook)<\/a><\/li>\n<li><a href=\"#implementasi-langkah-demi-langkah---metode-b-parse-email-&gt;-regex-email2sheet-&gt;-google-sheets\">Implementasi langkah demi langkah \u2014 Metode B (Parse Email)<\/a><\/li>\n<li><a href=\"#detail-teknis-penting\">Detail teknis penting<\/a><\/li>\n<li><a href=\"#cara-mailchimp-workflow---langkah-non-teknis-singkat\">Cara Mailchimp workflow \u2014 langkah non\u2011teknis<\/a><\/li>\n<li><a href=\"#testing-qa-dan-debugging\">Testing, QA &amp; debugging<\/a><\/li>\n<li><a href=\"#monitoring-maintenance-dan-operasional\">Monitoring, maintenance &amp; operasional<\/a><\/li>\n<li><a href=\"#keamanan-dan-kepatuhan-data\">Keamanan &amp; kepatuhan data<\/a><\/li>\n<li><a href=\"#faq-umum\">FAQ<\/a><\/li>\n<li><a href=\"#ringkasan-manfaat\">Ringkasan manfaat<\/a><\/li>\n<li><a href=\"#cta\">CTA<\/a><\/li>\n<\/ul>\n<\/nav>\n<h2 id=\"pembuka\">Pembuka<\/h2>\n<p>mailchimp automation email parsing google sheets adalah solusi praktis untuk menangkap data pendaftaran, lead, dan notifikasi order secara otomatis dari Mailchimp ke Google Sheets. Otomasi ini mempercepat follow\u2011up, mengurangi input manual, dan meningkatkan traceability untuk tim marketing &amp; operasional. Panduan ini menjelaskan dua pendekatan utama\u2014(A) webhook\/API Mailchimp \u2192 Google Apps Script (direkomendasikan) dan (B) parse email via regex\/email2sheet\u2014beserta contoh skenario, snippet, checklist, dan resources untuk implementasi. Sumber referensi teknis utama: <a href=\"https:\/\/www.coupler.io\/google-sheets-integrations\/mailchimp-to-google-sheets\">Coupler<\/a> (integrasi Mailchimp \u2192 Sheets) dan <a href=\"https:\/\/www.benlcollins.com\/apps-script\/mailchimp-integration\/\">Ben Collins<\/a> (Apps Script + Mailchimp).<\/p>\n<h2 id=\"contoh-skenario-nyata-untuk-bisnis-indonesia\">Contoh skenario nyata untuk bisnis Indonesia<\/h2>\n<ul>\n<li><strong>Skenario 1<\/strong> \u2014 Pendaftaran event via Mailchimp \u2192 Google Sheets untuk follow\u2011up tim sales. Pain point: volume pendaftaran saat campaign opening dan kebutuhan follow\u2011up cepat untuk konversi. <a href=\"https:\/\/inrealitysolutions.com\/id\/lead-scoring-automasi-marketplace\/\">Lebih lanjut<\/a>.<\/li>\n<li><strong>Skenario 2<\/strong> \u2014 Notifikasi order dikirim ke alamat khusus \u2192 parse email \u2192 simpan detail produk &amp; qty. Use case e\u2011commerce: email notifikasi berisi Order ID, produk, qty \u2014 ekstrak via regex lalu append row ke Sheets.<\/li>\n<li><strong>Skenario 3<\/strong> \u2014 Lead e\u2011commerce (permintaan demo AR\/try\u2011on) \u2192 dedupe &amp; append row ke CRM Sheets. Hasil: hindari follow\u2011up ganda dan sinkron ke tim sales\/CRM. <a href=\"https:\/\/inrealitysolutions.com\/id\/zapier-automation-lead-enrichment\/\">Contoh integrasi<\/a>.<\/li>\n<\/ul>\n<h2 id=\"prasyarat-dan-alat-yang-diperlukan\">Prasyarat &amp; alat yang diperlukan<\/h2>\n<ul>\n<li>Akun Mailchimp dengan akses automations &amp; webhooks \u2014 panduan integrasi Apps Script: <a href=\"https:\/\/www.benlcollins.com\/apps-script\/mailchimp-integration\/\">Ben Collins<\/a>.<\/li>\n<li>Google account + Google Sheets + Google Apps Script \u2014 referensi: <a href=\"https:\/\/inrealitysolutions.com\/id\/google-sheets-automation-form-crm\/\">InReality Solutions<\/a>.<\/li>\n<li>Opsi parsing: <a href=\"https:\/\/www.coupler.io\/google-sheets-integrations\/mailchimp-to-google-sheets\">email2sheet\/Coupler<\/a>, <a href=\"https:\/\/zapier.com\/blog\/integrate-google-sheets-with-mailchimp\/\">Zapier<\/a>, Parsio, atau custom Apps Script.<\/li>\n<li>Dasar regex untuk ekstraksi field (contoh pola email disertakan di bagian teknis).<\/li>\n<\/ul>\n<h2 id=\"strategi-pemilihan-metode-webhookapi-vs-parse-email\">Strategi pemilihan metode: Webhook\/API vs Parse Email<\/h2>\n<p><strong>Webhook\/API (Metode A)<\/strong> \u2014 rekomendasi bila Mailchimp dapat mengirim payload JSON. Keuntungan: payload bersih, real\u2011time, minim parsing. Referensi implementasi: <a href=\"https:\/\/www.benlcollins.com\/apps-script\/mailchimp-integration\/\">Ben Collins<\/a>.<\/p>\n<p><strong>Parse Email (Metode B)<\/strong> \u2014 gunakan jika hanya tersedia notifikasi email. Kelebihan: bekerja tanpa akses API; kelemahan: rentan saat template berubah. Tools dan overview: <a href=\"https:\/\/www.coupler.io\/google-sheets-integrations\/mailchimp-to-google-sheets\">Coupler<\/a>, <a href=\"https:\/\/zapier.com\/blog\/integrate-google-sheets-with-mailchimp\/\">Zapier<\/a>.<\/p>\n<h2 id=\"implementasi-langkah-demi-langkah---metode-a-mailchimp-webhook-&gt;-google-sheets-direkomendasikan\">Implementasi langkah demi langkah \u2014 Metode A: Mailchimp webhook \u2192 Google Sheets (Direkomendasikan)<\/h2>\n<h3 id=\"a-langkah-1-siapkan-google-sheet-struktur-kolom\">Langkah 1 \u2014 Siapkan Google Sheet &amp; struktur kolom<\/h3>\n<p>Buat sheet dengan kolom: Timestamp, Email, Nama, Tag, Source, Custom Field. (Gunakan kolom kunci untuk dedupe, mis. Email).<\/p>\n<h3 id=\"a-langkah-2-buat-google-apps-script-web-app-untuk-menerima-post-json\">Langkah 2 \u2014 Buat Google Apps Script Web App untuk menerima POST JSON<\/h3>\n<p>Contoh snippet ringkas:<\/p>\n<pre><code>function doPost(e){\n  var sheet = SpreadsheetApp.getActive().getSheetByName('Sheet1');\n  var payload = JSON.parse(e.postData.contents); \/\/ lihat contoh mapping Ben Collins https:\/\/www.benlcollins.com\/apps-script\/mailchimp-integration\/\n  var email = (payload.mershfields &amp;&amp; payload.mershfields.EMAIL) || '';\n  var nama = (payload.mershfields &amp;&amp; payload.mershfields.FNAME) || '';\n  \/\/ dedupe: cek existing (case\u2011insensitive)\n  var data = sheet.getRange(2,2,Math.max(0,sheet.getLastRow()-1),1).getValues().flat();\n  if(data.map(x=&gt;String(x).trim().toLowerCase()).indexOf(email.trim().toLowerCase()) !== -1) return ContentService.createTextOutput('duplicate');\n  sheet.appendRow([new Date(), email, nama, payload.tag || '', 'Mailchimp', JSON.stringify(payload.custom || {})]);\n  return ContentService.createTextOutput('ok');\n}<\/code><\/pre>\n<p>Deploy sebagai Web App (Execute as: Me; Who has access: Anyone). Rujuk: <a href=\"https:\/\/www.benlcollins.com\/apps-script\/mailchimp-integration\/\">Ben Collins<\/a>.<\/p>\n<h3 id=\"a-langkah-3-parsing-payload-validasi-dedupe\">Langkah 3 \u2014 Parsing payload, validasi &amp; dedupe<\/h3>\n<p>Gunakan compare case\u2011insensitive, trim whitespace, atau hash email untuk key. Jika duplikat: update row; jika unik: append row.<\/p>\n<h3 id=\"a-langkah-4-konfigurasi-mailchimp-workflow-ui\">Langkah 4 \u2014 Konfigurasi Mailchimp workflow (UI)<\/h3>\n<p>Buat Audience &amp; signup form \u2192 Automations &gt; pilih trigger (Signup\/Campaign activity) \u2192 Advanced &gt; Webhook \u2192 paste URL Apps Script. (Panduan: <a href=\"https:\/\/www.benlcollins.com\/apps-script\/mailchimp-integration\/\">Ben Collins<\/a>).<\/p>\n<h3 id=\"a-langkah-5-uji-end-to-end-fallback\">Langkah 5 \u2014 Uji end\u2011to\u2011end &amp; fallback<\/h3>\n<p>Simulasikan dengan test subscriber atau <a href=\"https:\/\/www.postman.com\/\">Postman<\/a> untuk POST JSON; periksa baris yang ter\u2011append.<\/p>\n<h3 id=\"contoh-payload-sample-dan-mapping\">Contoh payload sample (sederhana) dan mapping<\/h3>\n<pre><code>{\n  \"mershfields\":{\"EMAIL\":\"user@example.co.id\",\"FNAME\":\"Andi\"},\n  \"tag\":\"event-lead\",\n  \"custom\":{}\n}<\/code><\/pre>\n<p>Mapping \u2192 Sheet row: [Timestamp, user@example.co.id, Andi, event-lead, Mailchimp, {}]. Referensi payload: <a href=\"https:\/\/www.benlcollins.com\/apps-script\/mailchimp-integration\/\">Ben Collins<\/a>.<\/p>\n<h2 id=\"implementasi-langkah-demi-langkah---metode-b-parse-email-&gt;-regex-email2sheet-&gt;-google-sheets\">Implementasi langkah demi langkah \u2014 Metode B: Parse email \u2192 regex\/email2sheet \u2192 Google Sheets<\/h2>\n<h3 id=\"b-langkah-1-siapkan-alamat-penerima-khusus\">Langkah 1 \u2014 Siapkan alamat penerima khusus<\/h3>\n<p>Gunakan alamat khusus (mis. leads@yourcompany.co.id) untuk notifikasi Mailchimp.<\/p>\n<h3 id=\"b-langkah-2-pilih-tool\">Langkah 2 \u2014 Pilih tool<\/h3>\n<p>Pilih salah satu: email2sheet, Email Parser by Zapier, Parsio, atau Gmail+Apps Script. Overview tools: <a href=\"https:\/\/www.coupler.io\/google-sheets-integrations\/mailchimp-to-google-sheets\">Coupler<\/a> | <a href=\"https:\/\/zapier.com\/blog\/integrate-google-sheets-with-mailchimp\/\">Zapier<\/a>.<\/p>\n<h3 id=\"b-langkah-3-contoh-regex-dasar\">Langkah 3 \u2014 Contoh regex dasar<\/h3>\n<ul>\n<li>Email: <code>([a-zA-Z0-9._%+-]+@[a-zA-Z0-9.-]+\\.[a-zA-Z]{2,})<\/code><\/li>\n<li>Order ID: <code>Order #(\\d+)<\/code><\/li>\n<li>Phone: <code>\\+?[\\d\\s-]{8,}<\/code><\/li>\n<\/ul>\n<h3 id=\"b-langkah-4-map-capture-groups-ke-kolom\">Langkah 4 \u2014 Map capture groups ke kolom Sheets<\/h3>\n<p>Map capture groups ke kolom Sheets; atur append row atau update jika duplikat.<\/p>\n<h3 id=\"b-langkah-5-maintenance\">Langkah 5 \u2014 Maintenance<\/h3>\n<p>Monitor perubahan template dan update regex secara berkala.<\/p>\n<h2 id=\"detail-teknis-penting\">Detail teknis penting<\/h2>\n<ul>\n<li>Regex samples dan testing: gunakan <a href=\"https:\/\/regex101.com\/\">regex101.com<\/a> untuk uji.<\/li>\n<li>Dedupe logic: hash email atau compare lowercased trimmed string; update existing row bila match.<\/li>\n<li>Quota &amp; limit Apps Script\/Gmail: periksa dokumentasi resmi bila memerlukan angka.<\/li>\n<\/ul>\n<h2 id=\"cara-mailchimp-workflow---langkah-non-teknis-singkat\">Cara mailchimp workflow \u2014 langkah non\u2011teknis (singkat)<\/h2>\n<ol>\n<li>Audience &gt; Signup forms<\/li>\n<li>Automations &gt; Classic automation<\/li>\n<li>Pilih trigger<\/li>\n<li>Add webhook &gt; paste URL Apps Script<\/li>\n<\/ol>\n<p>Rujuk panduan implementasi: <a href=\"https:\/\/www.benlcollins.com\/apps-script\/mailchimp-integration\/\">Ben Collins<\/a>.<\/p>\n<h2 id=\"testing-qa-dan-debugging\">Testing, QA &amp; debugging<\/h2>\n<ul>\n<li>Simulasi payload via Postman; periksa shape JSON.<\/li>\n<li>Unit test regex; cek edge cases.<\/li>\n<li>Dedupe test: kirim duplikat.<\/li>\n<li>Logging: gunakan <code>Logger<\/code> di Apps Script atau kirim notifikasi ke Slack\/email. Referensi testing: <a href=\"https:\/\/www.benlcollins.com\/apps-script\/mailchimp-integration\/\">Ben Collins<\/a> | <a href=\"https:\/\/zapier.com\/blog\/integrate-google-sheets-with-mailchimp\/\">Zapier<\/a>.<\/li>\n<\/ul>\n<h2 id=\"monitoring-maintenance-dan-operasional\">Monitoring, maintenance &amp; operasional<\/h2>\n<p>Notifikasi error, backup sheet, jadwalkan review regex bulanan bila templates berubah. Untuk integrasi overview: <a href=\"https:\/\/www.coupler.io\/google-sheets-integrations\/mailchimp-to-google-sheets\">Coupler<\/a>.<\/p>\n<h2 id=\"keamanan-dan-kepatuhan-data\">Keamanan &amp; kepatuhan data<\/h2>\n<p>Gunakan HTTPS, batasi akses endpoint, validasi payload, simpan data minimal; sesuaikan retention policy &amp; konsultasi legal jika perlu.<\/p>\n<section id=\"faq-umum\" class=\"faq\">\n<h2>FAQ (Pertanyaan Umum)<\/h2>\n<dl>\n<dt>1. Kenapa data tidak masuk ke Sheets setelah webhook dikonfigurasi?<\/dt>\n<dd>Periksa URL webhook (Apps Script harus dideploy sebagai Web App), cek logs di Apps Script, dan pastikan Mailchimp mengirim event yang sesuai. Panduan debugging: <a href=\"https:\/\/www.benlcollins.com\/apps-script\/mailchimp-integration\/\">Ben Collins<\/a>.<\/dd>\n<dt>2. Bagaimana menangani parsing mismatch saat template email berubah?<\/dt>\n<dd>Update regex sesuai template baru, tambahkan fallback parsing, dan buat monitoring untuk mendeteksi drop di jumlah parsing sukses. Tools testing: <a href=\"https:\/\/regex101.com\/\">regex101.com<\/a>.<\/dd>\n<dt>3. Bagaimana strategi terbaik untuk mencegah duplikat?<\/dt>\n<dd>Pilih key unik (email), gunakan compare case\u2011insensitive + trim atau simpan hash email. Jika match, lakukan update row alih\u2011alih append baru.<\/dd>\n<dt>4. Apakah ada limit\/kuota yang perlu diperhatikan?<\/dt>\n<dd>Ya\u2014Apps Script dan Gmail memiliki quota harian. Jika volume tinggi, pertimbangkan batching, rate limiting, atau solusi middleware. Cek dokumentasi resmi quota.<\/dd>\n<dt>5. Apakah parsing email aman untuk data sensitif?<\/dt>\n<dd>Hindari menyimpan data sensitif tidak terenkripsi; batasi akses ke Sheet dan endpoint; gunakan HTTPS serta kebijakan retention yang sesuai.<\/dd>\n<dt>6. Kapan saya harus memilih webhook daripada parse email?<\/dt>\n<dd>Pilih webhook bila Mailchimp dapat mengirim JSON payload\u2014lebih andal, real\u2011time, dan lebih mudah di\u2011parse. Gunakan parse email hanya sebagai fallback.<\/dd>\n<\/dl>\n<\/section>\n<h2 id=\"ringkasan-manfaat\">Ringkasan manfaat<\/h2>\n<p>Otomasi Mailchimp \u2192 Google Sheets menghemat waktu tim, mengurangi error manual, dan mempercepat SLA follow\u2011up. Dengan pendekatan webhook (direkomendasikan) Anda dapat menerima payload JSON real\u2011time; parsing email menjadi opsi cadangan bila webhook tidak tersedia.<\/p>\n<h2 id=\"lampiran-resources\">Lampiran &amp; resources<\/h2>\n<ul>\n<li><a href=\"https:\/\/www.coupler.io\/google-sheets-integrations\/mailchimp-to-google-sheets\">Coupler \u2014 Mailchimp \u2192 Google Sheets<\/a><\/li>\n<li><a href=\"https:\/\/www.benlcollins.com\/apps-script\/mailchimp-integration\/\">Ben Collins \u2014 Apps Script + Mailchimp<\/a><\/li>\n<li><a href=\"https:\/\/zapier.com\/blog\/integrate-google-sheets-with-mailchimp\/\">Zapier guide<\/a><\/li>\n<li><a href=\"https:\/\/www.youtube.com\/watch?v=56liJEUhMiE\">YouTube demo<\/a><\/li>\n<li><a href=\"\/id\/layanan\/otomasi-integrasi\/\">Internal: layanan otomasi-integrasi<\/a><\/li>\n<li><a href=\"\/id\/portofolio\/mailchimp-integration\/\">Internal: portofolio Mailchimp integration<\/a><\/li>\n<\/ul>\n<h2 id=\"mengapa-inreality-solutions-cocok\">Mengapa InReality Solutions cocok untuk implementasi ini<\/h2>\n<p>InReality Solutions menggabungkan keahlian integrasi sistem, pengalaman implementasi Apps Script &amp; webhook, serta kemampuan menghubungkan automasi ke CRM\/ERP lokal\u2014membantu tim Anda mengurangi waktu manual dan meningkatkan akurasi data. Pelayanan kami mencakup analisis proses, implementasi teknis, dan monitoring operasional. <a href=\"\/id\/layanan\/otomasi-integrasi\/\">Pelajari layanan<\/a>.<\/p>\n<h2 id=\"cta\">Penutup &amp; CTA<\/h2>\n<p>Butuh demo atau audit singkat alur Mailchimp \u2192 Sheets Anda? Ajukan konsultasi teknis end\u2011to\u2011end (webhook\/Apps Script\/regex\/email2sheet) di <a href=\"\/id\/kontak\/konsultasi-otomasi\/\">\/kontak\/konsultasi-otomasi<\/a>. Kami bisa bantu proof\u2011of\u2011concept cepat dan rekomendasi implementasi (integrasi Agentic AI atau Automasi Alur Kerja AI bila perlu).<\/p>","protected":false},"excerpt":{"rendered":"<p>Mailchimp Automation Email Parsing Google Sheets \u2014 Panduan langkah demi langkah Gunakan webhook\/API (direkomendasikan) untuk payload JSON real\u2011time dan parsing minim. Parse email (regex\/email2sheet) adalah fallback bila API\/webhook tidak tersedia, tapi lebih rentan terhadap perubahan template. Implementasi meliputi struktur Sheet, endpoint Apps Script, dedupe, dan monitoring\/quota handling. Daftar Isi Pembuka Contoh skenario nyata untuk bisnis [&hellip;]<\/p>","protected":false},"author":16,"featured_media":8550,"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-7326","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>Mailchimp Automation Email Parsing Google Sheets<\/title>\n<meta name=\"description\" content=\"Mailchimp automation email parsing Google Sheets via webhook\/API atau regex. Panduan Apps Script, dedupe, monitoring, dan keamanan data.\" \/>\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\/mailchimp-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=\"Mailchimp Automation Email Parsing Google Sheets \u2014 Panduan langkah demi langkah\" \/>\n<meta property=\"og:description\" content=\"Mailchimp automation email parsing Google Sheets via webhook\/API atau regex. Panduan Apps Script, dedupe, monitoring, dan keamanan data.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/inrealitysolutions.com\/id\/mailchimp-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=\"2025-12-28T01:17:42+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-03-03T09:43:15+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2025\/12\/Prod-1.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\/mailchimp-automation-email-parsing-google-sheets\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/inrealitysolutions.com\/mailchimp-automation-email-parsing-google-sheets\/\"},\"author\":{\"name\":\"Maya Ananta\",\"@id\":\"https:\/\/inrealitysolutions.com\/id\/#\/schema\/person\/8bf31cc88af0e2066d9d0f57dd52a80a\"},\"headline\":\"Mailchimp Automation Email Parsing Google Sheets \u2014 Panduan langkah demi langkah\",\"datePublished\":\"2025-12-28T01:17:42+00:00\",\"dateModified\":\"2026-03-03T09:43:15+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/inrealitysolutions.com\/mailchimp-automation-email-parsing-google-sheets\/\"},\"wordCount\":1141,\"publisher\":{\"@id\":\"https:\/\/inrealitysolutions.com\/id\/#organization\"},\"image\":{\"@id\":\"https:\/\/inrealitysolutions.com\/mailchimp-automation-email-parsing-google-sheets\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2025\/12\/Prod-1.jpg\",\"articleSection\":[\"AI Automations\"],\"inLanguage\":\"id\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/inrealitysolutions.com\/mailchimp-automation-email-parsing-google-sheets\/\",\"url\":\"https:\/\/inrealitysolutions.com\/mailchimp-automation-email-parsing-google-sheets\/\",\"name\":\"Mailchimp Automation Email Parsing Google Sheets\",\"isPartOf\":{\"@id\":\"https:\/\/inrealitysolutions.com\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/inrealitysolutions.com\/mailchimp-automation-email-parsing-google-sheets\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/inrealitysolutions.com\/mailchimp-automation-email-parsing-google-sheets\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2025\/12\/Prod-1.jpg\",\"datePublished\":\"2025-12-28T01:17:42+00:00\",\"dateModified\":\"2026-03-03T09:43:15+00:00\",\"description\":\"Mailchimp automation email parsing Google Sheets via webhook\/API atau regex. Panduan Apps Script, dedupe, monitoring, dan keamanan data.\",\"breadcrumb\":{\"@id\":\"https:\/\/inrealitysolutions.com\/mailchimp-automation-email-parsing-google-sheets\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/inrealitysolutions.com\/mailchimp-automation-email-parsing-google-sheets\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/inrealitysolutions.com\/mailchimp-automation-email-parsing-google-sheets\/#primaryimage\",\"url\":\"https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2025\/12\/Prod-1.jpg\",\"contentUrl\":\"https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2025\/12\/Prod-1.jpg\",\"width\":1080,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/inrealitysolutions.com\/mailchimp-automation-email-parsing-google-sheets\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/inrealitysolutions.com\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Mailchimp Automation Email Parsing Google Sheets \u2014 Panduan langkah demi langkah\"}]},{\"@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":"Mailchimp Automation Email Parsing Google Sheets","description":"Mailchimp automation email parsing Google Sheets via webhook\/API atau regex. Panduan Apps Script, dedupe, monitoring, dan keamanan data.","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\/mailchimp-automation-email-parsing-google-sheets\/","og_locale":"id_ID","og_type":"article","og_title":"Mailchimp Automation Email Parsing Google Sheets \u2014 Panduan langkah demi langkah","og_description":"Mailchimp automation email parsing Google Sheets via webhook\/API atau regex. Panduan Apps Script, dedupe, monitoring, dan keamanan data.","og_url":"https:\/\/inrealitysolutions.com\/id\/mailchimp-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":"2025-12-28T01:17:42+00:00","article_modified_time":"2026-03-03T09:43:15+00:00","og_image":[{"width":1080,"height":1080,"url":"https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2025\/12\/Prod-1.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\/mailchimp-automation-email-parsing-google-sheets\/#article","isPartOf":{"@id":"https:\/\/inrealitysolutions.com\/mailchimp-automation-email-parsing-google-sheets\/"},"author":{"name":"Maya Ananta","@id":"https:\/\/inrealitysolutions.com\/id\/#\/schema\/person\/8bf31cc88af0e2066d9d0f57dd52a80a"},"headline":"Mailchimp Automation Email Parsing Google Sheets \u2014 Panduan langkah demi langkah","datePublished":"2025-12-28T01:17:42+00:00","dateModified":"2026-03-03T09:43:15+00:00","mainEntityOfPage":{"@id":"https:\/\/inrealitysolutions.com\/mailchimp-automation-email-parsing-google-sheets\/"},"wordCount":1141,"publisher":{"@id":"https:\/\/inrealitysolutions.com\/id\/#organization"},"image":{"@id":"https:\/\/inrealitysolutions.com\/mailchimp-automation-email-parsing-google-sheets\/#primaryimage"},"thumbnailUrl":"https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2025\/12\/Prod-1.jpg","articleSection":["AI Automations"],"inLanguage":"id"},{"@type":"WebPage","@id":"https:\/\/inrealitysolutions.com\/mailchimp-automation-email-parsing-google-sheets\/","url":"https:\/\/inrealitysolutions.com\/mailchimp-automation-email-parsing-google-sheets\/","name":"Mailchimp Automation Email Parsing Google Sheets","isPartOf":{"@id":"https:\/\/inrealitysolutions.com\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/inrealitysolutions.com\/mailchimp-automation-email-parsing-google-sheets\/#primaryimage"},"image":{"@id":"https:\/\/inrealitysolutions.com\/mailchimp-automation-email-parsing-google-sheets\/#primaryimage"},"thumbnailUrl":"https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2025\/12\/Prod-1.jpg","datePublished":"2025-12-28T01:17:42+00:00","dateModified":"2026-03-03T09:43:15+00:00","description":"Mailchimp automation email parsing Google Sheets via webhook\/API atau regex. Panduan Apps Script, dedupe, monitoring, dan keamanan data.","breadcrumb":{"@id":"https:\/\/inrealitysolutions.com\/mailchimp-automation-email-parsing-google-sheets\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/inrealitysolutions.com\/mailchimp-automation-email-parsing-google-sheets\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/inrealitysolutions.com\/mailchimp-automation-email-parsing-google-sheets\/#primaryimage","url":"https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2025\/12\/Prod-1.jpg","contentUrl":"https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2025\/12\/Prod-1.jpg","width":1080,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/inrealitysolutions.com\/mailchimp-automation-email-parsing-google-sheets\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/inrealitysolutions.com\/id\/"},{"@type":"ListItem","position":2,"name":"Mailchimp Automation Email Parsing Google Sheets \u2014 Panduan langkah demi langkah"}]},{"@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\/2025\/12\/Prod-1.jpg",1080,1080,false],"thumbnail":["https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2025\/12\/Prod-1-150x150.jpg",150,150,true],"medium":["https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2025\/12\/Prod-1-300x300.jpg",300,300,true],"medium_large":["https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2025\/12\/Prod-1-768x768.jpg",768,768,true],"large":["https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2025\/12\/Prod-1-1024x1024.jpg",1024,1024,true],"1536x1536":["https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2025\/12\/Prod-1.jpg",1080,1080,false],"2048x2048":["https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2025\/12\/Prod-1.jpg",1080,1080,false],"trp-custom-language-flag":["https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2025\/12\/Prod-1-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":"Mailchimp Automation Email Parsing Google Sheets \u2014 Panduan langkah demi langkah Gunakan webhook\/API (direkomendasikan) untuk payload JSON real\u2011time dan parsing minim. Parse email (regex\/email2sheet) adalah fallback bila API\/webhook tidak tersedia, tapi lebih rentan terhadap perubahan template. Implementasi meliputi struktur Sheet, endpoint Apps Script, dedupe, dan monitoring\/quota handling. Daftar Isi Pembuka Contoh skenario nyata untuk bisnis&hellip;","_links":{"self":[{"href":"https:\/\/inrealitysolutions.com\/id\/wp-json\/wp\/v2\/posts\/7326","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=7326"}],"version-history":[{"count":2,"href":"https:\/\/inrealitysolutions.com\/id\/wp-json\/wp\/v2\/posts\/7326\/revisions"}],"predecessor-version":[{"id":8551,"href":"https:\/\/inrealitysolutions.com\/id\/wp-json\/wp\/v2\/posts\/7326\/revisions\/8551"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/inrealitysolutions.com\/id\/wp-json\/wp\/v2\/media\/8550"}],"wp:attachment":[{"href":"https:\/\/inrealitysolutions.com\/id\/wp-json\/wp\/v2\/media?parent=7326"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/inrealitysolutions.com\/id\/wp-json\/wp\/v2\/categories?post=7326"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/inrealitysolutions.com\/id\/wp-json\/wp\/v2\/tags?post=7326"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}