{"id":8067,"date":"2026-01-25T08:20:59","date_gmt":"2026-01-25T01:20:59","guid":{"rendered":"https:\/\/inrealitysolutions.com\/google-sheets-automation-lead-enrichment\/"},"modified":"2026-01-26T11:44:30","modified_gmt":"2026-01-26T04:44:30","slug":"google-sheets-automation-lead-enrichment","status":"publish","type":"post","link":"https:\/\/inrealitysolutions.com\/id\/google-sheets-automation-lead-enrichment\/","title":{"rendered":"Google Sheets Automation Lead Enrichment"},"content":{"rendered":"<article>\n<h1 id=\"google-sheets-automation-lead-enrichment\"><img fetchpriority=\"high\" decoding=\"async\" class=\"aligncenter size-full wp-image-8091\" src=\"http:\/\/inrealitysolutions.com\/wp-content\/uploads\/2026\/01\/Prod-13.jpg\" alt=\"\" width=\"1080\" height=\"1080\" srcset=\"https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2026\/01\/Prod-13.jpg 1080w, https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2026\/01\/Prod-13-300x300.jpg 300w, https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2026\/01\/Prod-13-1024x1024.jpg 1024w, https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2026\/01\/Prod-13-150x150.jpg 150w, https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2026\/01\/Prod-13-768x768.jpg 768w, https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2026\/01\/Prod-13-12x12.jpg 12w\" sizes=\"(max-width: 1080px) 100vw, 1080px\" \/>Google Sheets Automation Lead Enrichment<\/h1>\n<p>Google Sheets automation lead enrichment memungkinkan tim sales dan marketing memperkaya data prospek (firmographic dan contact enrichment) langsung dari Google Sheets\u2014mengurangi kerja manual dan mempercepat outreach\u2014hingga sheet ter-enrich yang siap dipush ke CRM seperti <a href=\"https:\/\/inrealitysolutions.com\/id\/zapier-automation-lead-enrichment\/\">Append CRM<\/a> atau disinkronkan berjadwal (harian\/mingguan) untuk proses berkelanjutan. Lihat juga contoh add-on <a href=\"https:\/\/workspace.google.com\/marketplace\/app\/lead_enrichment_ai_sheet_capgoai\/739049508705\">CapGo.AI (Marketplace)<\/a>. Artikel ini memberi panduan langkah\u2011demi\u2011langkah (kode <a href=\"https:\/\/inrealitysolutions.com\/id\/apps-script-automation-daily-report\/\">Google Apps Script<\/a> + opsi no\u2011code) dengan contoh skenario B2B Indonesia dan referensi implementasi seperti <a href=\"https:\/\/www.linkup.so\/blog\/what-is-lead-enrichment-a-practical-guide-to-automation-in-2025\">LinkUp<\/a> dan <a href=\"https:\/\/www.pabbly.com\/integrating-new-leads-with-google-sheets-using-automation\/\">Pabbly<\/a>.<\/p>\n<ul class=\"key-takeaways\">\n<li>Otomasi enrichment langsung dari Google Sheets mengurangi input manual dan mempercepat push ke CRM.<\/li>\n<li>Arsitektur umum: Sheets \u2192 Enrichment API \u2192 Update Sheet \u2192 Push ke CRM \u2192 Trigger terjadwal.<\/li>\n<li>Pilih antara kode (Apps Script) atau no\u2011code (Make\/Zapier\/Pabbly) sesuai skala dan biaya.<\/li>\n<li>Praktik penting: batching, rate\u2011limit handling, cache hasil, dan proteksi API key.<\/li>\n<\/ul>\n<nav class=\"toc\" aria-label=\"Daftar isi\"><strong>Daftar Isi<\/strong><\/p>\n<ul>\n<li><a href=\"#pembukaan\">Pembukaan<\/a><\/li>\n<li><a href=\"#siapa-target-pembaca\">Siapa target pembaca<\/a><\/li>\n<li><a href=\"#ringkasan-solusi-arsitektur-tinggi\">Ringkasan solusi &amp; arsitektur tinggi<\/a><\/li>\n<li><a href=\"#logical-flow-ringkasan-teknis\">Logical flow (ringkasan teknis)<\/a><\/li>\n<li><a href=\"#skenario-contoh-b2b-indonesia\">Skenario contoh (B2B Indonesia)<\/a><\/li>\n<li><a href=\"#prasyarat-persiapan-akun-api\">Prasyarat &amp; persiapan akun\/API<\/a><\/li>\n<li><a href=\"#struktur-google-sheet-template-kolom-rekomendasi\">Struktur Google Sheet \u2014 template &amp; kolom rekomendasi<\/a><\/li>\n<li><a href=\"#langkah-langkah-implementasi\">Langkah\u2011langkah implementasi<\/a><\/li>\n<li><a href=\"#detail-implementasi-google-apps-script\">Detail implementasi \u2014 Google Apps Script<\/a><\/li>\n<li><a href=\"#alternatif-tanpa-kode\">Alternatif tanpa kode (Make \/ Zapier \/ Pabbly)<\/a><\/li>\n<li><a href=\"#mapping-field-logika-bisnis-enrichment\">Mapping field &amp; logika bisnis enrichment<\/a><\/li>\n<li><a href=\"#praktik-terbaik-keamanan\">Praktik terbaik &amp; keamanan<\/a><\/li>\n<li><a href=\"#pengujian-deployment-maintenance\">Pengujian, deployment &amp; maintenance<\/a><\/li>\n<li><a href=\"#integrasi-teknis-ke-appendix-crm\">Integrasi teknis ke Appendix CRM<\/a><\/li>\n<li><a href=\"#contoh-hasil-yang-diharapkan\">Contoh hasil yang diharapkan<\/a><\/li>\n<li><a href=\"#resources-deliverables\">Resources &amp; deliverables<\/a><\/li>\n<li><a href=\"#mengapa-inreality-solutions-cocok\">Mengapa InReality Solutions cocok<\/a><\/li>\n<li><a href=\"#call-to-action-konsultasi-demo\">Call\u2011to\u2011Action \u2014 Konsultasi &amp; Demo<\/a><\/li>\n<li><a href=\"#ringkasan-next-steps\">Ringkasan &amp; next steps<\/a><\/li>\n<li><a href=\"#faq\">FAQ<\/a><\/li>\n<\/ul>\n<\/nav>\n<h2 id=\"pembukaan\">Pembukaan<\/h2>\n<p>Otomasi enrichment di Google Sheets memungkinkan tim untuk memperkaya daftar leads (firmographic &amp; contact enrichment) tanpa meninggalkan spreadsheet. Hasil enrichment dapat disiapkan untuk ditransfer ke CRM seperti <a href=\"https:\/\/inrealitysolutions.com\/id\/zapier-automation-lead-enrichment\/\">Append CRM<\/a> atau disinkronkan secara periodik dengan add-on seperti <a href=\"https:\/\/workspace.google.com\/marketplace\/app\/lead_enrichment_ai_sheet_capgoai\/739049508705\">CapGo.AI<\/a>. Panduan ini mencakup opsi Apps Script dan no\u2011code serta referensi implementasi dari <a href=\"https:\/\/www.linkup.so\/blog\/what-is-lead-enrichment-a-practical-guide-to-automation-in-2025\">LinkUp<\/a> dan <a href=\"https:\/\/www.pabbly.com\/integrating-new-leads-with-google-sheets-using-automation\/\">Pabbly<\/a>.<\/p>\n<h2 id=\"siapa-target-pembaca\">Siapa target pembaca<\/h2>\n<p>Panduan ini ditujukan untuk tim sales\/marketing, sales ops, data ops, dan developer non\u2011teknis di perusahaan B2B (properti, retail, hospitality, edukasi, kesehatan) yang mengelola daftar leads dari marketplace\/website dan ingin mengurangi entry manual. Untuk referensi tutorial praktis lihat <a href=\"https:\/\/www.youtube.com\/watch?v=24qK5XDNZgA\">video tutorial<\/a>.<\/p>\n<h2 id=\"ringkasan-solusi-arsitektur-tinggi\">Ringkasan solusi &amp; arsitektur tinggi<\/h2>\n<p>Arsitektur sederhana yang direkomendasikan:<\/p>\n<ul>\n<li>Google Sheets (input) \u2192 <a href=\"https:\/\/inrealitysolutions.com\/id\/zapier-automation-lead-enrichment\/\">Google Apps Script \/ no\u2011code tool<\/a> \u2192 Search API \/ Clearbit\u2011like enrichment \u2192 Update sheet \u2192 Push ke <a href=\"https:\/\/inrealitysolutions.com\/id\/zapier-automation-lead-enrichment\/\">Append CRM<\/a> \u2192 Trigger terjadwal.<\/li>\n<li>Contoh add\u2011on\/penyedia: <a href=\"https:\/\/workspace.google.com\/marketplace\/app\/lead_enrichment_ai_sheet_capgoai\/739049508705\">CapGo.AI<\/a>; konsep end\u2011to\u2011end dijelaskan di <a href=\"https:\/\/www.linkup.so\/blog\/what-is-lead-enrichment-a-practical-guide-to-automation-in-2025\">LinkUp<\/a>.<\/li>\n<\/ul>\n<h2 id=\"logical-flow-ringkasan-teknis\">Logical flow (ringkasan teknis)<\/h2>\n<ol>\n<li>Input columns: name, email, company_domain.<\/li>\n<li>Call Search API untuk domain lookup \u2192 panggil Clearbit\u2011like enrichment API.<\/li>\n<li>Map hasil ke kolom output (company_name, industry, company_size, dll.).<\/li>\n<li>Push ke Append CRM via API\/webhook.<\/li>\n<li>Time\u2011driven trigger (Apps Script) untuk jadwal harian\/mingguan (lihat <a href=\"https:\/\/www.youtube.com\/playlist?list=PLgffPJ6GjbaKvTpzeNxltQbM_7etd-61j\">Apps Script triggers playlist<\/a>).<\/li>\n<\/ol>\n<h2 id=\"skenario-contoh-b2b-indonesia\">Skenario contoh (B2B Indonesia)<\/h2>\n<p>Contoh A \u2014 Tim SDR properti Jakarta:<\/p>\n<ul>\n<li>Input sample (10\u2013100 rows): name, email, domain.<\/li>\n<li>Workflow: otomatis enrich company fields \u2192 hasil siap diprioritaskan untuk outreach.<\/li>\n<li>Action rekomendasi: unduh template, import ~10 sample rows, jalankan POC (unduh template via <a href=\"https:\/\/inrealitysolutions.com\/id\/mailchimp-automation-email-parsing-google-sheets\/\">resources<\/a>).<\/li>\n<\/ul>\n<h2 id=\"prasyarat-persiapan-akun-api\">Prasyarat &amp; persiapan akun\/API<\/h2>\n<ul>\n<li>Akun Google (Sheets &amp; Apps Script).<\/li>\n<li>API key provider enrichment (Clearbit\u2011like: <a href=\"https:\/\/workspace.google.com\/marketplace\/app\/lead_enrichment_ai_sheet_capgoai\/739049508705\">CapGo.AI<\/a>, FullContact, Apollo) dan akses Append CRM untuk push data.<\/li>\n<li>Izin\/akses untuk memasang trigger Apps Script.<\/li>\n<\/ul>\n<h2 id=\"struktur-google-sheet-template-kolom-rekomendasi\">Struktur Google Sheet \u2014 template &amp; kolom rekomendasi<\/h2>\n<p>Kolom input: <code>name<\/code>, <code>email<\/code>, <code>company_domain<\/code>, <code>source<\/code>, <code>notes<\/code>.<\/p>\n<p>Kolom output: <code>company_name<\/code>, <code>industry<\/code>, <code>company_size<\/code>, <code>revenue_estimate<\/code>, <code>linkedin_url<\/code>, <code>tech_stack<\/code>, <code>enrichment_status<\/code>, <code>timestamp<\/code>. Untuk contoh struktur lihat panduan di <a href=\"https:\/\/www.linkup.so\/blog\/what-is-lead-enrichment-a-practical-guide-to-automation-in-2025\">LinkUp<\/a>.<\/p>\n<h2 id=\"langkah-langkah-implementasi\">Langkah\u2011langkah implementasi<\/h2>\n<ol>\n<li>Siapkan template &amp; sample data (10\u201350 baris) \u2014 referensi <a href=\"https:\/\/www.pabbly.com\/integrating-new-leads-with-google-sheets-using-automation\/\">Pabbly<\/a>.<\/li>\n<li>Pilih provider &amp; dapatkan API key (Search API \/ Clearbit\u2011like).<\/li>\n<li>Tulis\/pasang Google Apps Script atau buat workflow no\u2011code (Make\/Zapier\/Pabbly). Contoh referensi Apps Script: <a href=\"https:\/\/inrealitysolutions.com\/id\/apps-script-automation-daily-report\/\">Apps Script sample<\/a>; contoh Zapier workflow: <a href=\"https:\/\/inrealitysolutions.com\/id\/zapier-automation-lead-enrichment\/\">Zapier guide<\/a>.<\/li>\n<li>Jalankan batch (mis. batch size 50 sebagai rekomendasi praktik umum; lihat <a href=\"https:\/\/www.youtube.com\/watch?v=gX_Ej8aUfXQ\">video<\/a>).<\/li>\n<li>Tandai hasil, log error &amp; simpan raw JSON.<\/li>\n<li>Push ke Append CRM via API.<\/li>\n<li>Jadwalkan trigger time\u2011driven.<\/li>\n<\/ol>\n<h2 id=\"detail-implementasi-google-apps-script\">Detail implementasi \u2014 Google Apps Script (struktur fungsi)<\/h2>\n<p>Fungsi inti contoh:<\/p>\n<pre><code>function enrichBatch() {\n  fetchRows();\n  enrichRow();\n  handleRateLimit();\n  updateRow();\n  pushToCRM();\n}<\/code><\/pre>\n<p>Gunakan retry\/backoff untuk error handling; simpan raw JSON di kolom terpisah. Referensi contoh kode di <a href=\"https:\/\/inrealitysolutions.com\/id\/apps-script-automation-daily-report\/\">Apps Script sample<\/a> dan <a href=\"https:\/\/www.youtube.com\/watch?v=24qK5XDNZgA\">video tutorial<\/a>.<\/p>\n<h2 id=\"alternatif-tanpa-kode\">Alternatif tanpa kode (Make \/ Zapier \/ Pabbly)<\/h2>\n<p>Flow no\u2011code: Watch Google Sheets \u2192 HTTP request ke Search API \u2192 parse response \u2192 Update Sheets \u2192 Append CRM action. Keunggulan: cepat deploy tanpa dev; keterbatasan: biaya per task dan skalabilitas untuk batch besar. Referensi: <a href=\"https:\/\/www.pabbly.com\/integrating-new-leads-with-google-sheets-using-automation\/\">Pabbly integration<\/a>.<\/p>\n<h2 id=\"mapping-field-logika-bisnis-enrichment\">Mapping field &amp; logika bisnis enrichment<\/h2>\n<p>Contoh mapping: <code>industry<\/code> \u2192 CRM <em>sector<\/em>; <code>company_size<\/code> \u2192 <em>size<\/em>; <code>revenue_estimate<\/code> \u2192 <em>annual_revenue<\/em>. Aturan umum: overwrite hanya bila confidence\/score tinggi atau setelah review manual (gunakan threshold confidence sebagai kebijakan internal).<\/p>\n<h2 id=\"praktik-terbaik-keamanan\">Praktik terbaik &amp; keamanan<\/h2>\n<ul>\n<li>Batching &amp; rate limits: hormati rate limit provider; gunakan sleep\/retry (lihat <a href=\"https:\/\/www.youtube.com\/watch?v=gX_Ej8aUfXQ\">video<\/a>).<\/li>\n<li>Cache hasil di sheet kedua atau BigQuery untuk menghindari duplicate calls (referensi komunitas n8n).<\/li>\n<li>Simpan API key di <code>PropertiesService<\/code> (Apps Script) dan lindungi PII sesuai pedoman privasi.<\/li>\n<\/ul>\n<h2 id=\"pengujian-deployment-maintenance\">Pengujian, deployment &amp; maintenance<\/h2>\n<p>QA: mulai dengan sample 10 baris; hitung enriched vs failed; monitoring notifikasi (email\/Slack) untuk error log; backup sheet berkala. Lihat contoh praktik di <a href=\"https:\/\/www.linkup.so\/blog\/what-is-lead-enrichment-a-practical-guide-to-automation-in-2025\">LinkUp<\/a>.<\/p>\n<h2 id=\"integrasi-teknis-ke-appendix-crm\">Integrasi teknis ke Appendix CRM<\/h2>\n<p>Push payload JSON standar, mis. <code>{\"email\":\"...\",\"company_name\":\"...\"}<\/code>. Pertimbangkan webhook vs direct API sesuai SLA dan throughput. Panduan integrasi praktis tersedia di <a href=\"https:\/\/www.pabbly.com\/integrating-new-leads-with-google-sheets-using-automation\/\">Pabbly<\/a>.<\/p>\n<h2 id=\"contoh-hasil-yang-diharapkan\">Contoh hasil yang diharapkan<\/h2>\n<p>Outcome realistis: data completeness meningkat, prioritisasi outreach lebih cepat, time\u2011to\u2011contact berkurang. Contoh benefit dan hasil diuraikan oleh <a href=\"https:\/\/www.linkup.so\/blog\/what-is-lead-enrichment-a-practical-guide-to-automation-in-2025\">LinkUp<\/a> dan <a href=\"https:\/\/workspace.google.com\/marketplace\/app\/lead_enrichment_ai_sheet_capgoai\/739049508705\">CapGo.AI<\/a>.<\/p>\n<h2 id=\"resources-deliverables\">Resources &amp; deliverables (disertakan)<\/h2>\n<ul>\n<li>Google Sheets template (download) \u2014 struktur kolom siap pakai (<a href=\"https:\/\/www.linkup.so\/blog\/what-is-lead-enrichment-a-practical-guide-to-automation-in-2025\">LinkUp<\/a>).<\/li>\n<li>Google Apps Script sample code (dengan komentar) \u2014 <a href=\"https:\/\/inrealitysolutions.com\/id\/apps-script-automation-daily-report\/\">Apps Script sample<\/a>.<\/li>\n<li>Contoh Make\/Zapier screenshots &amp; checklist implementasi (referensi <a href=\"https:\/\/www.pabbly.com\/integrating-new-leads-with-google-sheets-using-automation\/\">Pabbly<\/a>).<\/li>\n<\/ul>\n<h2 id=\"mengapa-inreality-solutions-cocok\">Mengapa InReality Solutions cocok untuk proyek Anda<\/h2>\n<p>InReality Solutions menawarkan integrasi data &amp; otomasi end\u2011to\u2011end, pengalaman menggabungkan Agentic AI dan Otomasi Proses Bisnis (BPA) dengan integrasi CRM, fokus pada keamanan data &amp; kepatuhan, serta dukungan deployment dan monitoring sampai production. Layanan terkait: <a href=\"\/id\/layanan\/integrasi-data-otomasi\/\">Integrasi Data &amp; Otomasi<\/a>; studi kasus: <a href=\"\/id\/studi-kasus\/enrichment-retail\/\">Enrichment Retail<\/a>.<\/p>\n<h2 id=\"call-to-action-konsultasi-demo\">Call\u2011to\u2011Action \u2014 Konsultasi &amp; Demo Integrasi<\/h2>\n<p>Coba template POC hari ini atau booking demo konsultasi end\u2011to\u2011end dengan tim kami di <a href=\"\/id\/kontak\/konsultasi-otomasi\/\">kontak konsultasi<\/a>. Kami bantu setting POC 1 hari (sample 10\u201350 rows), mapping field, dan integrasi Append CRM.<\/p>\n<h2 id=\"ringkasan-next-steps\">Ringkasan &amp; next steps<\/h2>\n<ol>\n<li>Unduh template dan isi 10\u201350 baris untuk POC.<\/li>\n<li>Pilih provider enrichment &amp; ambil API key.<\/li>\n<li>Jalankan POC Apps Script atau no\u2011code workflow; prioritaskan batching, caching, dan proteksi API key.<\/li>\n<li>Hubungi kami untuk demo\/konsultasi jika butuh bantuan implementasi cepat.<\/li>\n<\/ol>\n<section id=\"faq\" class=\"faq\" aria-labelledby=\"faq-heading\">\n<h2 id=\"faq-heading\">FAQ<\/h2>\n<h3 id=\"tidak-ada-hasil-untuk-domain\">Q: Tidak ada hasil untuk domain?<\/h3>\n<p>A: Periksa typo pada domain, coba fallback ke <em>Search API<\/em> lain atau lakukan manual lookup; catat raw response untuk debugging. Referensi: <a href=\"https:\/\/www.linkup.so\/blog\/what-is-lead-enrichment-a-practical-guide-to-automation-in-2025\">LinkUp<\/a>.<\/p>\n<h3 id=\"terkena-rate-limit\">Q: Terkena rate limit?<\/h3>\n<p>A: Implementasikan retry dengan exponential backoff, kurangi batch size, dan cache hasil untuk menghindari panggilan ulang. Lihat praktik di <a href=\"https:\/\/www.youtube.com\/watch?v=gX_Ej8aUfXQ\">video<\/a>.<\/p>\n<h3 id=\"bagaimana-menyimpan-api-key\">Q: Bagaimana menyimpan API key dengan aman?<\/h3>\n<p>A: Simpan API key di <code>PropertiesService<\/code> (Apps Script) atau secrets manager di platform no\u2011code; jangan simpan di sheet yang dapat diakses publik.<\/p>\n<h3 id=\"bagaimana-melindungi-pii\">Q: Bagaimana melindungi PII dalam proses enrichment?<\/h3>\n<p>A: Batasi akses sheet, enkripsi data sensitif jika diperlukan, catat retention policy, dan pastikan vendor enrichment mematuhi kebijakan privasi yang relevan.<\/p>\n<h3 id=\"apakah-bisa-tanpa-kode\">Q: Apakah bisa tanpa menulis kode?<\/h3>\n<p>A: Ya\u2014gunakan Make\/Zapier\/Pabbly untuk alur Watch Sheets \u2192 HTTP request \u2192 Update Sheets \u2192 Push ke CRM. Keunggulannya cepat deploy, keterbatasan pada biaya per task dan batch besar.<\/p>\n<h3 id=\"berapa-besar-batch\">Q: Berapa besar batch yang direkomendasikan?<\/h3>\n<p>A: Praktik umum mulai dari batch 25\u201350 baris tergantung rate limit provider; uji bertahap dan pantau error\/rate limit.<\/p>\n<\/section>\n<\/article>","protected":false},"excerpt":{"rendered":"<p>Google Sheets Automation Lead Enrichment Google Sheets automation lead enrichment memungkinkan tim sales dan marketing memperkaya data prospek (firmographic dan contact enrichment) langsung dari Google Sheets\u2014mengurangi kerja manual dan mempercepat outreach\u2014hingga sheet ter-enrich yang siap dipush ke CRM seperti Append CRM atau disinkronkan berjadwal (harian\/mingguan) untuk proses berkelanjutan. Lihat juga contoh add-on CapGo.AI (Marketplace). Artikel [&hellip;]<\/p>","protected":false},"author":16,"featured_media":8091,"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-8067","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>Google Sheets Automation Lead Enrichment untuk Sales B2B<\/title>\n<meta name=\"description\" content=\"Otomasi lead enrichment langsung dari Google Sheets ke CRM. Panduan Apps Script &amp; no-code untuk sales B2B Indonesia.\" \/>\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\/google-sheets-automation-lead-enrichment\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Google Sheets Automation Lead Enrichment\" \/>\n<meta property=\"og:description\" content=\"Otomasi lead enrichment langsung dari Google Sheets ke CRM. Panduan Apps Script &amp; no-code untuk sales B2B Indonesia.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/inrealitysolutions.com\/id\/google-sheets-automation-lead-enrichment\/\" \/>\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-25T01:20:59+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-01-26T04:44:30+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2026\/01\/Prod-13.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\/google-sheets-automation-lead-enrichment\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/inrealitysolutions.com\/google-sheets-automation-lead-enrichment\/\"},\"author\":{\"name\":\"Maya Ananta\",\"@id\":\"https:\/\/inrealitysolutions.com\/id\/#\/schema\/person\/8bf31cc88af0e2066d9d0f57dd52a80a\"},\"headline\":\"Google Sheets Automation Lead Enrichment\",\"datePublished\":\"2026-01-25T01:20:59+00:00\",\"dateModified\":\"2026-01-26T04:44:30+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/inrealitysolutions.com\/google-sheets-automation-lead-enrichment\/\"},\"wordCount\":1157,\"publisher\":{\"@id\":\"https:\/\/inrealitysolutions.com\/id\/#organization\"},\"image\":{\"@id\":\"https:\/\/inrealitysolutions.com\/google-sheets-automation-lead-enrichment\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2026\/01\/Prod-13.jpg\",\"articleSection\":[\"AI Automations\"],\"inLanguage\":\"id\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/inrealitysolutions.com\/google-sheets-automation-lead-enrichment\/\",\"url\":\"https:\/\/inrealitysolutions.com\/google-sheets-automation-lead-enrichment\/\",\"name\":\"Google Sheets Automation Lead Enrichment untuk Sales B2B\",\"isPartOf\":{\"@id\":\"https:\/\/inrealitysolutions.com\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/inrealitysolutions.com\/google-sheets-automation-lead-enrichment\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/inrealitysolutions.com\/google-sheets-automation-lead-enrichment\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2026\/01\/Prod-13.jpg\",\"datePublished\":\"2026-01-25T01:20:59+00:00\",\"dateModified\":\"2026-01-26T04:44:30+00:00\",\"description\":\"Otomasi lead enrichment langsung dari Google Sheets ke CRM. Panduan Apps Script & no-code untuk sales B2B Indonesia.\",\"breadcrumb\":{\"@id\":\"https:\/\/inrealitysolutions.com\/google-sheets-automation-lead-enrichment\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/inrealitysolutions.com\/google-sheets-automation-lead-enrichment\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/inrealitysolutions.com\/google-sheets-automation-lead-enrichment\/#primaryimage\",\"url\":\"https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2026\/01\/Prod-13.jpg\",\"contentUrl\":\"https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2026\/01\/Prod-13.jpg\",\"width\":1080,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/inrealitysolutions.com\/google-sheets-automation-lead-enrichment\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/inrealitysolutions.com\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Google Sheets Automation Lead Enrichment\"}]},{\"@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":"Google Sheets Automation Lead Enrichment untuk Sales B2B","description":"Otomasi lead enrichment langsung dari Google Sheets ke CRM. Panduan Apps Script & no-code untuk sales B2B Indonesia.","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\/google-sheets-automation-lead-enrichment\/","og_locale":"id_ID","og_type":"article","og_title":"Google Sheets Automation Lead Enrichment","og_description":"Otomasi lead enrichment langsung dari Google Sheets ke CRM. Panduan Apps Script & no-code untuk sales B2B Indonesia.","og_url":"https:\/\/inrealitysolutions.com\/id\/google-sheets-automation-lead-enrichment\/","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-25T01:20:59+00:00","article_modified_time":"2026-01-26T04:44:30+00:00","og_image":[{"width":1080,"height":1080,"url":"https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2026\/01\/Prod-13.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\/google-sheets-automation-lead-enrichment\/#article","isPartOf":{"@id":"https:\/\/inrealitysolutions.com\/google-sheets-automation-lead-enrichment\/"},"author":{"name":"Maya Ananta","@id":"https:\/\/inrealitysolutions.com\/id\/#\/schema\/person\/8bf31cc88af0e2066d9d0f57dd52a80a"},"headline":"Google Sheets Automation Lead Enrichment","datePublished":"2026-01-25T01:20:59+00:00","dateModified":"2026-01-26T04:44:30+00:00","mainEntityOfPage":{"@id":"https:\/\/inrealitysolutions.com\/google-sheets-automation-lead-enrichment\/"},"wordCount":1157,"publisher":{"@id":"https:\/\/inrealitysolutions.com\/id\/#organization"},"image":{"@id":"https:\/\/inrealitysolutions.com\/google-sheets-automation-lead-enrichment\/#primaryimage"},"thumbnailUrl":"https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2026\/01\/Prod-13.jpg","articleSection":["AI Automations"],"inLanguage":"id"},{"@type":"WebPage","@id":"https:\/\/inrealitysolutions.com\/google-sheets-automation-lead-enrichment\/","url":"https:\/\/inrealitysolutions.com\/google-sheets-automation-lead-enrichment\/","name":"Google Sheets Automation Lead Enrichment untuk Sales B2B","isPartOf":{"@id":"https:\/\/inrealitysolutions.com\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/inrealitysolutions.com\/google-sheets-automation-lead-enrichment\/#primaryimage"},"image":{"@id":"https:\/\/inrealitysolutions.com\/google-sheets-automation-lead-enrichment\/#primaryimage"},"thumbnailUrl":"https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2026\/01\/Prod-13.jpg","datePublished":"2026-01-25T01:20:59+00:00","dateModified":"2026-01-26T04:44:30+00:00","description":"Otomasi lead enrichment langsung dari Google Sheets ke CRM. Panduan Apps Script & no-code untuk sales B2B Indonesia.","breadcrumb":{"@id":"https:\/\/inrealitysolutions.com\/google-sheets-automation-lead-enrichment\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/inrealitysolutions.com\/google-sheets-automation-lead-enrichment\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/inrealitysolutions.com\/google-sheets-automation-lead-enrichment\/#primaryimage","url":"https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2026\/01\/Prod-13.jpg","contentUrl":"https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2026\/01\/Prod-13.jpg","width":1080,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/inrealitysolutions.com\/google-sheets-automation-lead-enrichment\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/inrealitysolutions.com\/id\/"},{"@type":"ListItem","position":2,"name":"Google Sheets Automation Lead Enrichment"}]},{"@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-13.jpg",1080,1080,false],"thumbnail":["https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2026\/01\/Prod-13-150x150.jpg",150,150,true],"medium":["https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2026\/01\/Prod-13-300x300.jpg",300,300,true],"medium_large":["https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2026\/01\/Prod-13-768x768.jpg",768,768,true],"large":["https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2026\/01\/Prod-13-1024x1024.jpg",1024,1024,true],"1536x1536":["https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2026\/01\/Prod-13.jpg",1080,1080,false],"2048x2048":["https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2026\/01\/Prod-13.jpg",1080,1080,false],"trp-custom-language-flag":["https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2026\/01\/Prod-13-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":"Google Sheets Automation Lead Enrichment Google Sheets automation lead enrichment memungkinkan tim sales dan marketing memperkaya data prospek (firmographic dan contact enrichment) langsung dari Google Sheets\u2014mengurangi kerja manual dan mempercepat outreach\u2014hingga sheet ter-enrich yang siap dipush ke CRM seperti Append CRM atau disinkronkan berjadwal (harian\/mingguan) untuk proses berkelanjutan. Lihat juga contoh add-on CapGo.AI (Marketplace). Artikel&hellip;","_links":{"self":[{"href":"https:\/\/inrealitysolutions.com\/id\/wp-json\/wp\/v2\/posts\/8067","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=8067"}],"version-history":[{"count":2,"href":"https:\/\/inrealitysolutions.com\/id\/wp-json\/wp\/v2\/posts\/8067\/revisions"}],"predecessor-version":[{"id":8092,"href":"https:\/\/inrealitysolutions.com\/id\/wp-json\/wp\/v2\/posts\/8067\/revisions\/8092"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/inrealitysolutions.com\/id\/wp-json\/wp\/v2\/media\/8091"}],"wp:attachment":[{"href":"https:\/\/inrealitysolutions.com\/id\/wp-json\/wp\/v2\/media?parent=8067"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/inrealitysolutions.com\/id\/wp-json\/wp\/v2\/categories?post=8067"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/inrealitysolutions.com\/id\/wp-json\/wp\/v2\/tags?post=8067"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}