In this tutorial, I am going to demonstrate how to automatically send data from a Google Sheet as a server event to your FaceBook Business Manager using the Facebook Conversions API.
You can build a simple integration which is called a scenario on Integromat to take care of this for you, without writing a single line of code.
In this example, details of a purchase order are added to a Google Sheet.
Configuring the scenario
The scenario consists of the following modules:
- Google Sheets > Watch rows
- Facebook Conversions API > Send event(s)
This is the scenario builder and the first step is to search for the Google Sheets app:
Here you can see all the modules available. For this case, select the Watch rows module:
Now you need to add a connection or select an existing one here:
Next, select the Spreadsheet and the specific sheet that contains the data:
Now search for the Facebook Conversions API app and select the Send Events module. Again, you can add or select an existing connection:
Next, enter the Pixel ID in this field here:
Now you need to enter the specific data retrieved from the Google Sheet that you want to send to Facebook for this specific action. This is where you can start to connect purchases to certain audiences for better product targeting.
So under Data, click Add item:
Since these are purchased orders, select the Purchase option under Event name:
All you need to do now is map the elements outputted by the Google Sheets > Watch rows module to the corresponding fields here. Currency to the Currency field, Total Price to the Value field and so on:
Another advantage Integromat gives, is you can also choose how often you want it to run, at regular intervals, daily, monthly etc. By default, it’s scheduled to run every 15 minutes:
Now click run once to execute the scenario:
Alright. The scenario executed successfully. Here you can see that the details of the order were retrieved from the Sheet:
and sent to the Facebook Conversions API as intended:
The last step is to save the scenario and turn it on by clicking the switch here:
So that demonstrates how data from a Google Sheet can be sent over to your Events manager using the Facebook Conversions API. And the cool thing is, Integromat has 100s of apps that can be used to connect to Facebook.