Watch Step By Step Video Tutorial Below






1. Setting Up Pabbly Connect for LinkedIn Leads

To begin integrating LinkedIn leads with Google Sheets and Slack, open Pabbly Connect and log in to your account. The first step is to create a new workflow that will automate the lead capture process. Click on the “Create Workflow” button and name your workflow, such as “Add LinkedIn Leads to Google Sheets and Notify Team in 5 Minutes.” Choose a folder for better organization.

Once your workflow is created, you need to select LinkedIn as your trigger application. The trigger is the event that starts the automation. In this case, the trigger will be a new lead notification from LinkedIn. After selecting LinkedIn, click on “Connect” and follow the prompts to authorize your LinkedIn account.


2. Capturing Lead Details from LinkedIn

After setting up the trigger, you need to capture lead details from LinkedIn. In the trigger event, select “Lead Notification” and click on “Connect.” If you have an existing connection, simply save it; otherwise, create a new connection. Once connected, Pabbly Connect will wait for a webhook response.

To test the connection, generate a test lead from your LinkedIn account. Complete the lead form with the required fields such as email and phone number. After submitting the form, return to Pabbly Connect to check if the webhook has received the lead details. You should see the email and phone number captured successfully.


3. Adding Leads to Google Sheets Using Pabbly Connect

With the lead details captured, the next step is to add this information to Google Sheets. In your workflow, select Google Sheets as the action application and choose the action event as “Add New Row.” Click on “Connect” and authorize your Google Sheets account if prompted.

  • Select the spreadsheet you want to use for storing leads.
  • Map the lead details from LinkedIn to the corresponding fields in your Google Sheets.
  • Ensure that the mapping is done correctly to avoid static entries.

Once the mapping is complete, click on “Save and Send Test Request” to check if the details are added to your Google Sheets. You should see the new lead details reflected in the spreadsheet, confirming that the integration works as intended.


4. Notifying Your Team on Slack

After successfully adding leads to Google Sheets, the final step is to notify your team on Slack. Select Slack as the action application in Pabbly Connect and choose “Send Channel Message” as the action event. Connect your Slack account by following the prompts.

Choose the channel where you want to send the notifications. Draft a message that includes the lead details like name, phone number, and email. Use the mapping feature in Pabbly Connect to dynamically insert the lead information into your Slack message. Once the message is drafted, click on “Save and Send Test Request” to send the message to your Slack channel.


5. Conclusion

In this tutorial, we demonstrated how to use Pabbly Connect to automate the process of capturing LinkedIn leads, adding them to Google Sheets, and notifying your team on Slack. By following these steps, you can save time and streamline your lead management process efficiently.

Utilizing Pabbly Connect for these integrations not only enhances productivity but also ensures that your team stays informed in real-time. Start automating your workflows today!