Creating Automated Alerts for Crypto Price Drops with Clay and API Ninjas

One use case that I am trying to solve for: -I have created a Clay table that pulls in data for crypto prices using "API Ninjas" (here: https://app.clay.com/workspaces/322200/tables/t_7KqnuWCzdtyY/views/gv_S3UNEnPyAQMh) -I would ideally like to do the following: #1 - Re-run the "API Ninjas" API call every hour #2 - See if the value for each coin is below a certain amount #3 - If so, text or email me alerting me about the price drop I'm not sure how to solve for #1. #2 is fairly straightforward. For #3, I know Zapier has functionality that can handle this (e.g. using the Twilio API for text or sending me an email via Gmail), but Zapier's integration with Clay seems kind of limited (it looks like all I can do is create or update records or rows). Let me know how best to solve for this, or whether this is functionality that Clay does not yet have at the moment.

4 comments

Daniel K.
·
·
Hi James! Sure thing, happy to assist! There's a workaround available, but it's a bit of a workaround that I wouldn't necessarily recommend. We're currently in the process of developing scheduled runs, which should be rolled out in Q4, although we don't have an exact release date just yet! If you're interested in the workaround, here's how you can go about it: 1. Set up a webhook scheduler in Table A. You can utilize services like make.com, zapier, crontap (which appears to be free), and other automation tools to trigger a webhook to a table. 2. When a new row webhook is received in Table A, a new row is created, triggering the write to another table integration with the 10 Symbols. This will result in them being written in Table B. 3. Once Table B has received the 10 symbols, the HTTP integration will be activated to fetch the prices. 4. In Table B, you can designate a column for your thresholds. If the threshold is surpassed, you can set up a condition to send an email using an HTTP integration. A useful service for this purpose is resend.com, which is free to use! Alternatively, you can look into relay.app and make.com to automate it there! If you require any further assistance, feel free to reach out! 😊 Have a great Thrusday! Daniel
Channeled
APP
·
·
Hey there - just wanted to check in here to see if you needed anything else! Feel free to reply back here if you do.
Channeled
APP
·
·
We haven't heard back from you in a bit, so we're going to go ahead and close things out here - feel free to let us know if you still need something!
Channeled
APP
·
·
Hi James C.! This thread was recently closed by our Support team. If you have a moment, please share your feedback: