Is it possible to automate a workflow in a WordPress website such that when a new row is added to an underlying MySql database table an external WebHook is invoked?
I recently converted a website from SquareSpace to to WordPress because I needed to use plug-ins and more customization.
I’ve got a plug-in that creates new records in it’s MySql table and it sends out an email with each time.
Using Zapier email parser and Zapier integration via Webhook to a SaaS app, I’ve got everything working, but Zapier is expensive to use as I have more than 100 zaps per month.
Since the ultimate destination is a SaaS with a published Webhook interface, I would like to remove the email-to-Zapier part of the workflow and just have WordPress directly invoke the Webhook when a new record is added.
Haven’t done any MySql work in a long time, wondering if there is a straightforward way to create a trigger (or equivalent) in MySql itself to call the Webhook whenever a new row is added to a table.
Note: the plug-in I am using is commercial so I don’t have access to the source code to make the changes directly in the plug-in itself (which would be the ideal place for this automation).