Excel Workbook Module for Integromat

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.

‍