Automate LinkedIn Lead Ads to Google Sheets and Asana with Pabbly Connect

Learn how to automate storing LinkedIn Lead Ads leads in Google Sheets and create Asana tasks automatically using Pabbly Connect in this step-by-step tutorial. Revolutionize your productivity approach with just a few strategic clicks. Uncover professional methods for connecting applications and creating workflows that reclaim hours of your week.

Watch Step By Step Video Tutorial Below

1. Getting Started with Pabbly Connect for LinkedIn Lead Ads

To automate the process of storing LinkedIn Lead Ads leads in Google Sheets and creating Asana tasks, we will use Pabbly Connect. Begin by visiting the Pabbly website and signing in to your account. If you are new, you can sign up for free and receive 100 tasks monthly.

Once signed in, navigate to the Pabbly Connect dashboard. Here, you can create new workflows that will connect LinkedIn, Google Sheets, and Asana. This integration will allow you to automatically store lead details whenever a new lead is generated through LinkedIn.

2. Creating a New Workflow in Pabbly Connect

In the Pabbly Connect dashboard, click on the ‘Create Workflow’ button. You will be prompted to select a workflow builder; choose the classic option for a stable experience. Name your workflow, such as ‘Store LinkedIn Lead Ads Leads in Google Sheets and Create Tasks in Asana Automatically,’ and select a folder for organization. using Pabbly Connect

• Click on the ‘+’ icon to create a new workflow.
• Select ‘LinkedIn’ as the trigger application.
• Choose the trigger event as ‘Lead Notification.’

After setting the trigger, connect your LinkedIn account to Pabbly Connect. This step is crucial as it allows Pabbly Connect to access your LinkedIn lead data. Once connected, you will be able to capture lead notifications directly from LinkedIn.

3. Capturing Lead Data from LinkedIn Using Pabbly Connect

After connecting LinkedIn, you will need to perform a test submission to capture lead data. This involves generating a lead through your LinkedIn campaign. Fill out the lead generation form with test data and submit it. Pabbly Connect will then capture this response.

The captured response will include details such as the lead’s first name, last name, email address, phone number, and company name. This information will be used in the next steps to populate your Google Sheets and create tasks in Asana.

• Ensure all fields in the lead form are filled out correctly.
• Click on ‘Save and Send Test Request’ to retrieve the lead data.
• Confirm that the lead information is displayed correctly in Pabbly Connect.

Once you see the captured response, you can proceed to add this data to your Google Sheets automatically using Pabbly Connect.

4. Adding Lead Data to Google Sheets with Pabbly Connect

In this step, we will use Pabbly Connect to add the captured lead data to Google Sheets. Select Google Sheets as your action application and choose the action event as ‘Add New Row.’ Connect your Google Sheets account by signing in and allowing access.

Next, select the specific spreadsheet where you want to store the lead data. Ensure that your spreadsheet is prepared with the necessary columns like First Name, Last Name, Email, Phone, and Company. Using the mapping feature, link the captured lead data from LinkedIn to the corresponding fields in Google Sheets.

Map the first name, last name, email, phone number, and company fields from the LinkedIn response. Click on ‘Save and Send Test Request’ to send the data to Google Sheets. Verify that the data appears correctly in your Google Sheets.

After confirming the data transfer, you will be ready to create a task in Asana for the new lead using Pabbly Connect.

5. Creating Asana Tasks from Leads with Pabbly Connect

For the final step, select Asana as your action application in Pabbly Connect. Choose the action event as ‘Create Task.’ Connect your Asana account and select the appropriate workspace and project where the task should be created.

Fill in the task details, including the task name, which could be the lead’s name, and add any relevant notes such as their email address and phone number. After mapping these fields, click on ‘Save and Send Test Request’ to create the task in Asana.

Select the project ID for the task creation. Ensure all required fields are filled before testing. Check Asana to confirm the task has been created successfully.

This integration allows you to streamline your lead management process by automatically creating tasks in Asana for new leads captured from LinkedIn, all facilitated by Pabbly Connect.

Conclusion

Using Pabbly Connect, you can efficiently automate the process of storing LinkedIn Lead Ads leads in Google Sheets and creating tasks in Asana. This integration saves time and ensures that all lead data is captured and organized effectively.