Manage Google Mobile Contacts using Google Spreadsheet (Free Tool)

  • 4

Google Mobile Contacts management with google sheets

You can sync your Google Mobile Contacts with Google Contacts. What if you could sync Google Contacts with Google Spreadsheet. Yes, two-way sync between Google Contacts and Google Spreadsheet.
All of us face this problem or organising our contacts. Many new year resolutions have been wasted in this pursuit. Organising contacts on Mobile is very very tedious and cumbersome. Managing them on Google Contacts App can be little relaxing, but obviously not the most preferred way of doing it.

What if we could manage and organise all our contacts on a spreadsheet. All of us are very good in handling large data spreadsheets and organising it.

Benefits of Managing Google Mobile Contacts in Google Spreadsheet

  • It is much easier to manage a large volume of contacts in Spreadsheet. Faster, easier and much more effective than doing it in Google Contacts Apps.
  •  G-Sync offers two-way sync, which means your newly added contacts also appear in your spreadsheet.
  • Use Google Contact groups wisely and effectively. Groups can be used to categorise and classify your contacts into prospects, customers, friends, relatives, family, suppliers etc.
  • Grouping can be used to send group Emails or group SMS to all of the members of a group.
  • Arranging and managing addresses and other fields is much easier in a spreadsheet.
  • Finding duplicates and managing them

We have created a Free tool called Enjay GSync Tool. This is a Google Spreadsheet script which syncs Google Contacts and Google Spreadsheet. It’s a two-way sync tool. We have also created a video which explains best practices and tips and tricks.

Please click here to get the free tool.

Here is the video which explains the entire process step by step.

Please click here to get the free tool.

User Review
5 (1 vote)

  • 4


  1. Anantha Iyer

    Cool tool. Very Useful

  2. Pramod Dalmia

    Kya baat Limesh bhai.
    Too simple.
    Too good.

  3. R R PAI


  4. Conrad

    Thanks so much for the blog article. Much obliged.

  5. sanjay

    if i use this tool. my contact will display to you also is it right

    • enjayitadmin

      No Mr Sanjay, our tool does not send any records to us. BTW, the source code is also included with our tool, it’s absolutely clean. This is not data collection trap.

  6. Matthew Graham

    This tool looks great! I can’t wait to try it out. I click to download, and then fill in my information, and it redirects me to the blog rather than allowing me to download. I have not received any email with the link, and the link in the video doesn’t work either. (Assuming I didn’t mistype it)

  7. Save on electricity

    Thanks for sharing such a good opinion, article is fastidious, thats why i
    have read it fully

  8. Alex


    Thank you for the amazing tool. I’m getting the following error as I run ‘Get Contacts’ after allowing the permissions. How can this be resolved? Would appreciate the help to get this working!

    { “error”: { “code”: 429, “message”: “Quota exceeded for quota group ‘default’ and limit ‘USER-100s’ of service ‘contacts.googleapis.com’ for consumer ‘project_number:83316283190’.”, “status”: “RESOURCE_EXHAUSTED”, “details”: [ { “@type”: “type.googleapis.com/google.rpc.Help”, “links”: [ { “description”: “Google developer console API key”, “url”: “https://console.developers.google.com/project/83316283190/apiui/credential” } ] } ] }

  9. Freddy Zapata

    Enjay, I have a form collecting contact information and the form saves the name in a google sheet called “Contact.csv” (which is the file updated every time a new Contact is collected from new customer coming to the office). How do I get the “Enjay GSync” script to execute/run every time the “Contact.csv” file is updated?

  10. hadian

    thank you for that tools..

    but i got error sometimes :
    { “error”: { “code”: 429, “message”: “Quota exceeded for quota group ‘default’ and limit ‘USER-100s’ of service ‘contacts.googleapis.com’ for consumer ‘project_number:17165283202’.”, “status”: “RESOURCE_EXHAUSTED”, “details”: [ { “@type”: “type.googleapis.com/google.rpc.Help”, “links”: [ { “description”: “Google developer console API key”, “url”: “https://console.developers.google.com/project/17165283202/apiui/credential” } ] } ] } }

    how to avoid that ?


  11. Roger

    Thanks for the marvelous posting! I really enjoyed reading it, you may be a great author.I will be sure to bookmark your blog and will eventually come back from now on.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>