Watch Step By Step Video Tutorial Below
1. Accessing Pabbly Connect for Google Ads Integration
To start integrating Google Ads with Google Sheets and Zoho CRM, you need to access Pabbly Connect. Open your browser and navigate to pabbly.com/connect. This platform will allow you to automate the lead capturing process efficiently.
Once on the homepage, you will see two options: “Sign In” and “Sign Up Free.” If you are a new user, click on “Sign Up Free” to create an account and receive 100 free tasks every month. For existing users, simply sign in to access your dashboard.
2. Creating a Workflow in Pabbly Connect
After signing in, you will be directed to the Pabbly apps window. Here, click on “Access Now” under Pabbly Connect to enter the dashboard. To create a new workflow, you can choose between “Create from Scratch” or “Create Using AI.” For this tutorial, select the AI workflow builder.
In the AI interface, enter a prompt describing your automation: “When I get a new lead from Google Ads, add them in Google Sheets and Zoho CRM.” The AI will analyze your request and suggest the necessary actions. Approve the suggested workflow to proceed.
3. Setting Up the Trigger in Pabbly Connect
To set up the trigger, you will receive a webhook URL from Pabbly Connect. This URL is essential for connecting your Google Ads with the platform. Copy the webhook URL and go to your Google Ads account to set up the lead form.
In your Google Ads lead form, locate the “Lead Delivery” section and find the “Webhook Integration” option. Paste the copied webhook URL here and assign a random name for the key. Click on the “Send Test Data” button to send a dummy response to Pabbly Connect. You should see a confirmation that test data has been sent.
- Copy the webhook URL from Pabbly Connect.
- Paste it in the Google Ads lead form under “Lead Delivery”.
- Click “Send Test Data” to confirm the connection.
Once the test data is sent, you can check back in Pabbly Connect to see if the data has been received correctly. This confirms that your trigger is set up successfully.
4. Setting Up Actions in Pabbly Connect
Now that the trigger is set, it’s time to configure the actions. The first action is to add a new row in Google Sheets. In Pabbly Connect, select the action for Google Sheets and choose “Add a New Row.” You will need to connect your Google account by clicking on “Sign In with Google” and granting necessary permissions.
After connecting, select the spreadsheet you want to use (e.g., “New Leads”) and the specific sheet (e.g., “Sheet1”). Map the fields from the previous step, such as first name, last name, email, phone number, and city. This mapping allows data to flow seamlessly from Google Ads to Google Sheets.
- Select “Add a New Row” action in Google Sheets.
- Connect your Google account and select the desired spreadsheet.
- Map the fields to ensure data is transferred correctly.
Once you have mapped the fields, click “Save and Send Request” to complete the action. You should receive a successful response indicating that the data has been added to your Google Sheets.
5. Creating a Contact in Zoho CRM via Pabbly Connect
The final step involves adding the captured lead to Zoho CRM. In Pabbly Connect, select the action for Zoho CRM and choose “Create Contact.” You will need to input your Zoho domain, which can be found in the URL of your Zoho CRM account.
Once connected, you will be prompted to map the same fields as before: first name, last name, email, and phone number. Ensure that you select the lead source as “Advertisement”. After mapping, click on “Save and Send Request” to create a new contact in Zoho CRM.
After refreshing your Zoho CRM, you should see the new contact created successfully with all the details you mapped from the Google Ads lead.
Conclusion
In this tutorial, we demonstrated how to use Pabbly Connect to automate the process of capturing leads from Google Ads and adding them to Google Sheets and Zoho CRM. By following these steps, you can efficiently manage your leads without any manual effort.
