Automate LinkedIn Ads Leads to Google Sheets & Send Welcome Emails

Learn how to automate LinkedIn Ads leads to Google Sheets and send welcome emails using Pabbly Connect in this detailed tutorial. This comprehensive guide reveals exactly how to connect your applications and automate repetitive tasks — accessible for professionals of all technical backgrounds.

Watch Step By Step Video Tutorial Below

1. Access Pabbly Connect for Automation

To start automating LinkedIn Ads leads to Google Sheets and sending welcome emails, you need to access Pabbly Connect. First, open a new tab and navigate to Pabbly.com/connect. This platform is essential for integrating multiple applications without any coding skills.

Once on the Pabbly Connect homepage, you will see options to sign in or sign up for free. If you are new to Pabbly Connect, click on the ‘Sign Up Free’ option to create an account. Existing users should click on ‘Sign In’. After signing in, you will be directed to the dashboard where you can manage your automation workflows.

2. Create a New Workflow in Pabbly Connect

Creating a new workflow in Pabbly Connect is the next step. On your dashboard, locate the ‘Create Workflow’ button. Click on it, and you will be prompted to select a workflow builder. Choose the new beta version for a modern experience.

Enter a workflow name, such as ‘Automate LinkedIn Ads Leads to Google Sheets and Send Welcome Emails’. Select the appropriate folder for your workflow and click on the ‘Create’ button. This action sets the foundation for your automation, where you will define triggers and actions.

3. Set Up Trigger with LinkedIn Leads

The first crucial step in your automation is to set up the trigger. In this case, select LinkedIn as your trigger application. Search for LinkedIn in the ‘Choose App’ field and select it. For the app event, choose ‘Lead Notification’.

Click on the ‘Connect’ button. You will have options to add a new connection or select an existing one. Since you are setting up a new connection, click on ‘Add New Connection’. Sign in to your LinkedIn account and grant the necessary permissions. Once connected, select your sponsored account and enable the simple response toggle if desired.

• Select LinkedIn as the trigger application.
• Choose ‘Lead Notification’ as the app event.
• Connect your LinkedIn account to Pabbly Connect.

After connecting, click on the ‘Save and Send Test Request’ button to check for a webhook response. This confirms that your LinkedIn account is linked with Pabbly Connect.

4. Add Google Sheets Integration

Now that your trigger is set, the next step is to integrate Google Sheets. Click on the ‘+’ icon to add a new action application. Search for Google Sheets and select it. For the app event, choose ‘Add New Row’.

Again, click on the ‘Connect’ button and select ‘Add New Connection’. Sign in with your Google account and grant the necessary permissions. Once connected, select the spreadsheet you want to use, such as ‘LinkedIn Ads Leads’.

• Choose ‘Add New Row’ for the app event.
• Map the response fields from LinkedIn to your Google Sheets.
• Click ‘Save and Send Test Request’ to verify the integration.

After successfully mapping the fields and sending the test request, check your Google Sheets to ensure a new record has been added. This confirms that the integration is functioning correctly through Pabbly Connect.

5. Send Welcome Emails via Gmail

The final step in this automation process is to send welcome emails using Gmail. Click the ‘+’ icon again to add another action application. Search for Gmail and select it. For the app event, choose ‘Send Email’.

Connect your Gmail account by clicking on ‘Add New Connection’. Sign in and grant the necessary permissions. In the email setup, enter the sender name, recipient email address, subject, and email content. You can personalize the email using dynamic fields from the LinkedIn response.

Select ‘Send Email’ for the app event. Map the recipient’s email address from the LinkedIn lead. Write a personalized email content.

After completing the email setup, click ‘Save and Send Test Request’. Check your Gmail account to confirm that the welcome email was sent successfully. This completes your automation setup using Pabbly Connect.

Conclusion

In this tutorial, we learned how to automate LinkedIn Ads leads to Google Sheets and send welcome emails using Pabbly Connect. By following these steps, you can efficiently manage leads and enhance user engagement through automated workflows.