Watch Step By Step Video Tutorial Below





1. Accessing Pabbly Connect for Integration

To begin the integration process using Pabbly Connect, first navigate to the Pabbly Connect website. If you are a new user, go to pabbl.com/connect and sign up for a free trial. This trial offers 100 hours of usage every month, allowing you to explore its features.

Once signed up, log into your Pabbly Connect account. You will be directed to the workflow builder, which is essential for setting up your automation. This area allows you to create and manage integrations effectively.

2. Setting Up Google Sheets with Pabbly Connect

For this integration, the first step is to set up Google Sheets as your trigger application in Pabbly Connect. Click on the “Add Trigger” button and select Google Sheets as your application. Choose the event as “New or Updated Spreadsheet Row” and connect your Google account.

  • Select Google Sheets as the trigger application.
  • Choose the event “New or Updated Spreadsheet Row”.
  • Connect your Google account to access your spreadsheets.

After connecting, you will receive a webhook URL. Copy this URL, as it is crucial for the next steps in your automation process.

3. Installing Pabbly Connect Add-On in Google Sheets

Now, you need to install the Pabbly Connect Webhooks add-on in Google Sheets. Go to “Extensions” and then “Add-ons” to search for the Pabbly Connect Webhooks add-on. Install it to enable the webhook functionality.

After installation, refresh your Google Sheets to ensure the add-on is active. Once refreshed, navigate to “Extensions” and find the Pabbly Connect Webhooks option. Click on it to access the initial setup.

4. Configuring the Webhook in Google Sheets

In the initial setup of the Pabbly Connect Webhooks add-on, paste the copied webhook URL and specify the trigger column. The trigger column is where the final data will be added, which will automatically send the entire row to your Pabbly Connect workflow.

For instance, if your final data is in column D, set the trigger column to D. Click on “Submit” to save your configuration. You will see a message indicating that the setup was configured successfully.

  • Paste the webhook URL in the setup.
  • Specify the trigger column for data.
  • Click “Submit” to save the settings.

Now, you can send test data to confirm that the integration is working properly. Click on the “Send Test” option to proceed.

5. Creating Google Contacts Using Pabbly Connect

Next, you will set up Google Contacts as the action application in Pabbly Connect. Click on “Add New Action Step” and select Google Contacts. Choose the event as “Create Contact” and connect your Google account.

Once connected, you will need to map the fields from your Google Sheets to the Google Contacts. This means linking the data from your spreadsheet directly to the fields in Google Contacts. After mapping, click on “Save and Send Test Request” to create a contact.

  • Select Google Contacts as the action application.
  • Map the fields from Google Sheets to Google Contacts.
  • Click “Save and Send Test Request” to create the contact.

After successfully creating a contact, you can return to your Google Contacts to verify that the new contact has been added. You can also send all data from your spreadsheet to create multiple contacts at once using the “Send All Data” option in the Pabbly Connect Webhooks add-on.

Conclusion

In this tutorial, we explored how to integrate Google Sheets with Google Contacts using Pabbly Connect. This powerful automation allows you to create contacts effortlessly from your spreadsheet data. By following these steps, you can streamline your workflow and enhance productivity.