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.

  • You can export your contacts to CSV. Have you tried that? Spreadsheets can then import it. You'd just need to clean it up.
    – ale
    Commented May 15, 2013 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
    Commented May 15, 2013 at 14:17
  • That, I can't help with. (Which is why I just left a comment.)
    – ale
    Commented May 15, 2013 at 14:47
  • While questions about using Google Sheets and Google Apps Script are on-topic, questions about the Google Sheets API are off-topic on this site. It's not clear what you mean by getIM(). You might add a minimum complete verifiable example, be detailed about what you found developers.google.com/apps-script and why it doesn't meet your needs. Commented Apr 25, 2023 at 18:32

1 Answer 1


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.

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