How to send conversion events with the Meta Conversion API when a record is registered in Google Sheets

・Click "Try this template" to complete the copy.

‍

Step 2: Setting up the Trigger Google Spreadsheet

Set up the trigger action that will be the starting point of the flow.
This flow is triggered when a row is added to the Google Spreadsheet.

1. Select "My Projects" in the Yoom management screen and click "Send conversion events with Meta Conversion API when a record is registered in Google Spreadsheet [Copy]".
* You can change the template title on the next screen.

‍

‍

2. Click "App Trigger When a row is added".

‍

‍

3. Verify the account linked with Google Spreadsheet and click "Next".
* Other items are set by default.

‍

‍

4. Set the trigger activation interval and information related to the Google Spreadsheet.
* Trigger activation intervals are available at 5, 10, 15, 30, and 60 minutes, and the selectable time varies depending on the plan.
* The trigger action is checked once at each selected interval, and if executed, the flow bot is activated. A short interval setting is generally recommended.
* Spreadsheet ID and Sheet ID can be selected from the "candidates" displayed by clicking the frame.

‍

‍

5. After completing the above settings, conduct a test, and if successful, the acquired information will be displayed in the output.
If there are no issues, save it.

‍

‍

* In this case, the above items are displayed in the output because the test was conducted on the following sheet.

‍

Step 3: Date and Time Format Conversion Setup

Next, set up the conversion of data obtained from Google Spreadsheet into a format that can be sent via Meta Conversion API.

1. Click "Date and Time Format Conversion".
* The "Event Occurrence Time" set when sending conversion events is specified in UNIX time, so conversion is performed here.

‍

‍

2. Set the date and time to be converted and click "Test".
* The date and time to be converted can be selected from "When a row is added" in the output displayed by clicking the frame.
This allows dynamic reflection of values that change per row.
* Select the same date and time format as the data obtained from Google Spreadsheet for the date and time format to be converted.
* Other items are set by default.
* Detailed settings for "Manipulate and Convert Data" are explained on the help page.

3. If the test is successful, the converted data will be displayed in the output.
If there are no issues, save it.

‍

Step 4: Sending Meta Conversion API and Google Spreadsheet Setup

Finally, set up to send the converted data as a conversion event and register the "Trace ID" obtained from the data sending action in the Google Spreadsheet.

1. Click "Integrate with App Send Conversion Event".

‍

‍

2. Verify the account linked with Meta Conversion API and click "Next".
* Other items are set by default.

‍

‍

3. Configure the settings for sending conversion events.
* Click the frame to display the output, and you can select values ​​from "When a row is updated" and "Date and time format conversion".
This allows dynamic values ​​to be reflected. * Select the action source from the options.

‍

‍

‍

4. After setting the necessary items for sending conversion events, conduct a test.
If successful, save it.
* If the test is successful, the conversion event will be sent.

‍

‍

5. Click "Operate Database".

‍

‍

6. Verify the account linked with Google Spreadsheet.
* Other items are set by default.

‍

‍

7. Set up the Google Spreadsheet to register the Trace ID and click "Next".
* Spreadsheet ID and Sheet ID can be selected from the "candidates" displayed by clicking the frame.

‍

‍

8. Set the conditions for the record you want to update.
* Set the item that will be a unique value on the left side, and select the corresponding item from "When a row is added" in the output displayed by clicking the frame on the right side. This will search for the row to register the Trace ID.

‍

‍

9. Set the ID field with the value of the updated record.
* ID can be selected from "Send Conversion Event" in the output displayed by clicking the frame.

‍

‍

10. After completing the above settings, conduct a test, and if successful, save it.
* If the test is successful, the Trace ID will be added to the specified sheet as shown below.

‍

‍

11. When the trigger is turned ON, conversion events will be automatically sent via Meta Conversion API every time a record is registered in Google Spreadsheet.

‍

‍

Other Automation Examples Using Google Sheets and Meta Conversion API

In addition to the flow introduced this time, you can achieve various business automations by using the APIs of Google Sheets and Meta Conversion API.
All of them can be used with simple settings, so if you find something that interests you, please give it a try!

Other Automation Examples with Google Sheets and Meta Conversion API

When a row is added to Google Sheets, it is also possible to obtain and update reports on Meta Ads (Facebook).
Additionally, by integrating Yoom's schedule trigger and Slack, you can implement an automated flow that notifies you after adding the latest ad report obtained to the database.

Automation Example Using Google Sheets

Add a Record When a Row is Added in Google Sheets

By eliminating manual data entry, input errors should decrease, maintaining data accuracy.

Receive an Email Notification When a Row is Added or Updated in Google Sheets

By integrating Yoom's email feature, it may be possible to prevent human errors such as transcription mistakes and missed notifications.

Translate the received content into English and add it to Google Sheets

By automating translation and writing to Google Sheets, you can reduce working time.

Automation Example Using Meta Conversion API

Sending Conversion Events with Meta Conversion API Using Form Contents

By treating submissions from forms as conversion events, you can more accurately understand the effectiveness of Meta ads.

Send conversion events with the Meta Conversion API when a lead is registered

This can reduce the workload on staff and also decrease the risk of errors such as input mistakes and missed submissions.

Benefits of Integrating Google Sheets with Meta Conversion API

Benefit 1: Reduce Time Spent Sending Conversion Events

Manually sending event information managed in Google Sheets to the Meta Conversion API can often be a burden for those responsible.
If events occur daily, frequent sending is necessary to obtain the latest information, but it might be delayed due to other pressing tasks.
By integrating Google Sheets and the Meta Conversion API, you should be able to automatically send conversion events, thus reducing the time spent by the person in charge.
For example, in the case of a marketing consultant, as the number of client companies increases, so does the sending work, but automation could increase the time available for other tasks.

Benefit 2: Smooth Sending of Conversion Events

When sending conversion events manually, it can take time, resulting in a time lag between registering information in Google Sheets and sending it via the Meta Conversion API.
Integrating Google Sheets with the Meta Conversion API will likely enable smooth sending of conversion events.
For example, when managing event information in a marketing department, there may be times when the person in charge is too busy with multiple tasks to register event information anywhere but Google Sheets.
Even in such cases, using this integration is expected to smooth out the sending of conversion events, leading to improved work efficiency.

Benefit 3: Enable Analysis with the Latest Data

Even if you manage the latest event information in Google Sheets, you cannot analyze the latest data if the conversion event sending is not timely.
By integrating tools, you should be able to automatically send conversion events registered in Google Sheets, enabling data analysis based on the latest information.
For example, when running a campaign, adding data to Google Sheets will automatically send conversion events, leading to rapid analysis of the latest data and contributing to ad optimization.
This might strengthen data-driven marketing and secure a competitive advantage.

Conclusion

This time, we introduced a method to automate the task of 'converting event information managed in Google Sheets and sending it as conversion events via the Meta Conversion API.'
By implementing this automation, you should be able to reduce manual sending tasks and enable smooth sending of conversion events.
Additionally, analysis with the latest data should also be achievable.

The integration of the three tools can be achieved without code by using Yoom.
By simply following the steps explained in this article, you can implement it, so take this opportunity to incorporate automation.