Watch Step By Step Video Tutorial Below





1. Accessing Pabbly Connect for Integration

To start creating bulk Google Contacts from Google Sheets, first, you need to access Pabbly Connect. Visit pabi.com and sign into your Pabbly account. Once logged in, navigate to the Pabbly Connect dashboard.

After reaching the dashboard, create a new workflow by selecting “Create from scratch”. Name the workflow “Create Bulk Contacts from Google Sheets in One Click”. Choose the folder where you want to save this workflow, such as “All Automation”, and click on “Create”. This will set the foundation for connecting Google Sheets and Google Contacts.

2. Setting Up the Trigger in Pabbly Connect

In this step, you will set up a trigger in Pabbly Connect to initiate the workflow. A trigger is an event that starts the automation process. Select Google Sheets as the trigger application and choose the event “New or Updated Spreadsheet Row”. Then, click on the “Connect” button.

  • Select Google Sheets as the trigger application.
  • Choose the event “New or Updated Spreadsheet Row”.
  • Click on the “Connect” button.

Next, you will need to copy the webhook URL provided by Pabbly Connect. This URL will be used to connect Google Sheets to Pabbly Connect, allowing it to send data whenever a new row is added or updated.

3. Configuring Google Sheets with Pabbly Connect

Now, open your Google Sheets where your contact details are stored. Navigate to the “Extensions” menu, click on “Add-ons”, and select “Get Add-ons”. Search for “Pabbly Connect Webhooks” and install it if you haven’t done so already. After installation, refresh your Google Sheets.

Once refreshed, you will see a new option for Pabbly Connect Webhooks. Click on “Initial Setup” and enter the webhook URL you copied earlier. Specify the trigger column, which is the final data column that will activate the webhook when data is added. For example, if column D is your trigger column, enter that here.

4. Linking Google Contacts with Pabbly Connect

The next step is to set up the action in Pabbly Connect to link Google Contacts. In your workflow, select Google Contacts as the action application and choose the event “Create a Contact”. Click on “Connect” to establish a connection with your Google account.

  • Choose Google Contacts as the action application.
  • Select the action event “Create a Contact”.
  • Sign in with your Google account and grant permissions.

After connecting, you will need to map the fields from Google Sheets to Google Contacts. For example, enter the first name, last name, email, and phone number by selecting the corresponding fields from the Google Sheets data. This mapping ensures that the correct information is transferred to Google Contacts.

5. Finalizing the Integration and Testing

After mapping the fields, click on “Save and Send Test Request”. This will create a test contact in your Google Contacts. Refresh your Google Contacts page to verify that the contact has been created successfully.

Now, to add all contacts from Google Sheets to Google Contacts in one click, go back to your Google Sheets, click on the Pabbly Connect Webhooks option, and select “Send All Event”. This action triggers the integration to send all the contact details to Google Contacts at once.

After refreshing your Google Contacts, you will see that all the contacts from your Google Sheets have been successfully added. This seamless integration showcases the power of Pabbly Connect in automating workflows between applications.

Conclusion

In this tutorial, we demonstrated how to create bulk Google Contacts from Google Sheets using Pabbly Connect. By following these steps, you can automate your contact management efficiently.