This guide will show you how to export your Google Contacts to a spreadsheet – either Microsoft Excel or Google Sheets. This demo features Google Sheets, but the same steps and principles will apply to both.
Why export Google Contacts to a spreadsheet with Unito?
There are a number of reasons why you might want to import contacts into a Google Sheet. Sales reps can use it for reporting, agencies with multiple clients might like to have a dedicated list that can be easily shared, or maybe you just prefer the layout of a spreadsheet tool. In any case, automating the transfer of contacts from one app to another is simple and shouldn’t involve manually copy pasting details over and over again. The best part about an automated solution is that if details become out of date, you can simply change it in one space and watch the other update instantly.
Step 1. Choose a label for your contacts
Head over to contacts.google.com and create a label for your contacts if you haven’t already. The name of your label should apply to your use case; you could categorize them by region, business relationship, or another criteria of your choice. Next, apply that label to each contact you’d like to import into a Google Sheet.
Step 2. Add header rows to your spreadsheets
Next up, go to docs.google.com if you’re using Google Sheets or www.office.com for Microsoft Excel users to set up your spreadsheet with header rows. As contact data syncs to your sheet, you need to tell Unito where you want that information to live in your spreadsheet. We call this phase field mapping. Think of all the contact details that matter in this context and give them a name in the first row of your spreadsheet. If you miss one, you can always go back and add it in later, but try to do so before launching your flow.
Step 3. Install the Unito add-on to your Google Workspace
Near the top of your sheet, select Extensions, Add-ons, then Get add-ons. Perform a quick search for “Unito for Google Sheets” then add it to your workspace.
When the extension is installed, you just need to insert two columns to help Unito sync your contact data.
Step 4. Connect Google Sheets and Google Contacts with Unito
Now head over to the Unito App and click +Create Flow. On the following screen, choose Start Here to connect Google Contacts and Google Sheets to Unito. We’ll begin our demo with Google Sheets on the left, and Microsoft Excel on the right. You’ll need to specify which account and sheet you want to sync with Unito.
Step 5. Set flow direction between Google Contacts and Google Sheets
This part is simple: since our integration is still in beta, we can only choose a one-way flow from Google Contacts to your Spreadsheet. This means new contacts you add to Google Contacts will create identical rows in your Google Sheet with matching information, but not the other way around. Since that’s all we need right now, we’ll select confirm.
Step 6. Set rules to export contacts to your spreadsheet
Our rules will help us decide which contacts we want to export from Google Contacts into our spreadsheet. Rules can also help us filter out unwanted or unrelated contacts from syncing accidentally. This is where our labels from Step 1 come into play.
In Unito, select Add a new trigger, then Label, and pick all the labels you created earlier.
Now, only those contacts with labels from these rules will appear in your Google Sheet.
Step 7. Select field mappings based on header rows
Here, we’ll choose which contact details we want to sync to our spreadsheet. You can pick the exact information you want and leave out anything you don’t. If you select Auto-map, Unito will pre-populate a list of suggested field mappings which you can then adjust. However, for this particular demo, we recommend you Start from scratch.
Start by clicking Select a field for your Google Sheet, and find the appropriate field to map in Google Contacts. Since there will likely be more fields to choose from in Google Contacts, we recommend only mapping what you want to see in your spreadsheet.
If you choose a one-way flow for any field, then only changes in the source field will cause similar changes to appear in the destination field. e.g., if Google Sheets is your source or you choose a 2-way sync, then any changes made to your spreadsheet will cause those changes to appear in Google Contacts.
Click Confirm when you’re satisfied with your field mappings to proceed.
Find out more about setting field mappings.
Step 8. Save and close to launch your flow between Google Sheets and Google Contacts
And that’s it! Follow the remaining on-screen instructions to complete your flow and it should start syncing momentarily. Congratulations!
If you’ve followed the steps above, your flow will now add rows in either Google Sheets and/or Microsoft Excel based on rows added in the other. Here is an example of our fully-synced contacts and spreadsheets:
If you have any questions, don’t hesitate to reach out and let us know.
What’s next after importing Google Contacts into a spreadsheet?
- Learn how to duplicate this flow to suit other use cases you may have in mind.
- Read our Google Contacts primer and Google Sheets primer to better understand each integration’s capabilities and limitations.
- Connect Google Sheets to HubSpot to streamline sales reporting.
- Try syncing Google Calendar to Trello, Asana, or Notion.