I am owner of Google group, where I comunicate with customers. The customers are not members of the group, we just email up and forth through the group. I need somehow to export the email adress of those customers to spreadsheet, ideally Google spreadsheet.....This tool can be script, software with API, or Google engine app, etc....whatever will work to accomplish this.
So : I created TEST group, with 2 topics sent from 2 different customers email addresses. I expect the tool /script to connect to this group, and retrieve the 2 emails from the 2 topics. The Google spreadsheet should show then those 2 emails. Obviously this is for explanation only what the script should do. In real world we will connect this script to group with loads of topics and loads of emails. Group for test is https://groups.google.com/a/ledeco.sk/forum/?hl=sk#!forum/test
Owner credentials should be created in safe-way, with credentials not entering to code.
Security : Only owner(any) of the The group should be able to run this script. Apart that, we own several different groups so we should be able to change some ID/name of the group and run the script individually on different groups we are owners. Ideal would be a list of available groups we are owner of, selecting which will the script run on.
The spreadsheet used for the results will be always a single document, script will add ONLY the records which are not allready in the spreadsheet (script should compare the retrieved email addresses with the existing records in the spreadsheet allready entered from previous attempts.
Script should be hosted in Google engine/code enviroment, after all done we will require the ownership of the script to be transfered to my account. Hope all is clear.
11 freelancers are bidding on average €195 for this job