{"id":9390,"date":"2026-05-23T08:17:24","date_gmt":"2026-05-23T01:17:24","guid":{"rendered":"https:\/\/inrealitysolutions.com\/salesforce-automation-email-parsing-sheets\/"},"modified":"2026-05-23T09:11:37","modified_gmt":"2026-05-23T02:11:37","slug":"salesforce-automation-email-parsing-sheets","status":"publish","type":"post","link":"https:\/\/inrealitysolutions.com\/id\/salesforce-automation-email-parsing-sheets\/","title":{"rendered":"Salesforce Automation Email Parsing Google Sheets \u2014 Tutorial langkah demi langkah"},"content":{"rendered":"<h1><img fetchpriority=\"high\" decoding=\"async\" class=\"aligncenter size-full wp-image-9118\" src=\"https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2026\/05\/SEO-Pict-8.jpg\" alt=\"\" width=\"1080\" height=\"1080\" srcset=\"https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2026\/05\/SEO-Pict-8.jpg 1080w, https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2026\/05\/SEO-Pict-8-300x300.jpg 300w, https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2026\/05\/SEO-Pict-8-1024x1024.jpg 1024w, https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2026\/05\/SEO-Pict-8-150x150.jpg 150w, https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2026\/05\/SEO-Pict-8-768x768.jpg 768w, https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2026\/05\/SEO-Pict-8-12x12.jpg 12w\" sizes=\"(max-width: 1080px) 100vw, 1080px\" \/><\/h1>\n<h1 id=\"salesforce-automation-email-parsing-google-sheets-tutorial-langkah-demi-langkah\">Salesforce Automation Email parsing Google Sheets \u2014 Tutorial langkah demi langkah<\/h1>\n<ul class=\"key-takeaways\">\n<li>Otomasi alur: Gmail \u2192 parse email \u2192 Google Sheets (staging) \u2192 dedupe \u2192 Salesforce.<\/li>\n<li>Pilih jalur cepat (Parseur\/email2sheet) untuk POC, atau Apps Script + Salesforce REST API untuk fleksibilitas penuh.<\/li>\n<li>Gunakan order_id sebagai primary key dan simpan kolom Status\/Error untuk audit dan retry.<\/li>\n<li>Test regex &amp; end\u2011to\u2011end sebelum production; gunakan LockService untuk mencegah race condition.<\/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=\"#ringkasan-solusi-arsitektur\">Ringkasan solusi &amp; arsitektur<\/a><\/li>\n<li><a href=\"#contoh-skenario-nyata-parse-email\">Contoh skenario nyata (parse email)<\/a><\/li>\n<li><a href=\"#prasyarat\">Prasyarat<\/a><\/li>\n<li><a href=\"#langkah-1-menangkap-email-dan-parse-ke-google-sheets\">Langkah 1 \u2014 Menangkap email dan parse ke Google Sheets<\/a><\/li>\n<li><a href=\"#langkah-2-dedupe-business-rules\">Langkah 2 \u2014 Dedupe &amp; business rules sebelum append row<\/a><\/li>\n<li><a href=\"#langkah-3-otomatisasi-pengiriman-data-ke-salesforce\">Langkah 3 \u2014 Otomatisasi pengiriman data ke Salesforce<\/a><\/li>\n<li><a href=\"#testing-deployment\">Testing &amp; deployment<\/a><\/li>\n<li><a href=\"#troubleshooting-umum\">Troubleshooting umum<\/a><\/li>\n<li><a href=\"#variasi-advanced-enhancements\">Variasi &amp; advanced enhancements<\/a><\/li>\n<li><a href=\"#code-resources-appendix\">Code &amp; resources appendix<\/a><\/li>\n<li><a href=\"#kesimpulan-cta\">Kesimpulan &amp; CTA<\/a><\/li>\n<li><a href=\"#faq\">FAQ<\/a><\/li>\n<\/ul>\n<\/nav>\n<h2 id=\"pembuka\">Pembuka<\/h2>\n<p>salesforce automation email parsing google sheets hadir untuk mengatasi pekerjaan manual yang menguras waktu: menerima order\/leads lewat email lalu memindahkan data ke spreadsheet dan CRM. Artikel ini menunjukkan alur praktis (Gmail \u2192 parse email \u2192 Google Sheets \u2192 dedupe \u2192 push ke Salesforce) yang bisa Anda reproduksi dalam ~90 menit (target, tanpa sumber tepercaya). Panduan berfokus pada implementasi teknis, contoh regex, snippet Google Apps Script, dan opsi integrasi\u2014baik no-code maupun low-code.<\/p>\n<h2 id=\"ringkasan-solusi-arsitektur\">Ringkasan solusi &amp; arsitektur<\/h2>\n<p>Arsitektur singkat:<\/p>\n<ul>\n<li>Gmail \u2192 Email parser (add\u2011on atau Apps Script regex) \u2192 Google Sheets (staging) \u2192 dedupe + append row \u2192 Salesforce<\/li>\n<\/ul>\n<p>Fastest path: pakai add\u2011on (<a href=\"https:\/\/parseur.com\/\" target=\"_blank\" rel=\"noopener\">Parseur<\/a> \/ <a href=\"https:\/\/workspace.google.com\/marketplace\/search\/email2sheet\" target=\"_blank\" rel=\"noopener\">email2sheet<\/a>). Most flexible: <a href=\"https:\/\/developers.google.com\/apps-script\" target=\"_blank\" rel=\"noopener\">Apps Script<\/a> + <a href=\"https:\/\/developer.salesforce.com\/docs\/atlas.en-us.api_rest.meta\/api_rest\/\" target=\"_blank\" rel=\"noopener\">Salesforce REST API<\/a>.<\/p>\n<h2 id=\"contoh-skenario-nyata-parse-email\">Contoh skenario nyata (parse email)<\/h2>\n<p>Skenario: toko e\u2011commerce menerima order via email. Tujuan sistem:<\/p>\n<ol>\n<li>baca email order<\/li>\n<li>extract field (order_id, nama, email, produk, qty, total)<\/li>\n<li>simpan ke Google Sheets (append row)<\/li>\n<li>hindari duplikasi (dedupe)<\/li>\n<li>buat Lead\/Order di Salesforce<\/li>\n<\/ol>\n<p>Contoh email mentah:<\/p>\n<pre><code>From: orders@shop-example.com\nSubject: New Order Confirmation #ORD-20260523-7781\n\nOrder ID: ORD-20260523-7781\nCustomer Name: Budi Santoso\nCustomer Email: budi.santoso@example.com\nProduct: Wireless Keyboard\nQty: 2\nPrice: Rp 350.000\nTotal: Rp 700.000\n<\/code><\/pre>\n<h2 id=\"prasyarat\">Prasyarat<\/h2>\n<ul>\n<li>Akun Gmail &amp; Google Sheets<\/li>\n<li>Akses <a href=\"https:\/\/developers.google.com\/apps-script\" target=\"_blank\" rel=\"noopener\">Google Apps Script<\/a><\/li>\n<li>Salesforce sandbox + user dengan API access \/ permission untuk Flow (OAuth docs: <a href=\"https:\/\/developer.salesforce.com\/docs\/atlas.en-us.api_rest.meta\/api_rest\/intro_understanding_oauth.htm\" target=\"_blank\" rel=\"noopener\">Salesforce OAuth<\/a>)<\/li>\n<li>Optional: <a href=\"https:\/\/parseur.com\/\" target=\"_blank\" rel=\"noopener\">Parseur<\/a> atau <a href=\"https:\/\/workspace.google.com\/marketplace\/search\/email2sheet\" target=\"_blank\" rel=\"noopener\">email2sheet<\/a> untuk jalur no\u2011code<\/li>\n<li>Jika mempertimbangkan alur serupa dengan Mailchimp, lihat <a href=\"https:\/\/inrealitysolutions.com\/id\/mailchimp-automation-email-parsing-google-sheets\/\" target=\"_blank\" rel=\"noopener\">panduan Mailchimp automation<\/a><\/li>\n<\/ul>\n<h2 id=\"langkah-1-menangkap-email-dan-parse-ke-google-sheets\">Langkah 1 \u2014 Menangkap email dan parse ke Google Sheets<\/h2>\n<h3 id=\"langkah-1-opsi-a-pakai-addon-parseur-email2sheet\">Opsi A \u2014 Pakai add\u2011on (Parseur \/ email2sheet)<\/h3>\n<ul>\n<li>Install add\u2011on dari Google Workspace Marketplace (email2sheet) atau buat mailbox parser di <a href=\"https:\/\/parseur.com\/\" target=\"_blank\" rel=\"noopener\">Parseur<\/a>.<\/li>\n<li>Forward email order ke alamat parser, map fields, lalu output ke Google Sheets.<\/li>\n<\/ul>\n<p>Referensi: <a href=\"https:\/\/parseur.com\/docs\" target=\"_blank\" rel=\"noopener\">Parseur docs<\/a><\/p>\n<h3 id=\"langkah-1-opsi-b-google-apps-script-custom-parsing\">Opsi B \u2014 Google Apps Script custom parsing (lebih fleksibel)<\/h3>\n<p>Recommended sheet: sheet &#8220;Orders&#8221; dengan kolom: Timestamp, MessageId, OrderId, CustomerName, CustomerEmail, Product, Qty, Price, Total, Status, SalesforceId, Error<\/p>\n<p>Contoh regex:<\/p>\n<ul>\n<li>Order ID: <code>\/Order ID:\\s*(ORD-\\d{8}-\\d+)\/i<\/code><\/li>\n<li>Email: <code>\/Customer Email:\\s*([A-Za-z0-9._%+-]+@[A-Za-z0-9.-]+\\.[A-Za-z]{2,})\/i<\/code><\/li>\n<li>Qty: <code>\/Qty:\\s*(\\d+)\/i<\/code><\/li>\n<li>Price: <code>\/Price:\\s*Rp\\s*([\\d.]+)\/i<\/code><\/li>\n<\/ul>\n<p>Contoh Apps Script (ringkas, tested structure):<\/p>\n<pre><code>function extract(text, regex) {\n  const m = text.match(regex);\n  return m ? m[1].trim() : '';\n}\n\nfunction normalizeNumber(str) {\n  if (!str) return '';\n  return str.replace(\/\\.\/g,'').replace(\/,\/g,'.');\n}\n\nfunction parseOrdersFromGmail() {\n  const sheet = SpreadsheetApp.getActive().getSheetByName('Orders');\n  const threads = GmailApp.search('subject:\"New Order Confirmation\" newer_than:7d');\n  threads.forEach(thread =&gt; {\n    thread.getMessages().forEach(msg =&gt; {\n      const body = msg.getPlainBody();\n      const messageId = msg.getId();\n      const orderId = extract(body, \/Order ID:\\s*(ORD-\\d{8}-\\d+)\/i);\n      if (!orderId) return;\n      \/\/ dedupe handled separately\n      const row = [\n        new Date(), messageId, orderId,\n        extract(body, \/Customer Name:\\s*(.+)\/i),\n        extract(body, \/Customer Email:\\s*([A-Za-z0-9._%+-]+@[A-Za-z0-9.-]+\\.[A-Za-z]{2,})\/i),\n        extract(body, \/Product:\\s*(.+)\/i),\n        Number(extract(body, \/Qty:\\s*(\\d+)\/i) || 0),\n        Number(normalizeNumber(extract(body, \/Price:\\s*Rp\\s*([\\d.]+)\/i)) || 0),\n        Number(normalizeNumber(extract(body, \/Total:\\s*Rp\\s*([\\d.]+)\/i)) || 0),\n        'Pending', '', ''\n      ];\n      sheet.appendRow(row);\n    });\n  });\n}\n<\/code><\/pre>\n<p>Referensi: <a href=\"https:\/\/developers.google.com\/apps-script\/reference\/gmail\/gmail-app\" target=\"_blank\" rel=\"noopener\">GmailApp<\/a> ; <a href=\"https:\/\/developers.google.com\/apps-script\/reference\/spreadsheet\/spreadsheet-app\" target=\"_blank\" rel=\"noopener\">appendRow<\/a><\/p>\n<h2 id=\"langkah-2-dedupe-business-rules\">Langkah 2 \u2014 Dedupe &amp; business rules sebelum append row<\/h2>\n<p>Dedupe penting untuk mencegah Lead\/Order ganda di Salesforce. Strategi umum:<\/p>\n<ul>\n<li>Primary key: order_id (direkomendasikan)<\/li>\n<li>Alternatif: email + messageId atau kombinasi subject+date<\/li>\n<\/ul>\n<p>Contoh <code>isDuplicate<\/code> di Apps Script + LockService untuk race condition:<\/p>\n<pre><code>function isDuplicate(sheet, key, colIndex) {\n  const lock = LockService.getScriptLock();\n  lock.waitLock(30000);\n  try {\n    const lastRow = sheet.getLastRow();\n    if (lastRow &lt; 2) return false;\n    const values = sheet.getRange(2, colIndex, lastRow-1, 1).getValues().flat();\n    return values.includes(key);\n  } finally {\n    lock.releaseLock();\n  }\n}\n<\/code><\/pre>\n<p>(LockService: <a href=\"https:\/\/developers.google.com\/apps-script\/reference\/lock\/lock-service\" target=\"_blank\" rel=\"noopener\">LockService<\/a>)<\/p>\n<h2 id=\"langkah-3-otomatisasi-pengiriman-data-ke-salesforce\">Langkah 3 \u2014 Otomatisasi pengiriman data ke Salesforce<\/h2>\n<h3 id=\"langkah-3-opsi-a-no-code-zapier-make\">Opsi A \u2014 No\u2011code: Zapier \/ Make (cepatan implementasi)<\/h3>\n<p>Integrasi cepat: <a href=\"https:\/\/zapier.com\/apps\/google-sheets\/integrations\/salesforce\" target=\"_blank\" rel=\"noopener\">Zapier Google Sheets \u2192 Salesforce<\/a>. Untuk contoh pattern Zapier (OCR\/invoice-focused) lihat: <a href=\"https:\/\/inrealitysolutions.com\/id\/zapier-automation-ocr-invoice\/\" target=\"_blank\" rel=\"noopener\">Zapier OCR invoice<\/a>. Panduan Make untuk alur parsing \u2192 Sheets \u2192 Salesforce: <a href=\"https:\/\/inrealitysolutions.com\/id\/make-automation-email-parsing-google-sheets\/\" target=\"_blank\" rel=\"noopener\">Make guide<\/a>.<\/p>\n<h3 id=\"langkah-3-opsi-b-low-code-apps-script-salesforce-rest-api\">Opsi B \u2014 Low\u2011code: Apps Script + Salesforce REST API<\/h3>\n<ul>\n<li>Buat Connected App di Salesforce (OAuth): <a href=\"https:\/\/developer.salesforce.com\/docs\/atlas.en-us.api_rest.meta\/api_rest\/intro_understanding_oauth.htm\" target=\"_blank\" rel=\"noopener\">Salesforce OAuth docs<\/a><\/li>\n<li>Endpoint create Lead: POST {instance}\/services\/data\/v60.0\/sobjects\/Lead\/ (docs: <a href=\"https:\/\/developer.salesforce.com\/docs\/atlas.en-us.api_rest.meta\/api_rest\/resources_sobject_create.htm\" target=\"_blank\" rel=\"noopener\">create sObject<\/a>)<\/li>\n<\/ul>\n<p>Contoh payload JSON:<\/p>\n<pre><code>{\n  \"LastName\":\"Santoso\",\n  \"Company\":\"Shop Example\",\n  \"Email\":\"budi.santoso@example.com\",\n  \"LeadSource\":\"Email Order Parsing\",\n  \"Description\":\"Order ID: ORD-xxxx | Product: ...\"\n}\n<\/code><\/pre>\n<p>Untuk alur enrichment setelah lead dibuat, lihat: <a href=\"https:\/\/inrealitysolutions.com\/id\/salesforce-automation-lead-enrichment\/\" target=\"_blank\" rel=\"noopener\">Salesforce lead enrichment<\/a><\/p>\n<h3 id=\"langkah-3-opsi-c-native-salesforce-flow\">Opsi C \u2014 Native Salesforce Flow \/ workflow<\/h3>\n<p>Kirim data ke Salesforce (API \/ webhook), lalu gunakan Record\u2011Triggered atau Autolaunched Flow untuk validasi &amp; create records (Flow basics: <a href=\"https:\/\/help.salesforce.com\/s\/articleView?id=sf.flow_builder_overview.htm&amp;type=5\" target=\"_blank\" rel=\"noopener\">Flow builder overview<\/a>).<\/p>\n<p>Jika membangun eskalasi\/ticketing berbasis Salesforce setelah lead\/order masuk, referensi implementasi eskalasi: <a href=\"https:\/\/inrealitysolutions.com\/id\/salesforce-automation-ticketing-escalation\/\" target=\"_blank\" rel=\"noopener\">ticketing escalation<\/a>.<\/p>\n<h2 id=\"testing-deployment\">Testing &amp; deployment<\/h2>\n<ul>\n<li>Unit test regex dengan variasi email (minimal 5 varian)<\/li>\n<li>End\u2011to\u2011end test: kirim sample email \u2192 pastikan row muncul \u2192 dedupe berjalan \u2192 SalesforceId terisi<\/li>\n<li>Trigger scheduling: Apps Script time\u2011driven triggers (<a href=\"https:\/\/developers.google.com\/apps-script\/guides\/triggers\" target=\"_blank\" rel=\"noopener\">triggers guide<\/a>)<\/li>\n<li>Logging: kolom Status\/Error dan tab Logs untuk audit<\/li>\n<\/ul>\n<p>Contoh penggunaan scheduling\/cron-like workflows dengan Apps Script: <a href=\"https:\/\/inrealitysolutions.com\/id\/apps-script-automation-daily-report\/\" target=\"_blank\" rel=\"noopener\">Daily Report Bot<\/a>.<\/p>\n<h2 id=\"troubleshooting-umum\">Troubleshooting umum<\/h2>\n<ul>\n<li>Parsing gagal: regex terlalu ketat \u2192 buat fallback templates<\/li>\n<li>Dedupe FP\/FN: perbaiki key atau gunakan fuzzy match (tanpa sumber tepercaya)<\/li>\n<li>Salesforce auth errors: cek scopes &amp; Connected App settings (<a href=\"https:\/\/developer.salesforce.com\/docs\/atlas.en-us.api_rest.meta\/api_rest\/intro_understanding_oauth.htm\" target=\"_blank\" rel=\"noopener\">OAuth docs<\/a>)<\/li>\n<li>Rate limits &amp; batching: lihat Salesforce API limits (<a href=\"https:\/\/developer.salesforce.com\/docs\/atlas.en-us.api_rest.meta\/api_rest\/requests_limits.htm\" target=\"_blank\" rel=\"noopener\">requests limits<\/a>) dan gunakan batching\/retry dengan exponential backoff (<a href=\"https:\/\/cloud.google.com\/apis\/design\/errors#retry_and_backoff\" target=\"_blank\" rel=\"noopener\">retry &amp; backoff<\/a>).<\/li>\n<\/ul>\n<h2 id=\"variasi-advanced-enhancements\">Variasi &amp; advanced enhancements<\/h2>\n<ul>\n<li>Attachment\/PDF parsing: gunakan OCR (Google Vision OCR: <a href=\"https:\/\/cloud.google.com\/vision\/docs\/ocr\" target=\"_blank\" rel=\"noopener\">Vision OCR<\/a>).<\/li>\n<li>Scale: pindahkan parsing ke Cloud Functions \/ Cloud Run (<a href=\"https:\/\/cloud.google.com\/run\" target=\"_blank\" rel=\"noopener\">Cloud Run<\/a>) jika volume besar.<\/li>\n<li>Keamanan: jangan simpan secrets di kode; gunakan Script Properties atau <a href=\"https:\/\/cloud.google.com\/secret-manager\" target=\"_blank\" rel=\"noopener\">Secret Manager<\/a>.<\/li>\n<\/ul>\n<h2 id=\"code-resources-appendix\">Code &amp; resources appendix (penting)<\/h2>\n<ul>\n<li><a href=\"https:\/\/developers.google.com\/apps-script\" target=\"_blank\" rel=\"noopener\">Apps Script docs<\/a><\/li>\n<li><a href=\"https:\/\/developers.google.com\/apps-script\/reference\/gmail\/gmail-app\" target=\"_blank\" rel=\"noopener\">GmailApp ref<\/a><\/li>\n<li><a href=\"https:\/\/developers.google.com\/apps-script\/reference\/spreadsheet\/spreadsheet-app\" target=\"_blank\" rel=\"noopener\">SpreadsheetApp ref<\/a><\/li>\n<li><a href=\"https:\/\/parseur.com\/\" target=\"_blank\" rel=\"noopener\">Parseur<\/a><\/li>\n<li><a href=\"https:\/\/workspace.google.com\/marketplace\/search\/email2sheet\" target=\"_blank\" rel=\"noopener\">email2sheet marketplace<\/a><\/li>\n<li><a href=\"https:\/\/developer.salesforce.com\/docs\/atlas.en-us.api_rest.meta\/api_rest\/\" target=\"_blank\" rel=\"noopener\">Salesforce REST API<\/a><\/li>\n<\/ul>\n<h2 id=\"kesimpulan-cta\">Kesimpulan &amp; CTA<\/h2>\n<p>Flow yang direkomendasikan: Gmail \u2192 parse email \u2192 Google Sheets (staging) \u2192 dedupe \u2192 append row \u2192 Salesforce. Praktik terbaik: gunakan order_id sebagai primary key, validasi input, dan simpan status\/error untuk audit. Jika Anda butuh implementasi end\u2011to\u2011end, audit keamanan, atau demo integrasi Salesforce + otomasi: hubungi tim InReality Solutions untuk konsultasi dan demo (<a href=\"https:\/\/inrealitysolutions.com\/id\/contact\/\">\/contact<\/a>).<\/p>\n<p>Untuk contoh lain menghubungkan Google Sheets ke CRM (bukan hanya Salesforce), lihat: <a href=\"https:\/\/inrealitysolutions.com\/id\/google-sheets-automation-form-crm\/\" target=\"_blank\" rel=\"noopener\">Google Sheets automation form to CRM<\/a>.<\/p>\n<section id=\"faq\" class=\"faq\" aria-labelledby=\"faq-heading\">\n<h2 id=\"faq-heading\">FAQ<\/h2>\n<div>\n<h3 id=\"faq-1\">Q: Bisakah pakai non\u2011Gmail?<\/h3>\n<p>A: Ya\u2014pakai IMAP\/forwarding atau connector (IMAP guide: <a href=\"https:\/\/support.google.com\/mail\/answer\/10957\" target=\"_blank\" rel=\"noopener\">Google Mail IMAP guide<\/a>).<\/p>\n<\/div>\n<div>\n<h3 id=\"faq-2\">Q: Bagaimana menangani multilingual emails?<\/h3>\n<p>A: Buat template per bahasa dan gunakan regex yang fleksibel atau fallback parsing; pertimbangkan NLP \/ language detection untuk routing ke template yang tepat.<\/p>\n<\/div>\n<div>\n<h3 id=\"faq-3\">Q: Estimasi biaya?<\/h3>\n<p>A: Bergantung kompleksitas alur kerja (add\u2011on, licence API, volume, dan developer time). Untuk estimasi terperinci, minta konsultasi.<\/p>\n<\/div>\n<div>\n<h3 id=\"faq-4\">Q: Bagaimana menyimpan secrets secara aman?<\/h3>\n<p>A: Jangan hardcode secrets di skrip. Gunakan Script Properties atau layanan seperti <a href=\"https:\/\/cloud.google.com\/secret-manager\" target=\"_blank\" rel=\"noopener\">Google Secret Manager<\/a>, dan batasi akses pada Connected App di Salesforce.<\/p>\n<\/div>\n<div>\n<h3 id=\"faq-5\">Q: Apa batasan rate pada Salesforce dan bagaimana mengatasinya?<\/h3>\n<p>A: Salesforce punya API limits; rancang batching, retry dengan exponential backoff, dan monitoring. Lihat <a href=\"https:\/\/developer.salesforce.com\/docs\/atlas.en-us.api_rest.meta\/api_rest\/requests_limits.htm\" target=\"_blank\" rel=\"noopener\">Salesforce API limits<\/a> untuk detail.<\/p>\n<\/div>\n<\/section>\n<footer>Internal resources: <a href=\"\/id\/services\/automation\/\">layanan otomasi &amp; integrasi<\/a> | <a href=\"\/id\/portfolio\/salesforce-integrations\/\">portofolio integrasi CRM<\/a><\/p>\n<p>Butuh template Google Sheet + Apps Script yang sudah dites ringan di sandbox? Hubungi tim kami untuk demo.<\/p>\n<\/footer>\n<p>&nbsp;<\/p>","protected":false},"excerpt":{"rendered":"<p>Salesforce Automation Email parsing Google Sheets \u2014 Tutorial langkah demi langkah Otomasi alur: Gmail \u2192 parse email \u2192 Google Sheets (staging) \u2192 dedupe \u2192 Salesforce. Pilih jalur cepat (Parseur\/email2sheet) untuk POC, atau Apps Script + Salesforce REST API untuk fleksibilitas penuh. Gunakan order_id sebagai primary key dan simpan kolom Status\/Error untuk audit dan retry. Test [&hellip;]<\/p>","protected":false},"author":16,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","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-9390","post","type-post","status-publish","format-standard","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>Salesforce Automation Email Parsing Google Sheets<\/title>\n<meta name=\"description\" content=\"Tutorial salesforce automation email parsing google sheets: alur Gmail ke Sheets hingga Salesforce lengkap dengan dedupe dan integrasi.\" \/>\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\/salesforce-automation-email-parsing-sheets\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Salesforce Automation Email Parsing Google Sheets \u2014 Tutorial langkah demi langkah\" \/>\n<meta property=\"og:description\" content=\"Tutorial salesforce automation email parsing google sheets: alur Gmail ke Sheets hingga Salesforce lengkap dengan dedupe dan integrasi.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/inrealitysolutions.com\/id\/salesforce-automation-email-parsing-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-05-23T01:17:24+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-05-23T02:11:37+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2026\/05\/SEO-Pict-8.jpg\" \/>\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=\"5 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/inrealitysolutions.com\/salesforce-automation-email-parsing-sheets\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/inrealitysolutions.com\/salesforce-automation-email-parsing-sheets\/\"},\"author\":{\"name\":\"Maya Ananta\",\"@id\":\"https:\/\/inrealitysolutions.com\/id\/#\/schema\/person\/8bf31cc88af0e2066d9d0f57dd52a80a\"},\"headline\":\"Salesforce Automation Email Parsing Google Sheets \u2014 Tutorial langkah demi langkah\",\"datePublished\":\"2026-05-23T01:17:24+00:00\",\"dateModified\":\"2026-05-23T02:11:37+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/inrealitysolutions.com\/salesforce-automation-email-parsing-sheets\/\"},\"wordCount\":968,\"publisher\":{\"@id\":\"https:\/\/inrealitysolutions.com\/id\/#organization\"},\"image\":{\"@id\":\"https:\/\/inrealitysolutions.com\/salesforce-automation-email-parsing-sheets\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2026\/05\/SEO-Pict-8.jpg\",\"articleSection\":[\"AI Automations\"],\"inLanguage\":\"id\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/inrealitysolutions.com\/salesforce-automation-email-parsing-sheets\/\",\"url\":\"https:\/\/inrealitysolutions.com\/salesforce-automation-email-parsing-sheets\/\",\"name\":\"Salesforce Automation Email Parsing Google Sheets\",\"isPartOf\":{\"@id\":\"https:\/\/inrealitysolutions.com\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/inrealitysolutions.com\/salesforce-automation-email-parsing-sheets\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/inrealitysolutions.com\/salesforce-automation-email-parsing-sheets\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2026\/05\/SEO-Pict-8.jpg\",\"datePublished\":\"2026-05-23T01:17:24+00:00\",\"dateModified\":\"2026-05-23T02:11:37+00:00\",\"description\":\"Tutorial salesforce automation email parsing google sheets: alur Gmail ke Sheets hingga Salesforce lengkap dengan dedupe dan integrasi.\",\"breadcrumb\":{\"@id\":\"https:\/\/inrealitysolutions.com\/salesforce-automation-email-parsing-sheets\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/inrealitysolutions.com\/salesforce-automation-email-parsing-sheets\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/inrealitysolutions.com\/salesforce-automation-email-parsing-sheets\/#primaryimage\",\"url\":\"https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2026\/05\/SEO-Pict-8.jpg\",\"contentUrl\":\"https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2026\/05\/SEO-Pict-8.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/inrealitysolutions.com\/salesforce-automation-email-parsing-sheets\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/inrealitysolutions.com\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Salesforce Automation Email Parsing Google Sheets \u2014 Tutorial 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":"Salesforce Automation Email Parsing Google Sheets","description":"Tutorial salesforce automation email parsing google sheets: alur Gmail ke Sheets hingga Salesforce lengkap dengan dedupe dan integrasi.","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\/salesforce-automation-email-parsing-sheets\/","og_locale":"id_ID","og_type":"article","og_title":"Salesforce Automation Email Parsing Google Sheets \u2014 Tutorial langkah demi langkah","og_description":"Tutorial salesforce automation email parsing google sheets: alur Gmail ke Sheets hingga Salesforce lengkap dengan dedupe dan integrasi.","og_url":"https:\/\/inrealitysolutions.com\/id\/salesforce-automation-email-parsing-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-05-23T01:17:24+00:00","article_modified_time":"2026-05-23T02:11:37+00:00","og_image":[{"url":"https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2026\/05\/SEO-Pict-8.jpg"}],"author":"Maya Ananta","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Maya Ananta","Estimasi waktu membaca":"5 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/inrealitysolutions.com\/salesforce-automation-email-parsing-sheets\/#article","isPartOf":{"@id":"https:\/\/inrealitysolutions.com\/salesforce-automation-email-parsing-sheets\/"},"author":{"name":"Maya Ananta","@id":"https:\/\/inrealitysolutions.com\/id\/#\/schema\/person\/8bf31cc88af0e2066d9d0f57dd52a80a"},"headline":"Salesforce Automation Email Parsing Google Sheets \u2014 Tutorial langkah demi langkah","datePublished":"2026-05-23T01:17:24+00:00","dateModified":"2026-05-23T02:11:37+00:00","mainEntityOfPage":{"@id":"https:\/\/inrealitysolutions.com\/salesforce-automation-email-parsing-sheets\/"},"wordCount":968,"publisher":{"@id":"https:\/\/inrealitysolutions.com\/id\/#organization"},"image":{"@id":"https:\/\/inrealitysolutions.com\/salesforce-automation-email-parsing-sheets\/#primaryimage"},"thumbnailUrl":"https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2026\/05\/SEO-Pict-8.jpg","articleSection":["AI Automations"],"inLanguage":"id"},{"@type":"WebPage","@id":"https:\/\/inrealitysolutions.com\/salesforce-automation-email-parsing-sheets\/","url":"https:\/\/inrealitysolutions.com\/salesforce-automation-email-parsing-sheets\/","name":"Salesforce Automation Email Parsing Google Sheets","isPartOf":{"@id":"https:\/\/inrealitysolutions.com\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/inrealitysolutions.com\/salesforce-automation-email-parsing-sheets\/#primaryimage"},"image":{"@id":"https:\/\/inrealitysolutions.com\/salesforce-automation-email-parsing-sheets\/#primaryimage"},"thumbnailUrl":"https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2026\/05\/SEO-Pict-8.jpg","datePublished":"2026-05-23T01:17:24+00:00","dateModified":"2026-05-23T02:11:37+00:00","description":"Tutorial salesforce automation email parsing google sheets: alur Gmail ke Sheets hingga Salesforce lengkap dengan dedupe dan integrasi.","breadcrumb":{"@id":"https:\/\/inrealitysolutions.com\/salesforce-automation-email-parsing-sheets\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/inrealitysolutions.com\/salesforce-automation-email-parsing-sheets\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/inrealitysolutions.com\/salesforce-automation-email-parsing-sheets\/#primaryimage","url":"https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2026\/05\/SEO-Pict-8.jpg","contentUrl":"https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2026\/05\/SEO-Pict-8.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/inrealitysolutions.com\/salesforce-automation-email-parsing-sheets\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/inrealitysolutions.com\/id\/"},{"@type":"ListItem","position":2,"name":"Salesforce Automation Email Parsing Google Sheets \u2014 Tutorial 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":false,"thumbnail":false,"medium":false,"medium_large":false,"large":false,"1536x1536":false,"2048x2048":false,"trp-custom-language-flag":false},"uagb_author_info":{"display_name":"Maya Ananta","author_link":"https:\/\/inrealitysolutions.com\/id\/author\/mayaananta\/"},"uagb_comment_info":0,"uagb_excerpt":"Salesforce Automation Email parsing Google Sheets \u2014 Tutorial langkah demi langkah Otomasi alur: Gmail \u2192 parse email \u2192 Google Sheets (staging) \u2192 dedupe \u2192 Salesforce. Pilih jalur cepat (Parseur\/email2sheet) untuk POC, atau Apps Script + Salesforce REST API untuk fleksibilitas penuh. Gunakan order_id sebagai primary key dan simpan kolom Status\/Error untuk audit dan retry. Test&hellip;","_links":{"self":[{"href":"https:\/\/inrealitysolutions.com\/id\/wp-json\/wp\/v2\/posts\/9390","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=9390"}],"version-history":[{"count":3,"href":"https:\/\/inrealitysolutions.com\/id\/wp-json\/wp\/v2\/posts\/9390\/revisions"}],"predecessor-version":[{"id":9398,"href":"https:\/\/inrealitysolutions.com\/id\/wp-json\/wp\/v2\/posts\/9390\/revisions\/9398"}],"wp:attachment":[{"href":"https:\/\/inrealitysolutions.com\/id\/wp-json\/wp\/v2\/media?parent=9390"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/inrealitysolutions.com\/id\/wp-json\/wp\/v2\/categories?post=9390"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/inrealitysolutions.com\/id\/wp-json\/wp\/v2\/tags?post=9390"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}