Sync Google Sheets with Google Contacts Using Pabbly Connect

Learn how to sync Google Sheets with Google Contacts using Pabbly Connect. This step-by-step tutorial covers the exact process for seamless integration. Navigate the automation landscape confidently with clear, structured guidance suitable for professionals regardless of prior technical experience.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To sync Google Sheets with Google Contacts, you first need to access Pabbly Connect. Start by visiting the Pabbly Connect landing page. If you’re a new user, click on ‘Sign up for free’ to create an account and receive 100 tasks free every month.

As an existing user, select ‘Sign In’ to enter your dashboard. Once logged in, you will see various Pabbly applications. Click on ‘Access Now’ under Pabbly Connect to begin the integration process.

2. Creating a New Workflow in Pabbly Connect

After accessing Pabbly Connect, you will need to create a new workflow. Click on the ‘Create Workflow’ button. In the prompt, name your workflow (e.g., ‘Create Google Contact for New or Updated Spreadsheet Rows’) and choose a folder to save it in.

• Click on ‘Create’ to open the workflow window.
• Select Google Sheets as your trigger application.
• Choose ‘New or Updated Spreadsheet Row’ as the trigger event.

This setup allows Pabbly Connect to recognize when new rows are added or updated in Google Sheets, initiating the workflow.

3. Connecting Google Sheets to Pabbly Connect

To connect Google Sheets to Pabbly Connect, you will receive a webhook URL. Copy this URL to establish the connection. Open your Google Sheets and navigate to ‘Extensions’ > ‘Add-ons’ > ‘Get add-ons’.

Search for ‘Pabbly Connect Webhooks’ and install it if you haven’t already. Once installed, go back to ‘Extensions’ > ‘Pabbly Connect Webhooks’ and select ‘Initial Setup’. Paste the copied webhook URL and specify the trigger column (the last filled column in your sheet).

4. Setting Up Google Contacts Action in Pabbly Connect

After configuring Google Sheets, it’s time to set up the action in Pabbly Connect. Select Google Contacts as your action application and choose ‘Create Contact’ as the action event. If prompted, connect your Google Contacts account by selecting ‘Add a New Connection’ and signing in with your Google account.

Once connected, you will need to map the details from the Google Sheets trigger. This includes fields such as first name, last name, email, and phone number. Mapping ensures that the data from the new or updated row in Google Sheets is accurately transferred to Google Contacts.

• Map the first name, last name, gender, email, company name, and phone number accordingly.
• Click on ‘Save and Send Test Request’ to verify the setup.

Upon successful mapping and testing, a new contact will be created in Google Contacts based on the data from Google Sheets.

5. Testing the Integration Workflow

To ensure your workflow is functioning correctly, return to your Google Sheets and add a new contact. For example, input the first name as ‘Test’, last name as ‘User’, and fill in the email and phone number. Once you save the new row, Pabbly Connect will capture this data and trigger the workflow.

Check your Google Contacts to confirm that the new contact appears with the correct details. This step validates the successful integration between Google Sheets and Google Contacts through Pabbly Connect.

Finally, if everything is working as expected, you can automate this process for future entries, ensuring that every new contact added to your Google Sheets is automatically created in Google Contacts.

Conclusion

In this tutorial, we explored how to sync Google Sheets with Google Contacts using Pabbly Connect. By following the exact steps outlined, you can automate the creation of new contacts from your Google Sheets, streamlining your workflow efficiently.