Purpose : This app will extract the sender address from last 50 emails that are labelled as "Contact" and save it in a spreadsheet…
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
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
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
"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"}}