Integrate Facebook Lead Ads with Google Sheets and ConvertKit Using Pabbly Connect

Learn how to automate the addition of Facebook Lead Ads leads to Google Sheets and create subscribers in ConvertKit using Pabbly Connect. Navigate the automation landscape confidently with clear, structured guidance suitable for professionals regardless of prior technical experience.

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 typing ‘Pabbly.com/connect’ in your browser. This is the platform that will facilitate the connection between Facebook Lead Ads, Google Sheets, and ConvertKit.

Once on the Pabbly Connect page, you will see options to sign in or sign up for free. As a new user, you can create an account to get 100 free tasks every month. If you’re an existing user, simply sign in to your dashboard to proceed.

2. Creating a Workflow in Pabbly Connect

After signing in, you will be directed to the Pabbly Connect dashboard. Here, you need to create a new workflow. Click on the ‘Create Workflow’ button located at the top right corner of the dashboard. using Pabbly Connect

• Name your workflow, for example, ‘Add Facebook Lead Ads Leads to Google Sheets and Create a Subscriber in ConvertKit’.
• Choose to save this workflow in a folder named ‘Automation for Facebook Lead Ads Leads’.

Once you have named your workflow and selected the folder, click on the ‘Create’ button to proceed. This sets up the foundation for your automation where Pabbly Connect will manage the trigger and actions.

3. Setting Up Trigger and Action in Pabbly Connect

The next step is to define the trigger and action for your workflow. In Pabbly Connect, triggers are what initiate the workflow, while actions are the responses to those triggers. For this integration, the trigger application will be Facebook Lead Ads. using Pabbly Connect

Select ‘Facebook Lead Ads’ from the trigger application list and choose the event as ‘New Lead Instant’. This means that every time a new lead is generated, Pabbly Connect will capture the details automatically. After setting up the trigger, you will now define the action to add these lead details into Google Sheets.

• Choose ‘Google Sheets’ as your action application.
• Select the action event as ‘Add New Row’ to insert lead details into your specified Google Sheet.
• Add ConvertKit as another action application to create a subscriber.

This setup allows you to automate the entire process of capturing leads and managing them efficiently.

4. Connecting Facebook Lead Ads to Pabbly Connect

To connect Facebook Lead Ads with Pabbly Connect, click on the ‘Connect’ button. You will need to authorize Pabbly Connect to access your Facebook account. Ensure you are logged into your Facebook account before proceeding.

Once authorized, select the page you are using for your lead ads. Then, choose the specific lead generation form from the dropdown menu. This step is critical as it ensures that Pabbly Connect captures the correct lead data.

Select the lead form you wish to use from the list of forms created in your Facebook account. Click on ‘Save and Send Test Request’ to check if the connection is successful.

After the test request, you will need to perform a test submission through the lead form to ensure the data is captured correctly in Pabbly Connect.

5. Adding Leads to Google Sheets and Creating Subscribers in ConvertKit

Once the test submission is complete, navigate back to Pabbly Connect. You will see the lead details captured successfully. The next step is to connect Google Sheets with Pabbly Connect to store these details. using Pabbly Connect

Click on the ‘Connect’ button for Google Sheets and authorize access to your Google account. Select the spreadsheet you created for this purpose. Ensure you map the fields correctly using the data from the Facebook lead submission.

Map the fields such as first name, last name, email, phone number, and city from the lead details. Click on ‘Save and Send Test Request’ to confirm that the lead details are added to your Google Sheets.

After confirming the addition to Google Sheets, proceed to connect ConvertKit. Enter your API key and secret from your ConvertKit account settings to create a subscriber using the lead details captured by Pabbly Connect.

Conclusion

In this tutorial, we explored how to utilize Pabbly Connect to automate the process of adding Facebook Lead Ads leads to Google Sheets and creating subscribers in ConvertKit. This integration streamlines your workflow, ensuring that new leads are efficiently managed and nurtured for better engagement.