Automate LinkedIn Ads Leads to Google Sheets & Send Product Recommendations

Learn how to automate LinkedIn Ads leads to Google Sheets and send product recommendations using Pabbly Connect in this step-by-step tutorial. Build sophisticated automated workflows in less time than you think. This guide translates complex integrations into straightforward steps for immediate implementation.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Automation

To automate LinkedIn Ads leads into Google Sheets, start by accessing Pabbly Connect. Open a new tab and navigate to Pabbly.com/connect. This platform allows seamless integration between various applications without any coding.

Once on the Pabbly Connect page, you will see options to sign in or sign up. If you are a new user, click on ‘Sign Up Free’ to get started with 100 free tasks monthly. Existing users can simply sign in to access their dashboard. Here, you can create and manage all your automation workflows.

2. Creating a Workflow in Pabbly Connect

After signing in, click on the ‘Access Now’ button to enter your Pabbly Connect dashboard. To create a new workflow, click on the ‘Create Workflow’ button, where you will need to choose the workflow builder. Select the new beta version for a more modern experience. using Pabbly Connect

• Select the workflow name: ‘Automate LinkedIn Ads Leads to Google Sheets and Send Product Recommendations’.
• Choose your folder, for instance, ‘Pabbly Connect’.
• Click the ‘Create’ button to finalize your workflow setup.

Once your workflow is created, you will need to set up a trigger. This is the first application in your integration, which will be LinkedIn in this case. Select LinkedIn and then choose the event as ‘Lead Notification’ to proceed with the integration.

3. Linking LinkedIn to Pabbly Connect

After selecting LinkedIn as your trigger app, click on the ‘Connect’ button. You will have options to add a new connection or select an existing one. For this setup, choose ‘Add New Connection’ and click on the ‘Connect with LinkedIn’ button. You will need to sign in to your LinkedIn account to authorize the connection.

Once connected, select your sponsored account and enable the response toggle for simple response format. Click on ‘Save and Send Test Request’ to initiate the connection. After this, you will need to simulate a lead by clicking on the ‘Apply Now’ button in your LinkedIn ad and filling out the required fields.

• Enter a test email address and phone number.
• Submit the form to generate a lead.

Once submitted, Pabbly Connect will receive the lead details, confirming that your LinkedIn account is successfully linked to Pabbly Connect.

4. Adding Google Sheets to the Workflow

With LinkedIn successfully integrated, the next step is to add Google Sheets as your action application. Click on the plus option and search for Google Sheets. Select it and choose the event as ‘Add New Row’.

Again, click on the ‘Connect’ button. If you have an existing connection, select it; otherwise, create a new one by signing in with Google. Once connected, you will need to select the spreadsheet where the leads will be stored. Choose the spreadsheet named ‘LinkedIn Leads’ that you created earlier.

Map the fields from LinkedIn to Google Sheets: first name, last name, email, and contact number. Click on ‘Save and Send Test Request’ to check if the data is added correctly.

After testing, verify that a new entry has been added to your Google Sheet, confirming that Pabbly Connect is effectively managing the data transfer.

5. Sending Product Recommendations via Gmail

The final step in this automation process is to send product recommendations to users via Gmail. Select Gmail as your next action application and choose the event ‘Send Email’. Click on the ‘Connect’ button and set up your connection to Gmail.

After connecting, fill in the sender name as ‘Pabbly Team’. The sender email will auto-populate. In the recipient email field, map the user’s email address from the LinkedIn lead details. Write an engaging subject line and customize the email content to include personalized greetings and product recommendations.

Set the content type to HTML for better formatting. Click ‘Save and Send Test Request’ to send a test email.

Check your Gmail account to ensure the email has been received, confirming that the entire workflow is functioning correctly through Pabbly Connect.

Conclusion

In this tutorial, we demonstrated how to automate LinkedIn Ads leads to Google Sheets and send product recommendations using Pabbly Connect. This integration streamlines your workflow, allowing you to effortlessly manage leads and enhance customer engagement.