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 start the flow. This flow is triggered when a row is added to a Google Spreadsheet. 1. Select "My Projects" in the Yoom management screen and click "Send conversion event 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. Check the account linked to Google Spreadsheet and click "Next". *Other items are set by default. 4. Set the trigger activation interval and information about the Google Spreadsheet. *The trigger activation interval options are 5 minutes, 10 minutes, 15 minutes, 30 minutes, and 60 minutes, and the selectable time varies depending on the plan. *The action that triggers the flow is checked once at each selected interval, and if executed, the flow bot is activated. A short interval setting is generally recommended. *You can select the Spreadsheet ID and Sheet ID from the "Candidates" that appear when you click the frame. 5. After completing the above settings, perform a test, and if successful, the obtained 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 sheet below. Step 3: Data Conversion and 0CodeKit Setup Next, set up the conversion of data obtained from Google Spreadsheet into a format that can be sent with the Meta Conversion API. 1. Click "Manipulate & Convert Data Convert Date & Time Format". *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". *Select the date and time to be converted from "When a row is added" in the output that appears when you click the frame. (Values are displayed in double brackets) This allows dynamic reflection of values that change for each row. *Select the same format as the data obtained from Google Spreadsheet for the date and time format to be converted. *Other items are set by default. *For detailed settings on "Manipulate & Convert Data", please refer to the help page [here](https://intercom.help/yoom/ja/articles/8034054-%E3%83%87%E3%83%BC%E3%82%BF%E3%82%92%E6%93%8D%E4%BD%9C-%E5%A4%89%E6%8F%9B%E3%81%99%E3%82%8B-%E3%81%AE%E8%A8%AD%E5%AE%9A%E6%96%B9%E6%B3%95). 3. If the test is successful, the converted data will be displayed in the output. If there are no issues, save it. 4. Click "Integrate with App Hash Text". *Data needs to be hashed when sending conversion events, so conversion is performed here. 5. Check the account linked to 0CodeKit and click "Next". *Other items are set by default. 6. Set the value to be hashed in the message and perform a test. *The type of hash algorithm is set by default. *Select the value to set in the message from "When a row is added" in the output that appears when you click the frame. (The example below is for hashing an email address) 7. If the test is successful, the hashed text 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 the sending of converted data as a conversion event and register the "Trace ID" obtained from the data sending action in Google Spreadsheet. 1. Click "Integrate with App Send Conversion Event". 2. Check the account linked to Meta Conversion API and click "Next". *Other items are set by default. 3. Set up the sending of conversion events. *Select the event name, event occurrence time, and email address from "When a row is updated", "Convert Date & Time Format", and "Hash Text" in the output that appears when you click the frame. (Values are displayed in double brackets) This allows dynamic reflection of values. *Select the action source from the options. *In this flow, only the email address is hashed, but other items can be set by adding the hashing operation in Step 3. 4. After setting the necessary items for sending conversion events, perform a test. If successful, save it. *If the test is successful, the conversion event will be sent. 5. Click "Operate Database Update Record". 6. Check the account linked to Google Spreadsheet. *Other items are set by default. 7. Set up the Google Spreadsheet to register the Trace ID and click "Next". *You can select the Spreadsheet ID and Sheet ID from the "Candidates" that appear when you click 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 that appears when you click the frame on the right side. This searches for the row to register the Trace ID. 9. Set the ID field with the value of the updated record. *Select the ID from "Send Conversion Event" in the output that appears when you click the frame. (Values are displayed in double brackets) 10. After completing the above settings, perform 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. (The items in the sheet below are displayed in "Value of Updated Record" in Step 4, 9) 11. When the trigger is turned ON, a conversion event will be automatically sent with the Meta Conversion API every time a record is registered in Google Spreadsheet. If you have any questions about the flow introduced, please check the help page [here](https://intercom.help/yoom/ja/).