In this post, we will discuss how you can integrate Google Contacts with Google Sheets and automatically store details of newly added contacts in a Google Sheets spreadsheet.
This automation requires a simple one-time setup, for which we will use Pabbly Connect.
To initiate the process, Google Contacts will be connected with Pabbly Connect to retrieve any newly added contacts, and subsequently, Pabbly Connect will be connected with Google Sheets to record the contacts’ information in the spreadsheet.
Steps to Automatically Sync Google Contacts with Google Sheets
1. Sign In / Sign Up to Pabbly Connect and Create a Workflow
2. Setup Google Contacts as the Trigger App to Gather Contacts
3. Setup Google Sheets as the Action App to Store Contacts
Step 1:- Sign In / Sign Up to Pabbly Connect and Create a Workflow
A. Sign In / Sign Up
To begin this process, visit Pabbly Connect and create your account by clicking on the ‘Sign Up Free’ button. You can also click on Sign In if you already have an account.
Click on the Pabbly Connect ‘Access Now’ button
B. Create Workflow
To create a new workflow, click the ‘Create Workflow’ button.
Name your workflow, and click on ‘Create’.
Step 2:- Setup Google Contacts as the Trigger App to Gather Contacts
We will now explore the steps to create a link between Google Contacts and Pabbly Connect. This link will facilitate the retrieval of contact information from Google Contacts.
A. Trigger App
Choose ‘Google Contacts’ as the Trigger App, select ‘New or Updated Contact’ as the Trigger Event, and click on ‘Connect’.
B. Connect Google Contacts Account
To connect with your Google Contacts account, select ‘Add New Connection’, and click on ‘Sign in with Google’. Furthermore, provide the required permissions to authorize the connection.
Click on ‘Save & Send Test Request’, the contact information of the most recently added contact in Google Contacts will be retrieved.
To verify that the connection is successful, expand the Response Received section, and check if the gathered contact information is visible.
Step 3:- Setup Google Sheets as the Action App to Store Contacts
Action allows us to choose the application that will get executed by the workflow trigger.
Our objective is to gather contact information from Google Contacts and save it in our Google Sheets spreadsheet. Hence, we will be using Google Sheets as our Action App.
A. Action App
Choose ‘Google Sheets’ as the Action App, select ‘Add New Row’ as an Action Event, and click on ‘Connect’.
B. Connect Google Sheets Account
To connect with your Google Sheets account, select ‘Add New Connection’, and click on ‘Sign in with Google’. Then, give permission for authorization.
Select the specific Spreadsheet and Sheet that you want to use for storing the contacts.
After you choose the sheet, the columns within that sheet will be displayed as fields in your Action Step.
C. Map Necessary Fields
Once you have linked your Google Sheets account, you simply need to map the contact information from the previous step. This mapping process helps to keep our data dynamic and automatically updated based on the responses received.
Map the First Name from the previous step.
In a similar manner, map the remaining fields, and click on ‘Save & Send Test Request’.
The automation is now finished, and we have successfully integrated Google Contacts with Google Sheets. As a result, whenever a new contact is added to your Google Contacts, it will automatically be saved in your Google Sheets spreadsheet.
You can copy this entire workflow by clicking this link.
Sign Up for a free Pabbly Connect account, and start automating your business
Subscribe to our Youtube Channel for more such automation
For any other queries, visit our forum