Case study
Your spreadsheet, on your phone.
Contact Sync is a web app that syncs a Google Sheet to Google Contacts. If your organization keeps a spreadsheet of people—names, emails, phone numbers, sometimes two numbers per person—Contact Sync can put them on your phone in about a minute.
- Scope
- Design, build, deploy — a tool that does one thing well
- Stack
- Python · Flask · Google OAuth · self-hosted
- Audience
- Anyone whose contacts live in a spreadsheet
Your spreadsheet and your phone aren't talking
Google lets you keep a contact list in a Google Sheet. It also lets you keep a contact list in Google Contacts. But Google has no feature that syncs the two. So the spreadsheet stays current while the contacts on your phone fall behind.
When someone calls, your phone might not tell you who it is, even if their number is sitting right there in the spreadsheet. Contact Sync connects the two. You sign in with Google, pick the sheet, and it maps the columns automatically—it knows that a column called Cell is a phone number. Before it changes anything, it shows you a preview of which contacts will be created, updated or skipped.
John Smith vs. Smith, John
The same person can show up as "Smith, John" in your spreadsheet and "John Smith" in Google Contacts. A simple sync would create a duplicate. Contact Sync matches by email first. If there's no email match, it uses fuzzy name matching—it handles reversed names—and the organization field to break ties.
When a match is uncertain, Contact Sync doesn't pick one on its own. Borderline matches go into a review queue, where the top candidates are shown side by side and a person decides which is correct. Confident matches sync automatically. Ambiguous ones wait for you. The idea is to automate the cases that are certain, and show the uncertain ones to a human.
Contact Sync is live at contactsync.clapp.me. It's free to use, and it's built to respect your data and your time.
Start your project