Skip to main content

How to store data obtained through Facebook Ad Leads in Google Sheets?

Quickwork
  • Updated

This article demonstrates how to capture the information of a lead through Facebook Ad Leads and store it in Google Sheets.

What you'll need:

Skill level: Intermediate

Time required: 7 minutes

  • Facebook account
  • Facebook page
  • At least one ad created and published on the Facebook page
  • A spreadsheet in Google Sheets

Prerequisites

Create a Facebook Ad Leads form in a specific Facebook page and publish it on all the possible social media platforms such as Instagram, Pinterest, blog pages, etc. from where you can capture the data of leads. For example, refer to the following Facebook Ad Leads form that will be used to explain the journey execution:mceclip0.png

The name of the Facebook page is Automation Quickwork Prod Testing and the name of the Ad Lead form is Lead Generation Campaign. Click here to know how to create a Facebook Ad Lead form page.     

The above Ad Lead form contains five fields i.e. Full name, Email address, Phone number, Country, and ZIP code. 

Now, create a spreadsheet in Google Sheets with a name as Facebook Lead ads data. In the spreadsheet, name the columns as per the name of the Ad Lead form. Refer to the following image:

mceclip1.png

Keeping the column names in the Google Sheets as same as the Ad Leads form fields helps in easy data mapping. 

Configuring the trigger

To set up the Facebook Ad Leads trigger for capturing the data, follow these steps:

  1. Under the Event section, choose the Facebook Ad Leads app from the drop-down menu in the App field.
  2. Select the trigger event, Get all leads, from the drop-down menu in the Trigger Event field.
  3. For authorizing your Facebook account, select an existing connection from the drop-down or create a new connection. 

    Note: While establishing a connection with your Facebook account, ensure you select a Facebook page that has an Ad form page published in it. In our case, I have selected the Automation Quickwork Prod Testing Facebook page that has the Lead Generation Campaign form. Click here to know how to create this new connection.

  4. After a successful connection establishment, the input fields will open. In the Page ID field, select the Facebook page that has the ad form in it. It is the Automation Quickwork Prod Testing page in our case. 

    Note: Ensure you select the same Facebook page here that you have selected while establishing the connection. 

  5. In the Form ID field, select the Ad lead form using which you want to capture the data of leads:

mceclip2.png

Configuring the action

To set up the Google Sheets-Add row action to store the data, follow these steps:

  1. Under the Step section, choose the Google Sheets app from the drop-down menu in the App field.
  2. Select the action, Add row (new version), from the drop-down menu in the Action field.
  3. For authorizing your Google Sheets account, select an existing connection from the drop-down or create a new connection. To create a new connection, simply click the Link account button, choose the Google account which contains the Facebook Lead ads data spreadsheet and click the Link account button. Your connection will get established.

    Note: Ensure you connect the Google account that has the Facebook Lead ads data spreadsheet created. If you connect a Google account that hasn't the corresponding spreadsheet, the column names that we defined previously won't get populated in Quickwork. 

  4. Upon successful connection, the input fields will open. Select Facebook Lead ads data as an input from the Spreadsheet drop-down menu.
  5. Select Sheet1 as an input from the Sheet name drop-down field:

    mceclip3.png

  6. As soon as you select the sheet name, the column names will get populated.
  7. In the Full name field, pass the Text data pill under the Full name data pill from the Get all leads Trigger output. Refer to the following image: 

    mceclip4.png
  8. In the Email address field, pass the Text data pill under the Email object from the Get all leads Trigger output.
  9. In the Phone number field, pass the Text data pill under the Phone number object from the Get all leads Trigger output.
  10. In the Country field, pass the Text data pill under the Country object from the Get all leads Trigger output.
  11. In the ZIP code field, pass the Text data pill under the Zip code object from the Get all leads Trigger output:

    mceclip5.png

  12. The configuration of the journey is completed and it looks like this:

    mceclip6.png

Executing the journey

Click the Save Changes button to save all the changes and then click the Save & Start button. If there are no errors, you'll be taken to the History tab.

Now, go to the Lead Generation Campaign form that we created and configured in the journey. Fill the form details and click the Submit button:

mceclip7.png

After 10 seconds, the data entered in the Lead Generation Campaign form will get stored in the respective columns of the Facebook Lead ads data spreadsheet:

 

mceclip8.png

 

Note: Get all leads is a polling trigger. Polling triggers check for updates every 10 seconds.

Thus, all your lead information from various sources can now be stored in one place using this journey.

Related articles

Comments

0 comments

Please sign in to leave a comment.