Products
- Pabbly Plus
  Pabbly Plus provides access to all Pabbly applications at a single price. You will have access to Pabbly Connect, Pabbly Subscription Billing, Pabbly Chatflow, Pabbly Email Marketing, Pabbly Form Builder and Pabbly Hook.
  
  Pabbly Connect
  Integrate different applications and start automating your work.
  
  Pabbly Subscription Billing
  Start accepting one-time and recurring subscription payments.
  
  Pabbly Chatflow
  Automate WhatsApp conversations effortlessly.
  
  Pabbly Email Marketing
  Send email newsletters to your subscribers and customers.
  
  Pabbly Form Builder
  Create professional forms for your business with no code builder.
  
  Pabbly Hook
  Webhook event handling for scalable applications.
Sign In

Automatically Add Bulk Leads to Google Contacts in Seconds (No Coding)

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Google Sheets Integration

To start, access Pabbly Connect by visiting pabby.com. This platform will help automate the process of adding contacts from Google Sheets to Google Contacts.

Once on the site, sign in or create an account. Existing users should click on the “Sign In” button at the top right. New users can click “Sign Up for Free” to receive 100 free tasks monthly, allowing you to explore the features of Pabbly Connect.

2. Creating a New Workflow in Pabbly Connect

After signing in, navigate to the Pabbly Connect dashboard. Click on “Create Workflow” to start a new automation. Name your workflow, for example, “Automatically Add Bulk Leads to Google Contacts in Seconds.” Select a folder for your workflow and click “Create” to proceed.

Click on “Create Workflow”.
Name your workflow appropriately.
Select a folder for organization.

Your workflow is now created, and you can begin adding triggers and actions that utilize Pabbly Connect to automate your data flow.

3. Setting Up Google Sheets as a Trigger Application

In this step, you will set Google Sheets as the trigger application within Pabbly Connect. Choose “Google Sheets” and select the trigger event “New or Updated Spreadsheet Row”. Click on “Connect” to establish a connection.

Next, a webhook URL will be generated, serving as a bridge between Google Sheets and Pabbly Connect. Copy this URL and head to your Google Sheets. In your spreadsheet, navigate to “Extensions > Add-ons > Get Add-ons” to install the Pabbly Connect Webhooks add-on if you haven’t already.

4. Configuring Google Sheets with Pabbly Connect

Once the add-on is installed, go back to your Google Sheets and click on “Extensions > Pabbly Connect Webhooks > Initial Setup”. Paste the copied webhook URL and specify the trigger column (usually the last data column).

Paste the webhook URL in the setup box.
Specify the trigger column for data entry.
Click “Send Test” to check the connection.

After confirming the setup, click “Submit”. You will see a success message indicating that the configuration is complete. This setup ensures that any future data added to the specified column will be sent to Pabbly Connect.

5. Creating Google Contacts from Google Sheets Data

Now, to add contacts to Google Contacts, click on “Add New Action Step” in Pabbly Connect. Choose “Google Contacts” as the action application and select “Create Contact” as the action event. Connect your Google account to allow Pabbly Connect to access your contacts.

Map the fields from Google Sheets to Google Contacts. For instance, map the first name, last name, email, and phone number. After mapping, click “Save and Send Test Request” to create a contact. You should see a confirmation that the contact has been successfully created.

Conclusion

In this tutorial, you learned how to use Pabbly Connect to automate adding contacts from Google Sheets to Google Contacts. This integration simplifies contact management and saves time by automating data entry.