Playbooks
Implement Real-Time Conversions Tracking with Zapier and Google Sheets
13min
overview this playbook will guide you on integrating zapier with momentscience to live track conversions and record them in a google sheet by using a publisher postback system, you can process conversions in real time and keep an organized, up to date record of postbacks for easy tracking and analysis postbacks are notifications sent to your designated url whenever a revenue event associated with an offer is recorded handling postback events docid\ jggrs dnl6sskmhsjehuz prerequisites momentscience account ensure you have an active momentscience account if you don’t have an account, contact us now https //momentscience com/contact us zapier account ensure you have an active zapier account access to google sheets ensure you have access to a google sheet to store the records integration steps have a look at this demo for a quick understanding of how the process will look adding webhook trigger in zapier 💡step goal create a new workflow triggered by a conversion using zapier webhook our first step is to set up zapier we will create a new "zap," which is an automated workflow in this workflow, we will configure a webhook that triggers whenever a new conversion happens within momentscience navigate to https //zapier com/app/zaps click on the “create” button and choose “zaps automated workflow” now configure your first trigger select “webhooks by zapier” for the event, choose “catch hook” and click “continue” skip any additional trigger setup steps and click “continue” in the test section, view and copy the webhook url provided this url will be used to send requests click on the “start testing” button zapier has a “copilot” to speed up the process next time you create an automated workflow, use the following prompt “create a webhook by zapier that, when triggered, will create a new record in a google sheet ” adding the url as a postback url to the momentscience dashboard 💡step goal link zapier & momentscience by inserting the url provided by zapier in the momentscience dashboard next, we need to paste the url provided by zapier as a postback url in the publisher’s momentscience dashboard navigate to the “configuration” page in the publisher’s dashboard momentscience configuration https //app momentscience com/account/settings/behavior paste the url provided by zapier into the “postback url” field click the “save configuration” button trigger a dummy data to ensure the process is running smoothly click the “test postback” button this will trigger a dummy data postback that will be shown in zapier verify in zapier that the dummy data is received and the process is working correctly once done, click on “continue with selected record” configure zapier to record in google sheets 💡step goal configure zapier automation to record each new conversion in google sheets once we have set up our webhook url, we want to ensure that each time the webhook is triggered, a new row is created in a google sheet with the conversion data add google sheets action click on “action” and search for “google sheets ” select “create spreadsheet row” as the event and click “continue ” authenticate google account in the account section, authenticate and link zapier with your google account this integration will allow zapier to access your google sheets configure the action choose the google sheets account you want to use select the specific google sheet and the worksheet where you want to add the data map the data fields from the webhook to the corresponding columns in your google sheet based on the headers you have inserted click “continue” ensure your google sheet has headers that correspond to the data fields you will retrieve from the webhook payload for example advertiser name offer id timestamp user id payout testing & publishing the integration 💡step goal test the automation steps to ensure each conversion is recorded in google sheets once you have configured the zapier action to record data in your google sheet, it is essential to test the setup to ensure everything is working correctly test the action in zapier, click on the “test step” button this should send the payload data to the selected google sheet verify the data navigate to your google sheet and check that a new row has been created ensure the data fields are correctly mapped to the corresponding columns based on the headers you have inserted (e g , advertiser name, offer id, timestamp, user id, payout) publish zap after successfully testing the integration, the final step is to publish your zap to ensure it runs automatically whenever a new conversion occurs publish the zap once you have confirmed that the installation is done correctly, click the “publish” button in zapier wait and verify allow some time for the integration to be published the zap should now work automatically, creating new rows in your google sheet whenever a new conversion occurs conclusion integrating zapier with momentscience for live tracking conversions and recording them in google sheets is a powerful way to keep your data organized and up to date this setup not only streamlines your workflow but also enhances your ability to make informed decisions with real time data momentscience's flexibility allows you to connect with virtually any platform, unlocking endless possibilities for automation and efficiency by leveraging the power of momentscience, you can easily integrate other services, customize your workflows, and create a seamless, automated experience tailored to your unique needs 📢 if you're running into any issues while going through the integration process, feel free to contact us at help\@momentscience com mailto\ help\@momentscience com