How to organize automatic mailing of letters on events using mailwizz or interspire systems?

Question

Automation

As an example on the interspire system:
There is a list of clients with fields: email, name, status.
Status (status) can be changed via API. This is our example event.
How to organize automatic mailing of letters on events in mailing management systems?
If the status has changed from "New" to "In Process" send an email. After that, the status changed from "In Process" to "Completed" to send a series of letters, and if not all letters have yet been sent and the status has changed, then stop this queue.
Transfer lead data between sheets or create triggers? What is the principle and if it exists at all?

Answer 1

according to normal, the sheet should live in the database,
for each soap the status changes according to the fact how you set it up (letter leaving, sending commands, time expiration)
and mailwizz and interspire have an API / SDK, which means that the proger can set up sending based on any data
further the usual logic
time = min/max( trigger, closing time of the previous one), if the time is less/greater than 1 s = execute (step1/step2/step3)
i.e. data handling (mails and statuses) - separately, sending - separately.