Watch Step By Step Video Tutorial Below





1. Creating Workflows Using AI in Pabbly Connect

To start integrating Facebook Leads with Google Sheets and WhatsApp, access Pabbly Connect and navigate to your dashboard. Here, click on the “Create Workflow” button and select the option to create using AI. This innovative feature allows you to automate the creation of workflows by simply entering a prompt.

For instance, you can enter a prompt like “When a new lead comes from Facebook leads, save all details in Google Sheets and send a WhatsApp message.” This step is crucial as it sets the foundation for your automated workflow using Pabbly Connect.

2. Setting Up Facebook Lead Trigger in Pabbly Connect

After entering your prompt, the next step involves selecting the appropriate trigger for your workflow. In Pabbly Connect, choose the trigger event as “New Lead Instant” from Facebook Lead Ads. This ensures that your workflow activates immediately when a new lead is generated.

Next, you will need to configure the Google Sheets action. Select the action to “Add New Row” to store the lead data. Lastly, for WhatsApp Cloud API, choose the action to “Send Text Message.” This setup is essential for capturing and utilizing lead information efficiently.

  • Select “New Lead Instant” as the trigger event.
  • Choose “Add New Row” for Google Sheets action.
  • Set “Send Text Message” for WhatsApp Cloud API action.

Once these actions are selected, you can review the workflow setup in Pabbly Connect before proceeding to create it. Approving this setup will finalize your trigger and action selections.

3. Connecting Facebook Lead Ads to Pabbly Connect

With your workflow created, the next step is to connect Facebook Lead Ads to Pabbly Connect. Click on the “Connect” button next to the Facebook Lead Ads trigger. You will be prompted to log in to your Facebook account to establish this connection.

Once logged in, select the Facebook page associated with your business and the specific lead generation form you are using. For example, you might choose the page “Digital Dynamics” and the form “DD Lead Form.” After saving these settings, Pabbly Connect will be ready to capture new leads.

4. Adding Google Sheets Connection in Pabbly Connect

Next, you need to set up the connection between Google Sheets and Pabbly Connect. Click on the “Connect” button next to the Google Sheets action. You will be asked to sign in with your Google account to allow access to your spreadsheets.

After signing in, select the spreadsheet where you want to save the lead details. Ensure that you choose the correct sheet within the spreadsheet, such as “Sheet1.” You will then map the fields for the lead’s name, email, phone number, and company name from the previous step’s data.

  • Select your Google account and allow access.
  • Choose the correct spreadsheet and sheet.
  • Map lead details to the corresponding fields.

After mapping the data, click on the “Save and Send Test Request” button to ensure that the lead data is correctly added to Google Sheets.

5. Sending WhatsApp Messages via Pabbly Connect

To complete the integration, set up the WhatsApp Cloud API connection in Pabbly Connect. Click on the “Connect” button next to the WhatsApp action. You will need to provide your API token, phone number ID, and WhatsApp business account ID.

Once connected, map the phone number of the lead to send the WhatsApp message. You can customize the message to include the lead’s name, such as “Hi [First Name], welcome to Digital Dynamics!” After finalizing the message, click on the “Save and Send Test Request” button to send a test message.

Ensure that the phone number you use is valid to receive the message. If everything is set correctly, you will receive a WhatsApp message confirming the successful integration.

Conclusion

In this tutorial, we explored how to integrate Facebook Leads with Google Sheets and WhatsApp using Pabbly Connect. By automating this process, you can efficiently manage leads and enhance communication with potential customers. Start using Pabbly Connect today to streamline your business workflows!