Facebook and Google Sheets integration

Facebook and Google Sheets integration
Facebook
·
1/26/2022
·
3 min. read
eye

In this tutorial, you will learn how to send data from Facebook (Ad leads) to Google Sheets (spreadsheets). First, connect the apps to Albato:

- Connecting Facebook to Albato

- Connecting Google Sheets to Albato

Create an automation

Sign in to your Albato account. Go to the Automations page and click New button.

Then set up the app to send the data from. Select:

  • From — Facebook.
  • Event — Ad Lead.
  • Business Manager connection and an advertising account. If you have not created the connection, you can create it now.

When you fill in these fields, the system will open two additional parameters to specify Page and Form.

pub-img-7952-1.png

Select the operation mode

Next step is to select the way of data sending. In this tutorial we will use real-time operation mode.

2022-08-16_13-24-25.png

Set up the app to receive data

  • Where — Google Sheets.
  • Action — New sheet row.
  • Connection — if you have not created a connection, you can create it now.
  • Select required spreadsheet and sheet as an additional parameters

pub-img-7952-3.png

Set up fields

This step is to specify the fields. Each field corresponds to a column in a selected Google Spreadsheet. Specify the values for these fields from the Facebook drop-down list. Use the fields that are necessary for the correct processing of leads.

We advise you to send user contacts and name, as well as Ad/campaign ID.

Now select the rule for duplicate processing. Each new lead is a unique entity, so select «always create a record».

The automation is created, don’t forget to start it!

Example of the automation:

2022-08-18_09-36-27.png

Use Facebook Tool to test Ad leads sending to your  Google Spreadsheet. Please notice that Google Sheet receives test lead within ~ five minutes.

Lead Ads Testing Tool

Attention! If you have created a page with Ad lead and cannot find it in Albato even after updating the data. Please open the business integrations settings of FB «Albato» and check the required pages with lead forms.  https://www.facebook.com/settings?tab=business_tools


Facebook
Google Sheets