Web Applications Stack Exchange is a question and answer site for power users of web applications. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

I don't think there is a way to do this using the methods of ContactsApp in Google Apps Script. But you can use Google+ API to search, e.g., by email address; this can be done in any language, including JavaScript (the documentation page has sample code and a form you can use to try out this search, so I'm not giving details here).

This will only find people with a public Google+ profile, but this is probably inevitable: after all, just having someone's email address shouldn't entitle you to find out whether they have a Google account that they wish to keep private.

share|improve this answer

Your Answer


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

Not the answer you're looking for? Browse other questions tagged or ask your own question.