Connect Google Sheets to Facebook Conversions API with LeadsBridge
This article is a simple guide on how to set up the bridge and connect Google Sheets to Facebook Conversions API.
How to set up the bridge step-by-step tutorial
Before you start
- Head over to the left sidebar and click on Facebook Suite.
- Click Facebook Conversions API.
- You'll be taken to the Facebook Conversions API section of your account.
- Click on Add New.
- You'll be taken to the first step of the bridge creation.
Step 1: Account destination
- Select the Facebook Ad Account you want to assign the Facebook Conversions API.
- Select the Facebook Business Manager associated.
- Click Next.
Step 2: Choose your Facebook Conversions API settings
- Pick an existing Custom Conversion or choose to create a new one from the drop-down.
- In case of a new one, enter the name for your Facebook Conversions API (this will be visible inside your Business Manager).
- Add some labels to identify your bridge later in LeadsBridge.
- Click Next.
Step 3: Setup your Google Sheets source
- Choose Google Sheets as source of your contacts.
- Select to use an existing integration or to create a new one.
- Click Next.
You may skip the integration part if your integration has been already configured.
Integrate Google Sheets with LeadsBridge
- Type in the name you'd like to call your integration to recognize it later.
- Click on the Authorize button.
- Login to the account you'd like to use.
- Allow LeadsBridge to access your Google Sheets information.
- Once done you'll be taken back to the bridge with a blue info success message.
- Click Next.
- Select the segment you'd like to use as the source for your contacts.
- You may also add filter conditions by clicking the Source Filter button:
- Add conditions to filter contacts and tailor specific segments.
- Remember that source data will be processed only when all conditions added are met.
Here you can map your Google Sheets information with your destination fields.
You'll see a field name with the destination integration's logo at the top, this indicates the name of the field on Facebook Conversions API.
Underneath there's a box where you may add the information you'd like to send.
- Check each of the Facebook Conversions API fields available and match the data you wish to sync from Google Sheets.
- Map as many fields as possible to achieve higher performing data matching to people on Facebook.
- Please remember to specify these mandatory fields to create the Event Set:
- Event Name: the event type;
- Event Time: when the conversion occurred;
- Event Value: the value of the conversion, like the amount spent;
- Transaction Currency.
- Email and Phone can accept up to 3 values, thus allowing to create better-performing retargeting.
- Static values can be added only for Event Name, Transaction Currency, Country Code, Gender and U.S. State fields.
- You may also leave blank the box of a field's information you don't want to send through.
Adding more information is simple and straightforward:
- Head over the "Would you like to add more information?" box at the bottom of the page.
- Select the field you'd like to add from the dropdown list.
- Click the Map this field button.
- The field will appear above.
- Add the desired information, as you did with the other ones.
Custom Data can be used for creating segments in your reporting or building custom audiences next.
Custom Data is not used for matching offline events to people on Facebook.
- Add the Custom Data custom field from the dropdown at the bottom.
- Select one or more information you'd like to add to your conversion inside the Custom Data field, for example the Category and the Location of a customer's order.
Once accomplished your desired outcome, click Next.
Here you can Edit the source created, Delete it or Add Another Source to combine different sources into your Facebook Conversions API.
If you'd like to add other source data, please click Add Another Source and repeat the Step 3 to setup your new source.
Once done, click Next and head to the last step.
Step 4: Summary
- Before proceeding, please check the information recap.
- Choose if you'd like to run a Simulation or you're ready to go Live.
- Simulation mode provides you with the opportunity to elaborate source data excluding the data sync process. The outcome is a report in order to verify the information processed.
- Live mode process source data and sync information with Facebook Conversions API as the outcome. Activate this when you're ready to go live.
That's all! Congratulations.
Your bridge will now start the sync process to gather all the information. Once ready, it will be synced and updated automatically.
- Getting Started with the Conversions Sync
- Offline Conversions Sync step by step guide
- Offline Conversions FAQ's
If you have any other questions, or need help to configure your bridge from Google Sheets to Facebook Conversions API with LeadsBridge, do not hesitate to contact our Support!