Watch Step By Step Video Tutorial Below





1. Accessing Pabbly Connect for Integration

To begin the integration process, you need to access Pabbly Connect. Start by navigating to the Pabbly website by typing pabby.com in your browser. Once there, sign in using your existing account or create a new one for free, which includes 100 tasks monthly.

After signing in, you will be directed to the Pabbly apps page. Click on Pabbly Connect to access the dashboard where you can manage your workflows. Here, you can create a new workflow by clicking on the “Create from Scratch” option.

2. Creating a Workflow to Capture LinkedIn Leads

In the workflow setup, name your project, such as “Track and Store LinkedIn Leads in Google Sheets Automatically.” Select the appropriate folder for organization and click on “Create” to initiate the workflow. This process is facilitated by Pabbly Connect, which allows you to automate data capture.

  • Name the workflow appropriately.
  • Select the correct folder for the workflow.
  • Click on “Create” to save your workflow.

Once the workflow is created, you will need to set up a trigger application. Select LinkedIn as your trigger, which will activate whenever a new lead is generated. This is a crucial step that Pabbly Connect facilitates, ensuring seamless integration between LinkedIn and Google Sheets.

3. Setting Up the Trigger for LinkedIn Leads

With your workflow created, it’s time to set up the trigger for LinkedIn leads. In the trigger application settings, select “New Lead Notifications” from LinkedIn. Click on “Connect” to establish a connection. If you don’t have an existing connection, opt for “Add New Connection” and enter your LinkedIn credentials.

Once connected, you will need to select the sponsored account from your LinkedIn profile. After selecting the account, click on “Save and Send Test Request” to ensure everything is functioning correctly. This process demonstrates how Pabbly Connect captures leads efficiently, keeping your workflow responsive to new entries.

4. Adding Google Sheets as the Action Application

After successfully setting up the LinkedIn trigger, the next step involves adding Google Sheets as the action application. In the action event settings, choose “Add New Row” and proceed to connect your Google Sheets account. If prompted, select your Google account and grant the necessary permissions for Pabbly Connect to access your sheets.

  • Select “Add New Row” as the action event.
  • Connect to your Google account and authorize access.
  • Choose the spreadsheet where lead details will be stored.

Upon successful connection, select the spreadsheet you created for LinkedIn leads. This integration allows Pabbly Connect to dynamically map incoming lead data into the specified fields of your Google Sheets, ensuring accurate data tracking and analysis.

5. Finalizing the Integration and Testing

To finalize the integration, you will map the lead details from LinkedIn to your Google Sheets. This involves selecting the relevant fields for first name, last name, email, phone number, and company name. Instead of entering these details manually, use the mapping feature in Pabbly Connect to ensure that each new lead populates the correct fields automatically.

Once mapping is complete, click on “Save and Send Test Request” to verify that the data flows correctly from LinkedIn to Google Sheets. After testing, check your spreadsheet to confirm that the lead information appears as expected. This step ensures that your integration is functioning properly, leveraging the full capabilities of Pabbly Connect.

Conclusion

In this tutorial, we demonstrated how to automate the process of capturing LinkedIn leads into Google Sheets using Pabbly Connect. By following these steps, you can streamline your lead management and ensure accurate data tracking.