Skip to main content

ChatGPT: Export METADATA Inbox of Gmail/GMAIL INBOX METADATA (To field | From field | CC field | Reply-to field | BCC field | Subject Line | Message Body) via GOOGLE SHEETS

#

Cara lengkap & paling cepat untuk EXPORT inbox Gmail → CSV (Sender + Subject) menggunakan Google Sheets + Gmail Add-on “Gmail Extractor”.

Saya buat step-by-step, tanpa ribet, langsung jadi CSV.

✅ EXPORT INBOX GMAIL ke CSV dengan Gmail Extractor

1. Buka Google Sheets

Masuk ke:

👉 https://sheets.google.com

Buat Spreadsheet baru.

2. Install Add-on “Gmail Extractor”

Di menu Google Sheets:

  1. Extensions → Add-ons → Get add-ons

  2. Cari: “Gmail Extractor” → Email Address Extractor by Digital Inspiration

  3. Klik Install

  4. Beri akses Gmail & Sheets

Add-on ini aman & hanya membaca metadata email.

3. Jalankan Gmail Extractor

Setelah instal:

  1. Buka menu:
    Extensions → Gmail Extractor: Email Address Extractor 

  2.  → Open App → Create Workflow

  3. Panel akan muncul di kanan.

4. Menu Email Address Extractor

1. Gmail Search
2. Configuration
3. Save & Run

4.1 Tentukan Folder Gmail yang Mau Diekspor

aka Gmail Search

Di panel Gmail Extractor, pilih:

  • Inbox → (untuk semua email yang masuk)

  • All Mail → (jika ingin lengkap)

  • Label tertentu → misalnya work, youtube, dll.


4.2 Pilih Field yang Diekspor

aka Configuration

Centang opsi:

Jika hanya ingin dua kolom:

  • From

  • Subject

Biarkan field lain OFF.


4.3 Extract to Sheet aka Save & Run: Workflow

Add-on akan langsung menulis data di Google Sheets:

CONTOH HASIL
Date Link From To Cc Body
15/08 16:20 Instructor: Mie Gacoan dan FlyBest Training Center merekrut peran di area Anda Andreas Tommy Parlaungan Manurung
evercossdreas85@gmail.com
16/08 11:08 Lihat apa yang baru evercossdreas85@gmail.com evercossdreas85@gmail.com
18/08 09:13 🏀 NBA akan hadir di Prime Video! evercossdreas85@gmail.com evercossdreas85@gmail.com
18/08 11:23 Menunggu Pembayaran BCA Virtual Account Untuk Pesanan di Alfagift (#O-250818-AGRNYDF) evercossdreas85@gmail.com alfacare@sat.co.id
18/08 11:23 Pembayaran Pesanan (#O-250818-AGRNYDF) Diterima evercossdreas85@gmail.com alfacare@sat.co.id
19/08 10:00 3 key strategies for profitable chemicals operations Reena Bayley
r.bayley@reply.aveva.com		 evercossdreas85@gmail.com evercossdreas85@gmail.com
19/08 16:20 Instructor: SEVEN Retail Group dan kejarcita.id sedang membuka lowongan Andreas Tommy Parlaungan Manurung
evercossdreas85@gmail.com
21/08 19:08 Anda muncul di dalam 1 pencarian Andreas Tommy Parlaungan Manurung
evercossdreas85@gmail.com
22/08 09:25 Hore! Kamu mendapatkan voucher [Kuota Terbatas] WiZ Lighting - Diskon Hingga 40rb evercossdreas85@gmail.com evercossdreas85@gmail.com
customer.care@blibli.com

5. Export ke CSV

Di menu Google Sheets:

File → Download → Comma Separated Values (.csv)

➡ SELESAI!
Anda sekarang punya CSV lengkap (Sender + Subject).

Comments

Post a Comment

Popular posts from this blog

[ERROR BUG]
ChatGPT+Gemini: TikTok → Blogger Embed Converter using Cloudflare/Online Server

🔄 Refresh Page ERROR BUG: The connection is blocked because it was initiated by a public page to connect to devices or servers on your local network. Planning: Revise Program CODE Code USING Javascript/Online Server Code NOT USING Javascript Sample Working Code aka Already Repaired! Temporary Solution is by Asking AI Assistant to do REPAIR CODE of (Not yet Repaired) Current Conversion Program Code-Output TikTok Archive – Embedded Preview TikTok Embed ▶ View this video on TikTok ⚠️ DISCLAIMER: INPUT URL LIMITATION This program is currently restricted to processing Full Browser URLs only. It does not support TikTok’s mobile "short-link" format (e.g., vt.tiktok.com ). Required Action: Users must open the video in a web browser and copy the expanded URL from the address bar before pasting it into this program. URL Conversion Example ❌ UNSUPPORTED: https://vt.tiktok.com/ZSaXoFyov/ ✅ REQ...
Post a Comment
Read more

Repost! Web-Based to Android Apps Convertion (MEDIAN.CO etc.)

CONTOH HASIL Android APK "PROGRAM" SAMPLE: Youtube and Instagram EMBEDded to Blogger/Blogspot.com SOURCE CODE Click this box to download Contoh Sample SHORTCUT-APPs "precise" click to download : median.co R8: ronin1985.blogspot.com R2M: ronin-manu.blogspot.com Gw udah coba Median.co utk mengubah Website gw menjadi Aplikasi Android Keren bet!! Median.co Cekidot Software lain yg mirip! ChatGPT : If you're looking for tools similar to Median.co to convert websites into Android apps, here are some top alternatives, especially for no-code or low-code users: 🔧 Best Tools Like Median.co to Convert Website to Android Apps 1. WebViewGold Platform: Windows/macOS (Xcode/Android Studio) Key Feature: Converts any website into iOS/Android app via WebView. Pros: One-time purchase Custom splash screen, push notifications Can open external links in external browser Cons:  Requi...
Post a Comment
Read more

REPOST: Studying WATER PUMP by ROMAN ENGINEERING

*^ Ini yg Asli Gan! Mekanisme pada Concrete Pump: Kok ky Sistem Mekanik Romawi ya?! Tapi malah bisa HANYA pake PER aka bukan "MATA BOR look a like" Mekanisme Drill yg Cost Pembuatan bikin REPOT aka harus Tool SUPER Khusus Dari Material Besi yg digunakan terlihat langsung secara kasat mata Jauh Lebih Banyak drpd Per Biasa seperti yg ditunjukkan pd Video Alternatif dgn Penggunaan PER Video dr Instagram: Source: YouTube Rome's drainage machines #history #romanempire #engineering
Post a Comment
Read more