Watch Step By Step Video Tutorial Below
1. Accessing Pabbly Connect for Integration
To integrate Zoho CRM with Google Sheets, you first need to access Pabbly Connect. Open a new tab and navigate to the Pabbly Connect website. If you are a new user, sign up for a free account to receive 100 free tasks, allowing you to test the features of Pabbly Connect.
Once logged in, you will be on the Pabbly Connect dashboard. From here, click on the “Create Workflow” button. This is where you will set up the automation to add new contacts from Zoho CRM directly into Google Sheets.
2. Creating a New Workflow in Pabbly Connect
After accessing Pabbly Connect, you need to create a new workflow. Select the “Create Quick Builder” option. Enter a prompt indicating that you want to add Zoho CRM contacts to Google Sheets. This prompt helps the AI generate the necessary workflow.
- Click on the “Create Workflow” button.
- Choose the “Create Quick Builder” option.
- Enter your prompt for the integration.
Once you have set the prompt, the workflow will be created. You will then need to connect your Zoho CRM account to Pabbly Connect to proceed with the integration.
3. Connecting Zoho CRM to Pabbly Connect
To connect your Zoho CRM account, click on the “Add New Connection” option. You will be prompted to log in to your Zoho CRM account. Enter your domain URL in the provided field to establish the connection.
Once the connection is established, you will need to grant permission for Pabbly Connect to access your Zoho CRM data. This ensures that your data remains secure while allowing Pabbly Connect to automate the process of adding new contacts to Google Sheets.
4. Mapping Data to Google Sheets
After connecting Zoho CRM, the next step is to map the data to Google Sheets. Click on the “Connect” button and select the option to sign in with Google. Choose the Google Sheets you wish to use for storing your contacts.
- Select the spreadsheet and sheet where you want to store data.
- Map the fields such as Full Name, Email, Phone Number, and Address.
- Ensure to save the changes after mapping the data.
After mapping, click on the “Save and Send Test Request” button to ensure that the data is being added correctly to Google Sheets. This step is crucial as it verifies the integration process.
5. Testing the Integration
To test the integration, create a new contact in your Zoho CRM account. Once the contact is added, switch to Google Sheets and refresh the page to check if the contact details have been successfully added.
The integration should allow new contacts from Zoho CRM to automatically sync into your Google Sheets, keeping all your data organized. This automation saves time and ensures that you always have the latest information at your fingertips.
Conclusion
In this tutorial, you have learned how to integrate Zoho CRM with Google Sheets using Pabbly Connect. This seamless integration allows for automatic updates of contact details, enhancing your data management efficiency.



