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

How to Import Bulk Contacts in Zoho CRM Easily

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To start integrating Google Sheets with Zoho CRM, first access Pabbly Connect. Open your browser and navigate to pav.com/connect. Here, you will find options to sign in or sign up for free.

If you are a new user, click on “sign up free” to receive 100 free tasks monthly. Existing users can simply sign in. After logging in, click on “Access Now” to enter the Pabbly Connect dashboard.

2. Creating a Workflow in Pabbly Connect

In the Pabbly Connect dashboard, click on “Create from scratch” or “Create using AI”. For this tutorial, select “Create using AI” to utilize the AI workflow builder.

Describe your workflow: “When new data comes in from Google Sheets, add it to Zoho CRM”.
Select Google Sheets trigger and Zoho CRM action to create a contact.
Preview and approve the workflow.

Once approved, you will receive a webhook URL to connect Google Sheets with Pabbly Connect.

3. Setting Up the Trigger with Google Sheets

To set up the trigger, copy the webhook URL provided by Pabbly Connect. Open your Google Sheets, and install the “Pabbly Connect Webhooks” add-on from the Google Workspace Marketplace.

After installation, refresh your Google Sheets and navigate to Extensions > Pabbly Connect Webhooks > Initial Setup. Paste the webhook URL and specify the trigger column, which is the final data column.

Submit the setup to configure the webhook.
Test the connection by clicking “Send Test”.
Enable “Send on Event” to automate data capture.

With this setup, any new data in Google Sheets will trigger the automation process in Pabbly Connect.

4. Connecting to Zoho CRM

Next, you need to connect Pabbly Connect to your Zoho CRM account. In the Pabbly Connect workflow, select Zoho CRM and enter your domain, which you can find in your Zoho CRM URL.

After entering the domain, authorize Pabbly Connect to access your Zoho CRM data securely. You can now map the data fields from Google Sheets to Zoho CRM, such as first name, last name, and email address.

Select lead source and map the fields dynamically.
Use the “Text Formatter by Pabbly” to split names if needed.
Click “Save and Send Request” to create a new contact.

After this step, you will see a successful response confirming the new contact creation in Zoho CRM, facilitated by Pabbly Connect.

5. Bulk Uploading Contacts to Zoho CRM

To upload multiple contacts at once, return to Google Sheets and select Extensions > Pabbly Connect Webhooks > Send All Data. This action will import all customer details as new contacts in Zoho CRM.

After initiating the bulk upload, refresh your Zoho CRM account to verify that all contacts have been added successfully. This streamlined process is a testament to the power of Pabbly Connect in automating workflows.

Ensure all necessary fields are mapped correctly before sending.
Check for any errors in the response and adjust accordingly.
Use the automation for future updates seamlessly.

This process showcases how Pabbly Connect can efficiently manage bulk contacts, saving time and effort in data entry.

Conclusion

In this tutorial, we explored how to integrate Google Sheets with Zoho CRM using Pabbly Connect. By following these steps, you can automate your contact management process and enhance productivity.