Integrate Google Ads with Slack and Google Sheets Using Pabbly Connect

Learn how to integrate Google Ads with Slack and Google Sheets using Pabbly Connect for automated lead notifications and data tracking. Discover how to seamlessly connect your essential tools through accessible instructions that make powerful automation available to professionals at every skill level.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect to Create Automations

To start integrating Google Ads with Slack and Google Sheets, first access Pabbly Connect. This platform allows you to automate workflows efficiently.

Visit the Pabbly Connect website and sign in to your account. If you are a new user, you can sign up for free to get started. Once signed in, navigate to the dashboard where you can create a new workflow.

2. Creating a Workflow in Pabbly Connect

Creating a workflow in Pabbly Connect is essential for this automation. Click on the ‘Create Workflow’ button in the top right corner of the dashboard.

• Name your workflow, for example, ‘Notify Team on Slack for New Google Ads Leads’.
• Select a folder to save your workflow, such as ‘Google Ads Automations’.
• Click ‘Create’ to finalize the workflow creation.

After creating the workflow, you will see two main sections: Trigger and Action. The trigger initiates the workflow whenever a new lead is generated from Google Ads.

3. Setting Up the Trigger with Google Ads

To set up the trigger in Pabbly Connect, select Google Ads as the trigger application. Choose the event as ‘New Lead Form Entry’.

Pabbly Connect provides you with a webhook URL that you need to copy and paste into your Google Ads lead form settings. This will connect your Google Ads account with Pabbly Connect.

• Open your Google Ads campaign and navigate to the lead form settings.
• Paste the webhook URL in the lead delivery option under webhook integration.
• Send test data to verify the connection.

After sending test data, check your Pabbly Connect workflow to confirm that the test response is received, indicating that the connection is successful.

4. Notifying Your Team on Slack

Once the trigger is set up, the next step is to notify your team via Slack using Pabbly Connect. Select Slack as your action application and choose the action event as ‘Send Channel Message’.

Connect your Slack account to Pabbly Connect by following the authorization prompts. Select the channel where you want to send the notifications, such as ‘Google Ads Leads’.

Write a message template that includes lead details like name, email, and phone number. Map the data from the trigger step to dynamically insert lead information. Click ‘Save and Send Test Request’ to check if the message is sent successfully.

Upon successful execution, your team will receive the notification in the designated Slack channel whenever a new lead is generated.

5. Logging Leads in Google Sheets

The final step is to log the lead information into Google Sheets using Pabbly Connect. Add another action step in your workflow and select Google Sheets as the application.

Choose the action event ‘Add New Row’ to insert lead details into your spreadsheet. Connect your Google Sheets account and select the appropriate spreadsheet and sheet where you want to store the data.

Map the fields for first name, last name, email, and phone number from the trigger data. Click ‘Save and Send Test Request’ to verify if the data is added correctly. Check your Google Sheets to confirm that the lead data has been logged.

With this setup, every new lead generated from Google Ads will automatically be logged in Google Sheets, allowing for efficient tracking and management.

Conclusion

This tutorial demonstrated how to integrate Google Ads with Slack and Google Sheets using Pabbly Connect. By automating lead notifications and data logging, you can streamline your workflow and enhance your team’s responsiveness.