Send Conversions to Google Sheets

This is a very simple use case, but it illustrates very accurately what you can do with the data sent by AnyTrack webhooks.

This is a very simple use case, but it illustrates very accurately what you can do with the data sent by AnyTrack webhooks:

Before you begin, make sure you have:

  1. An Integromat account
  2. A Google Sheet account
  3. An AnyTrack account with an active property

What happens when Integromat receives this data?

Integromat is connected with hundreds of applications used every day by marketers, sales, accountants, developers, and professionals that want to automate certain tasks and don't want to hire a developer to build a workflow that connects their apps through an API.

The complexity of getting the data out of an application and into another one is simplified by Integromat since, when you have the data in Integromat, you simply have to select the application you want to send the data to and map the data you received in the webhook with fields available in the destination app.

Some definitions:

  • Scenario - A scenario is a series of tasks you can set up to run automatically. A scenario starts with a Trigger and is generally followed by one or many actions.
  • Trigger - The trigger is what will initiate the scenario to run and is the initial data-receiving point.
  • Action - The action is what will define what you want to do with the data and to which application you want to send it.
  • Tools - Integromat has a set of tools that you can use to manipulate, store, and filter the data received in the trigger.

In the illustration below, you can see the webhook trigger and a choice of application to where you want to send the data:

webhook_destination.png

How to use webhooks to send conversion data to Google Sheet 1. Start by creating a new Zap

Start by creating a new Zap

Select Webhooks by Zapier

The event is what will trigger the Zap to run

Then chose the Event

Select Catch Hook and continue

Copy the Webhook URL provided by Zapier

Now open your AnyTrack Dashboard and navigate to the webhooks section

Create a New Webhook

Name it and paste the Zapier webhook URL

Select the conversion events you want to send to the Webhook

Click on CREATE

Click on TEST and Save

Return to Zapier and click on Test trigger

You can now see the Test event data sent by AnyTrack and Continue

For this example, we are sending data to Google Sheets, but you can select any of the 5000 apps available in Zapier.

Select the app you want to send the data to

Select the action you'd like to perform and continue

Click on Choose the Google Sheet account connected to your Zapier account

Select the Drive, spreadsheet and Worksheet you'd like to send data to

Now click on the field you want to map to open the value to insert

A drop down will open and you can select the field you want to map.

Repeat the same process for each field. you wan to map

Once you've finished mapping all the fields, click on Continue to Test the Action

Click on Test and Review

Now you can open your Google Sheet to verify that the data has been properly sent

Return to Zapier and Publish the Zap

From Now on, every time a conversion event is tracked in AnyTrack, your zap will receive the event data and add it to Google Sheets according to the mapping you've created.

Now Publish & Turn On the Zap