Detecting Click Changes in API for Webhook Notification

Hey! I have an API that returns number of clikcs into a shortened URL. I setup this clay column to run once a day. How can I make clay detect if the number of clicks changed between yesterday and today so that it can send me a webhook at the next step?

15 comments

Sławom P.
·
·
Sławom P.
·
·
if number of clicks changes between yesterday and today, send a webhook
Sławom P.
·
·
what’s the easiest way to achieve that?
Channeled
APP
·
·
To detect changes in click numbers and trigger a webhook, you can use Clay's Auto-Update feature along with a custom formula. Here's how: 1. Set up your API column to run daily, fetching the click data. 2. Create a new column with a formula to calculate the difference between today's and yesterday's clicks. 3. Enable Auto-Update for your table to process new data automatically. 4. Set up a webhook as the next step in your workflow. 5. Configure the webhook to trigger when the difference column shows a non-zero value. This setup will automatically detect changes in click numbers and send the data to your specified webhook endpoint when a change occurs. If you need more detailed guidance on setting this up, please ask for human assistance by clicking on "Talk to a person".
Source: Webhook source guide | Documentation | Clay University
Channeled
APP
·
·
Was that helpful?
Channeled
APP
·
·
Here's the easiest way to set up a webhook in Clay to detect click changes: 1. Create a new table or use an existing one. 2. Add a webhook source by clicking "Create New" and selecting "Import data from Webhook" under "Other". 3. Copy the generated webhook URL. 4. Set up your API to send daily click data to this URL. 5. In Clay, create a formula column to calculate the difference between today's and yesterday's clicks. 6. Enable Auto-Update for your table to process new data automatically. 7. Set up a webhook action to notify you when the difference is non-zero. This setup will automatically detect and notify you of click changes between yesterday and today.
Sources: Import Data to Clay Using Webhooks Webhook source guide | Documentation | Clay University
Channeled
APP
·
·
Is that what you were looking for?
Sławom P.
·
·
talk to human
Channeled
APP
·
·
Looks like you're still looking for help.
If you’re dealing with a specific table, drop the URL below so we can help you quicker. Otherwise, someone from our team will be in touch soon!
Sławom P.
·
·
how Can I make the column store value from yesteray? right now if I just put it as equal it gets immediately updated
Sławom P.
·
·
https://app.clay.com/workspaces/257344/workbooks/wb_9v2jhtEGwgwg/tables/t_Y4y86dMsSnXT/views/gv_m4tYGXS4dFRj
Sławom P.
·
·
thats my table
LuisArturo
·
·
Hey there Slawomir, thanks for reaching out, taking a look at this, this will be very hard to do since the value gets overwritten every day and Clay formulas are unable to store the previous value. You would need to manually add columns with each updated number here.
😞1
LuisArturo
·
·
I understand that this is the step you wanted to use in order to setup a webhook, however in this case a webhook would work better for these results as the values would be added each time this call is made daily
Sławom P.
·
·
Thanks