Send an email notification when any value in a specified set of columns in MySQL is updated.
This automation triggers an email whenever values in a MySQL column change to match a specified condition.
Connect your MySQL database to Lido's spreadsheet, no code required. Lido will pull in the latest data from MySQL on a schedule as frequently as once every 5 minutes.
Use spreadsheet formulas to work directly with your connected MySQL data and create a custom trigger for when certain conditions are met.
IF(D2 = "In progress", SENDGMAIL(<sender-credential>, "recipient@email.com", "Task is now in progress"))
Send a personalized email from Gmail or Outlook account for each row that meets the criteria
SENDGMAIL(<sender-credential>,"recipient@email.com","Change in status","[Task] status has changed to In progress")