Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

I'm looking for a way I could:

retrieve a list of all my contacts and their email's and

In order to retrieve a list of all of my contacts into a Google spreadsheet, I exported them as a Google CSV and then imported them into a new spreadsheet.

Determine if the contact is a Google account

Is there a function in the Google spreadsheet api that can determine if the contact is a Google account or not? getIM() is the only one I saw that might be able to do this.

share|improve this question
You can export your contacts to CSV. Have you tried that? Spreadsheets can then import it. You'd just need to clean it up. –  Al E. May 15 '13 at 14:00
That works great for getting a list of my contacts. Part 1 solved! From here, any ideas on how to determine is the contact is a Google account? Not sure if there is some function I can call. –  jredeker May 15 '13 at 14:17
That, I can't help with. (Which is why I just left a comment.) –  Al E. May 15 '13 at 14:47

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.