What I want to do:
In a table I have a series of course names and the start and end dates. I want to automate the process of updating various aspects of a website by sending JSON data via webhook to Make.com.
The process is: If “Start date” is “yesterday”, send table row data to Make via webhook.
How can I do this? (I know how to create a webhook in ST)
One way I can do what I need is to automate the sending of an email and have a mailhook as the recipient email address. I can then parse the email body text in the following steps. I just wanted to see if there was another way to do it.
Now, I would create a make.com action to check every day for entries where “Yesterday = -1”. Then run your actions and update the checkbox and set this to “checked” to avoid that an entry is processed twice in make.com
Easy, isn’t it?
Why not a webhook?
Webhooks is from my point of view not the right solution. a) you have to program a lot by yourself and you will receive a webhook for every change in your table - but you only want some specific actions.
Trigger by E-Mail?
I didn’t get what you try to achieve. Use a normal trigger that checks the content of your base.