Select New or Updated Spreadsheet Row as the event trigger.

Create a Google Sheet, and create 4 columns (event, product, value, and TID).

In the next row, for event enter Purchase or Lead, depending on what you are tracking.\
\
For the other columns, use the data from your PayKickStart reports. For example, in value enter the commission amount, and in product enter the name of the product or offer you are tracking. \
\
For TID copy the TID value associated with the event, also available in PayKickStart. If your reports don't show any TID, ensure that your links are correctly tagged and that events have happened after installing the AnyTrack Tag on your page.

Back on Zapier, select the spreadsheet you just created.

You will be able to trigger the automation to get one record. Once you get that record select "Continue with selected record".

Then you'll have to define what will be done every time a record arrives from Google Sheet. You will be sending the record to AnyTrack using webhooks.\
\
Select Webhooks by Zapier.

In URL, paste the URL of the Custom Integration that you created in Step 1: <https://readme.anytrack.io/docs/paykickstart#step-1-install-a-custom-integration>

On Data you will define the names used to send the column headings from Google Sheets (event, product, value, and TID). \
\
use **click_id** to send the TID\
use **event_name** to send the event\
use **value** to send the value\
use **product** to send the product

Check  the Events Log of the Custom Integration to see the event sent by Zapier.

Every time you enter a row in Google Sheets, Zapier will send the data to AnyTrack. Connect your ad networks to AnyTrack to automatically send them the event, which will include the ad campaign that generated brought the visitor to your website.

Paykickstart

Since PayKickstart no longer sends the tid tracking parameter in its notifications for affiliates, this guide explains how to enter the tid value manually on a Google Sheet connected to a Zapier automation that will send the conversion to AnyTrack using a webhook.

Push PayKickstart Affiliate Conversions to AnyTrack using Google Sheets and Zapier