6 Ways to Automate Google Contacts in 2026, Free and Paid

Stop typing contacts in by hand. Let Google save and sync them, import a CSV, turn bookings and forms into contacts, back them up and script the rest.

The Merlin team11 min read

You can automate Google Contacts in six ways: let Google save the people you email and sync your phone's contacts, bulk-add people with a CSV import, turn bookings and form replies into contacts with Zapier, keep a Google Sheet and your contacts in step, back the list up on a schedule, and write a free Apps Script for anything else. The first two cost nothing and take a few minutes.

An address book only stays useful if new people get into it without you stopping to type. The client who booked a call, the person who filled in your form, the number someone read out over the phone: each one is a small chore, and small chores are the ones that slip. Below are the six setups, what each costs, the limits Google sets, and the one job you still have to do by hand.

Six ways to automate Google Contacts, compared

Method

What it does

Cost

Setup time

Google's own saving and sync

Saves people you email; backs up Android contacts; syncs to iPhone

Free

Minutes

CSV import

Adds hundreds of people, with labels, in one go

Free

Minutes

Zapier from bookings and forms

Creates a contact for each Calendly booking or Google Forms reply

Free tier covers 100 tasks monthly

15 minutes

Sheet and contacts kept in step

Turns rows in Google Sheets into contacts

Zapier, or free with Apps Script

15 to 30 minutes

Scheduled backup

Copies each new contact into a sheet, plus a CSV export

Free

10 minutes

Apps Script

Your own rules, on a timer

Free

30 minutes or more

1. Let Google save and sync contacts for you

Google already saves contact details from your Gmail, sharing and calendar activity into a list called Other contacts, when the setting Save contact info when you interact with people is on, per Google's Account help page. You'll find it at myaccount.google.com under People & sharing, then Contact info saved from interactions. Gmail has its own switch too: in Gmail's settings, the Create contacts for auto-complete section lets you choose I'll add contacts myself instead.

Other contacts power autocomplete, but they aren't your real address book. Google's help page on adding contacts notes that you can see them only at contacts.google.com, under Other contacts on the left; phones and tablets don't show them. So when someone becomes a regular, open them there and add them to your contacts properly.

Back up an Android phone's contacts automatically

Android can save every contact you add on the phone as a Google contact. These steps follow Google's backup guide:

  1. Open Settings on the phone and tap your profile photo, then All services (or Settings > Google > All services).
  2. Under Backup & restore, tap Google Contacts sync.
  3. Pick the Google account to save to, then tap View settings.
  4. Under Sync options, turn on Backup device-only & SIM contacts automatically.

Two catches from the same page: it works with one Google account only, and it can't back up to a work or school (Google Workspace) account or a child's account. Contacts from Exchange or Yahoo aren't saved either.

Sync Google Contacts to an iPhone

On Apple's phones and tablets, add your Google account under Settings > Contacts > Accounts > Add account > Google, then switch on Contacts for it, as Google's sync guide describes. New contacts you save to that account on the phone land in Google Contacts too. When I moved to a new phone, the contacts that came across without any work were the ones already in my Google account, which is the whole argument for this step.

2. Bulk-add contacts with a CSV import

A CSV import adds many contacts at once and can put them on labels in the same step. At contacts.google.com, click Import on the left, then Select file, choose a .csv or .vcf file and click Import, per Google's import guide. Google offers a sample template you copy, fill in one row per person and download as Comma Separated Values (.csv).

  • Keep the header row. Google's guide says the headers are what send each value to the right field.
  • Label people as you import. The template has a Labels column, and several labels go in one cell separated by ":::".
  • Stay under 3,000 rows a file. That's Google's limit per import; split bigger lists into several files.
  • Mind the 25,000 cap. That's the limit for the whole account.

This is the method for a pile of people from one place: a conference badge scan, an old spreadsheet, a list a colleague handed over. After an event, I put everyone on a label named for it, like "Spring summit 2026", so I can find that group in one click a year later. If a detail goes missing after an import, Google suggests checking the contact's Notes, where unmatched columns can end up.

3. Turn bookings and form replies into contacts with Zapier

Zapier can create a Google contact each time someone books a meeting or fills in a form, so nobody reaches your calendar or inbox without also reaching your address book. Google Contacts on Zapier has actions including Create Contact, Update Contact, Find or Create Contact and Add Contact to Groups, listed on Zapier's Google Contacts page. Groups are what Google Contacts calls labels.

From Calendly bookings

  1. In Zapier, start a Zap with Calendly and the trigger Invitee Created or Rescheduled, one of the Calendly events on Zapier's Calendly and Google Contacts page.
  2. Connect your Calendly account and test the trigger with a recent booking.
  3. Add Google Contacts with the action Find or Create Contact, so a repeat booker isn't saved twice.
  4. Map the invitee's name and email, and the phone number if your booking form asks for one.
  5. Test with a booking of your own, then publish.

Zapier's page marks some Calendly triggers, like Contact Created, as needing a paid Calendly plan. Invitee Created or Rescheduled isn't one of them.

From Google Forms replies

The same pattern works with Google Forms: use the trigger New Form Response and the action Find or Create Contact, both on Zapier's Google Forms and Google Contacts page. A sign-up sheet for a workshop or a client intake form is the obvious fit. Ask for the email in its own question, so the Zap has a clean field to map.

What it costs

On Zapier's free tier you get 100 tasks each month, Zaps limited to a trigger plus one action, and a 15-minute wait between checks, per Zapier's pricing page. Triggers never use tasks, and Zapier's task guide says a search step only uses one when it's set to carry on if nothing is found, so a booking Zap like this costs about one task per new person. Putting each person on a label with Add Contact to Groups as well means a third step, which needs Zapier's Professional tier: $239.88 a year paid annually, or $29.99 for each month if you pay monthly.

4. Keep a Google Sheet and Google Contacts in step

A Google Sheet makes a good inbox for contacts: you can fill it in from a laptop, share it with an assistant, or paste in a list. To turn rows into contacts, start a Zap with Google Sheets and the trigger New Spreadsheet Row, or New or Updated Spreadsheet Row if edits should carry over, both on Zapier's Google Sheets page. Then add Google Contacts with Find or Create Contact, or Update Contact for changes.

I keep a tab called "New people" with five columns: first name, last name, email, phone, status. Typing a row on my laptop after a call is quicker than finding the right field on my phone, and the sheet doubles as a record of when I met each person. If you'd rather not pay per task, method 6 below does this exact job for free with a short script.

Updates can overwrite good data

With New or Updated Spreadsheet Row, every edit to the sheet can rewrite the matching contact. If you tidy someone's details in Google Contacts and the sheet still holds the old ones, the next edit to that row can bring the old ones back. Pick one place as the source of truth and edit only there.

5. Back up Google Contacts on a schedule

The simplest backup is a Google CSV export. Select your contacts at contacts.google.com (tick one, then Selection Actions > All), open More actions, choose Export, pick Google CSV and click Export, as Google's export guide describes. Google's guide only covers doing this by hand, so put a monthly reminder on your calendar.

For a running copy between exports, a Zap with the Google Contacts trigger New Contact and the Google Sheets action Create Spreadsheet Row adds each new contact to a sheet as it's saved. Both steps are on Zapier's Google Sheets page, and it fits on the free plan.

Google also has a safety net of its own. A deleted contact waits a month (30 days) in Trash before it's gone, and Settings > Undo changes rolls the whole list back to any point in the past 30 days, per Google's edit and delete page. Undo is blunt, though: it hides contacts added after the time you pick, so Google suggests exporting first. Before I let any new Zap write to my address book, I export a Google CSV, so a bad field mapping costs me nothing worse than a re-import.

6. Write your own Google Contacts automation with Apps Script

Apps Script, Google's built-in scripting tool, can create and read contacts for free through the People advanced service, which calls the People API on your own contacts, per Google's People service guide. Paired with a time-driven trigger, a script can turn new sheet rows into contacts every hour without Zapier.

Set it up

  1. Open your contacts sheet in Google Sheets and click Extensions > Apps Script.
  2. In the editor, next to Services, click Add a service, choose People API and click Add, as Google's advanced services guide shows.
  3. Paste the script below in place of the sample code and save.
  4. Click Run once and approve the permissions Google asks for. The script needs access to your contacts.
  5. On the left, click Triggers, then Add Trigger, choose addNewPeople, pick Time-driven and an hourly timer, and click Save.
New people to Google Contacts (Apps Script)
// Adds a Google contact for each new row in the "New people" tab.
// Columns: A First name, B Last name, C Email, D Phone, E Status
function addNewPeople() {
  const sheet = SpreadsheetApp.getActive().getSheetByName("New people");
  const rows = sheet.getDataRange().getValues();
  for (let i = 1; i < rows.length; i++) {
    const [first, last, email, phone, status] = rows[i];
    if (!first || status === "Added") continue;
    const person = { names: [{ givenName: first, familyName: last }] };
    if (email) person.emailAddresses = [{ value: email }];
    if (phone) person.phoneNumbers = [{ value: String(phone) }];
    People.People.createContact(person);
    sheet.getRange(i + 1, 5).setValue("Added");
  }
}

The script reads the "New people" tab, skips rows without a first name or already marked "Added", creates each contact with the People API's createContact method, and writes "Added" in column E so it never saves anyone twice. It sends one request at a time, which is what Google's reference asks for when many changes go to one account. Time-driven triggers can run from every minute to once a month, and Google may shift the run time within the hour, per its trigger guide.

Test it on two or three rows with your own details before you add real people. Scripts don't have a preview step, so a wrong column means wrong contacts, and the undo above is your way back.

What you can't automate: merging duplicates

Google Contacts finds duplicates for you but won't merge them on its own. Open the menu at contacts.google.com and choose Merge & fix; you'll see suggestions to accept one by one with Merge, or all at once with Merge all, per Google's merge guide. You can't merge contacts saved in different Google accounts.

Every automation above adds people faster, so duplicates come faster too, usually one person saved twice under two different email addresses. A quick pass through Merge & fix every couple of weeks keeps it manageable. It's also the reason the Zaps above use Find or Create Contact rather than Create Contact.

Which Google Contacts automation should you set up first?

Start with what's free and already built in, then add the paid layer only where people slip through.

  • Everyone: turn on phone sync (Android backup or the iPhone account) and export a Google CSV today.
  • You take bookings or run forms: add the Calendly or Google Forms Zap. It's the one that catches people you'd otherwise never save.
  • You collect people in bulk: use CSV imports with a label per batch.
  • You're comfortable pasting code: use the Apps Script instead of a Sheets Zap and keep the money.
  • Your list feeds a mailing: a label in Google Contacts works as a group in Gmail (Google's label guide shows how), and the guide to creating a group in Gmail covers sending to one. For personalized sends, see the Gmail mail merge guide.

If these are the first of several automations across Gmail, Sheets and Drive, the overview of Google Workspace automation lays out what each option can do, while the Zapier alternatives comparison shows how Make, n8n and others would charge for the same Zaps.

Follow up with the people you just saved

Saving a contact is only half of it; the note afterward is what people remember. On a Mac, Merlin reads your Google Calendar and drafts email in your Gmail. Tell Merlin you want a short thank-you for everyone you met on yesterday's calls, and it writes one draft per person for you to read, tweak and approve. You see every one before a single thank-you is sent.

Get Merlin

Frequently asked questions

Can Google Contacts add contacts automatically?

Yes. With "Save contact info when you interact with people" turned on, Google saves people you email, share with or accept invites from to Other contacts. Android can also back up the contacts you add on your phone to your Google account automatically.

How do I automatically add email senders to Google Contacts?

Gmail can save people you send email to under Other contacts, through its "Create contacts for auto-complete" setting. To add incoming senders as full contacts, open the contact at contacts.google.com and save it, or use an automation such as Zapier.

Can I sync Google Sheets with Google Contacts?

Not natively. Use a Zapier Zap with the trigger New Spreadsheet Row and the Google Contacts action Find or Create Contact, or a free Apps Script that uses the People API on a timer.

How many contacts can Google Contacts hold?

Up to 25,000 contacts per account. Imports are limited to 3,000 contacts per file, so split larger lists.

Can Google Contacts merge duplicates automatically?

No. Google suggests duplicates under Merge & fix, and you accept them with Merge or Merge all. Contacts in different Google accounts can't be merged.

How do I back up Google Contacts automatically?

Google's export is a manual step, so export a Google CSV from More actions > Export on a regular reminder. For a running copy, a Zapier Zap can add each new contact to a Google Sheet, and Undo changes can roll the list back up to 30 days.

you scrolled all the way down here

your next free moment starts in three minutes

getting started takes three minutes. sign in, and i'm on your to-dos, starting with who's waiting on you

you decide what comes after

Download for Mac Free forever. No credit card.