Purpose : This app will extract the sender address from last 50 emails that are labelled as "Contact" and save it in a spreadsheet…

Latest Version

Version
2
Update
February 21, 2017
Size
7.16KiB
Developer
pratyush.info
Category
Users
3
Rating
0 ★
Manifest Version
2
Web Store Status
Languages Support
English
See more
Permissions
See more

Export contacts to google sheet Application

Purpose : This app will extract the sender address from last 50 emails that are labelled as \"Contact\" and save it in a spreadsheet in your google drive. All the threads scanned will be labelled as \"Scanned\". It will also check for duplicates and save only new contacts.

Benefit: The contacts can be exported from the spreadsheet in CSV, TSV etc. and can be used to add them in a subscriber / mailing list, send invites etc.

How to use it:
You need to do 3 things.
1. Label some emails as \"Contact\". You can do that manually or use the filters in Gmail.
2. Create a sub-label called \"Scanned\" under the \"Contacts\" label.
3. Create a spreadsheet file called \"contactemails\" in your drive in any folder of your choice.

Run the app from the app drawer when you are ready. The file named \"contactemails\" will be populated with the relevant email addresses.

PS: Take care of the letter case.
PPS: This is an open source software and the code is available here :-
https://github.com/pratyush272/Gmail-Exporter
Read more

Source Manifest.json

{
"update_url": "https://clients2.google.com/service/update2/crx",
"name":"Export contacts to google sheet",
"description":"",
"version":"2",
"manifest_version":2,
"app":{"urls":["https://script.google.com/macros/s/AKfycbxg3NddpaHNFlc3NL_BLT59SUZEjNTUnO_cm_fFEMUdnUq0tTQ/exec"],
"launch":{"web_url":"https://script.google.com/macros/s/AKfycbxg3NddpaHNFlc3NL_BLT59SUZEjNTUnO_cm_fFEMUdnUq0tTQ/exec"}},
"icons":{"128":"script-icon_128.png"}}
Read more