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.
Click here to get the free tool
Here is the video which explains the entire process step by step.
27 Comments
Cool tool. Very Useful
Thanks Anantha Iyer, I hope that our tool helped you to organise your address book.
Kya baat Limesh bhai.
Too simple.
Too good.
Thanks a lot, Pramod Dalmia. Hope you were able to utilise the tool to its fullest.
CAN THIS ARRANGEMENT HELP IN DEDUPLICATION OF NUMBERS?
Dear Mr Pai, of course, de-duplication becomes extremely easy since you are managing everything in Spreadsheet.
Thanks so much for the blog article. Much obliged.
expressit.xyz
if i use this tool. my contact will display to you also is it right
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.
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)
Thanks for sharing such a good opinion, article is fastidious, thats why i
have read it fully
Hi
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” } ] } ] }
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?
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 ?
thanks
Could you drop an email on support@enjayworld.com
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.
Appreciate the recommendation. Will try it out.
Hey! Would you mind if I share your blog with my zynga group?
There’s a lot of people that I think would really enjoy your content.
Please let me know. Many thanks
Yes you can
Great article! We are linking to this great article
on our site. Keep up the good writing.
I’m not that much of a online reader to be honest but your blogs really nice, keep it up!
I’ll go ahead and bookmark your site to come back in the future.
Cheers
This blog was… how do you say it? Relevant!!
Finally I’ve found something which helped me. Cheers!
It’s an remarkable post for all the internet users; they
will get benefit from it I am sure.
Somebody essentially assist to make significantly posts I’d state.
This is the very first time I frequented your website page and to this point?
I amazed with the research you made to create this actual publish extraordinary.
Magnificent process!
Hi, Mr. Limesh Parekh
Thank you for your tools. I would like to try it. Hope it could be worked.
Hary
Dear Harry,
We are glad that you are looking forward to trying it and do share your response.
Activate Nbc
I’m not so quite a bit of an online peruser to be completely forthright yet your
writes extremely pleasant, keep it up! I’ll proceed and bookmark your site to
return later on. Good wishes
Did you find this review helpful? Yes No