How to Add Astrology Business Leads to Google Sheets Using Pabbly Connect

Learn how to integrate Facebook Leads with Google Sheets using Pabbly Connect for your astrology business seamlessly. Master proven automation processes with practical implementation examples and strategic recommendations you can apply immediately in your workflow.

Watch Step By Step Video Tutorial Below

1. Access Pabbly Connect for Integration

To begin the integration process, access Pabbly Connect by visiting the official website. You can sign up for free if you don’t have an account yet, which takes only a couple of minutes. Once registered, log in to your account to access the dashboard where you can create workflows.

Once logged in, click on the Access Now button under Pabbly Connect. This leads you to the workflow section where you can create new integrations. For this tutorial, we are focusing on capturing leads from Facebook and adding them to Google Sheets.

2. Create a New Workflow in Pabbly Connect

In the Pabbly Connect dashboard, click on the Create Workflow button to start setting up your integration. Name your workflow something descriptive like ‘Astrology Business Leads to Google Sheets’. Choose the folder where you want to save this workflow.

Next, you will see two boxes for Pabbly Connect: Trigger and Action. The trigger is the event that starts the workflow, and the action is what happens as a result. For this integration, we will set Facebook Lead Ads as the trigger and Google Sheets as the action.

3. Set Facebook Lead Ads as Trigger in Pabbly Connect

To set up the trigger, search for Pabbly Connect and select Facebook Lead Ads. Choose the trigger event as New Lead Instant. Click on Connect to establish a connection with your Facebook account.

• Select your Facebook page where leads will be captured.
• Choose the lead generation form that you created for your astrology business.
• Ensure that the form is live to capture test leads.

After selecting the necessary details, click on the Save and Send Test Request button. This action will prepare the integration to receive lead data from Facebook.

4. Set Google Sheets as Action in Pabbly Connect

Now, we will set Google Sheets as the action application in Pabbly Connect. Search for Google Sheets and select it. The action event should be Add New Row to ensure that new leads are added as rows in your spreadsheet.

Connect to your Google account by clicking on Add New Connection and follow the prompts to authorize access. Once connected, select the specific spreadsheet you want to use for storing leads.

• Choose the spreadsheet named ‘Facebook Leads’.
• Select the sheet within the spreadsheet (e.g., Sheet1) where the data will be stored.
• Map the fields from Facebook leads to the corresponding columns in Google Sheets.

Once all fields are mapped correctly, click on Save and Send Test Request to ensure that the integration works as expected.

5. Test Your Integration with Sample Leads

To confirm that your integration between Facebook Lead Ads and Google Sheets via Pabbly Connect is successful, create a sample lead submission. Go to your Facebook lead generation form and fill it out with dummy data.

After submitting the form, return to Pabbly Connect and check if the new lead details appear in your Google Sheets. You should see the data populated in the specified columns, verifying that the integration is functioning correctly.

Ensure that the dummy lead data matches the fields in Google Sheets. Repeat the process to add more leads and confirm real-time updates.

This testing ensures that every new lead captured through Facebook will automatically be recorded in your Google Sheets, streamlining your data management process.

Conclusion

Using Pabbly Connect, you can seamlessly integrate Facebook Lead Ads with Google Sheets to manage your astrology business leads efficiently. This automation allows you to capture lead details instantly, ensuring that your records are always up-to-date and accessible.