Trigger scenario when new row is added to MySQL

How To
,
1

I am trying to send an email (Gmail) when a new row is added to a MySQL database using the MySQL fields to populate the email fields. It works with a webhook - when the body of the email is short and simple. It does not work when the email is long and HTML formated.

I suspect the results would be better if the source data did not come from URL variables via the webhook but instead came directly from the MySQL. However, I can not figure out how to start the scenario when a new row containing the new email data is added. Is that possible?

2

There is no “Watch New Items” for SQL.

Basically, your table will need a “Date Created” timestamp column, so that you can search/query for items created after the previous scenario run.

This means you will need to continuously poll the SQL server regularly to check for new changes.

Hope this helps! Let me know if there are any further questions or issues.

— @samliew

P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.