Excel Workbook Module for Integromat

Employ an Excel Workbook document to perform calculations, logical operations, and data manipulation.

Starting guide

Please follow a few simple steps to make your Excel Workbook available in Integromat.

To make sure that it is easy to set up your Excel Workbook in Businesslogic, please consider which cells will be inputs and which will be the outputs.

When your Excel spreadsheet is ready create a web service in Businesslogic and upload your Excel document (xlsx format) with all the computations, data and formulas.

Now you need to configure your Excel web service. Create input and output fields and map them to the cells in Excel Workbook.

When your Excel web service is configured you can test it, to see if you get the results that you are expecting.

When your application is configured and tested, you are ready to make it available to the world. Do so by launching the application.

You can now connect your Excel driven API through the programming language of your choice or integration service

How to update your Excel Microservice?

You can update you Excel Microservice by altering the Excel Spreadsheet document on you pc/mac with new logic, calculations and data, and then uploading it back to the web service that you created for that Excel Spreadsheet.

I made some structural changes

If you made changes so that input and output cells are placed differently in the document, you will have to change the configuration of the document accordingly. When configurations is changed test the service and only then launch a new version of it. When your Excel web service is launched you will have to reconfigure your Excel Spreadsheet Module in Integromat scenarios where it is used to get the latest configuration.

I only made changes in computation logic and data

If you didn't make changes that can influence position of your input and output cells, then you can simple upload the document, test the service and launch a new version. In this case you don't have to reconfigure your Excel Spreadsheet Module in Integromat scenarios.

‍

When to use the Workbook module

The Workbook module runs a complete Excel file as a single microservice inside your Make (Integromat) scenario. Where the Formula module evaluates one expression at a time, the Workbook module is built for real models: many cells, several sheets, named ranges, and the formulas that connect them. You upload the file once, mark which cells are inputs and which hold the results, and Make sends data in and reads the answers back as one clean step.

Reach for it whenever the calculation is more than a single line. Typical cases include multi-step pricing and quoting, financial models with dependent formulas, scoring and eligibility rules, engineering and sizing calculations, and any sheet where one input cascades through dozens of others. Because the logic stays in the workbook, the person who owns the model can keep refining it in Excel — re-upload the file and the scenario picks up the new version without touching the automation.

How it works in a scenario

Add the Workbook module to your scenario, choose the file you published, and map the preceding step's data onto the input cells. When the scenario runs, Businesslogic computes the workbook with those values and returns the output cells, which you can pass to the next module — a database, an email, a webhook, or a Make data store.

One source of truth. The same model your team trusts in Excel is the one your automation uses, so the numbers always agree.
No rewriting in code. Complex logic that would take days to reimplement runs as-is, behind a stable interface.
Private by design. Consumers of the scenario see only the inputs and outputs you expose, never the formulas inside.

New to this? Start with the guide on turning an Excel spreadsheet into a REST API, or read the API documentation to call the same model from your own code instead of from Make.