Scenario execution, cycles and phases

Integromat is a transactional system, similarly to relational databases. Each scenario execution starts with the initialization phase, continues with at least one cycle composed of the operation and commit/rollback phases and ends with the finalization phase:

cycle #1
  operation (reading or writing)
  commit or rollback
cycle #2
  operation (reading or writing)
  commit or rollback
cycle #N
  operation (reading or writing)
  commit or rollback


During the initialization phase, all necessary connections (connection to a database, email service, etc.) are created. They are also checked if each module is capable of performing their intended operation(s).


Each cycle represents an undividable unit of work composed of a series of operations. It is possible to set the maximum number of cycles in the scenario settings panel. The default number is 1.


During the operation phase reading and/or writing operation is performed:

  • The reading operation consists of obtaining data from a service that will then be processed by other modules according to a predefined scenario. E.g. the Dropbox > Watch files module returns new bundles (files) created since the last scenario execution.
  • The writing operation consists of sending data to a given service for further processing. E.g. the Dropbox > Upload a file module uploads a file to a Dropbox folder.


If the operation phase is successful for all modules, the commit phase begins during which all operations performed by the modules are committed. This means that Integromat sends information to all the services involved in the operation phase about its success.


If an error occurs during the operation or commit phase on any module, the phase is aborted and the rollback phase is started, making all operations during the given cycle void. Some modules do not support rollback and operations performed by these modules cannot be taken back. For more information see the ACID modules section.


During the finalization phase, open connections (e.g. FTP connections, database connections, etc.) are closed and the scenario is completed.

ACID modules

The modules that support rollback (transactional modules) are tagged with the ACID tag:


The modules not tagged with this tag do not support rollback and cannot be reverted back to their initial state in case of error in other modules.

A typical example is the Email > Send an email module. Once the module sends and email during its operation phase, the sending cannot be undone.


Transfer of bundles between databases

The following example shows how to connect three ACID modules. The aim of the below scenario is to get new rows from a MySQL database, insert (transfer) them into a MSSQL database and then insert the IDs of the rows from the MSSQL database into a PostgreSQL database.

When the scenario starts, the initialization phase is performed first. Integromat verifies connections to the MySQL, MSSQL and PostgreSQL databases one at a time. It everything goes well and the connections are successful, Integromat moves on to the operation phase. If an error occurs, the finalization phase starts instead of the operation phase and the scenario is terminated.

Next comes the operation phase. A preset procedure selects (reads) the table rows (bundles) from MySQL. Those rows are then passed to the next module that writes them to a selected table in the MSSQL database. If everything is in order, the last PostgresSQL procedure is called to insert the row IDs returned by the preceding module into the table.

If the operation phase is completed successfully, the commit phase begins. Integromat calls the SQL COMMIT command for each database and the write operations will be committed.

However, if the operation or commit phase fails due to an error, (e.g. connection failure), Integromat calls rollback. During the rollback phase, Integromat goes through all modules one after another and executes the SQL ROLLBACK command for each module to revert each database back to its initial state.

Finally, during the finalization phase, each module will close its connection to the database.


Popular use cases from our blog


How to Automate Data Collection - Part 5: CRM Systems


How to Automate Data Collection - Part 4: Chatbot Marketing


How to Automate Data Collection - Part 3: Paid Ads


How to Automate Data Collection - Part 2: Email Marketing Segmentation


5 Automated Solutions to Personalize Customer Experience


How to Automate Data Collection - Part 1: Online Forms

Didn’t find what you were looking for?


Find an expert

We feature a network of 450+ certified partners across the globe who are ready to help

Find an expert

Automate any workflow in your business

Sign up for a free account today. No credit card required, no time limits on free plan.