Hi.
Is it possible to write a row (to the bottom) of an Excel spreadsheet from Creatio?
We need to copy select data from a Creatio screen to a row on a spreadsheet. In our case, the spreadsheet lives on a Sharepoint drive. The goal is for the user to push a button on a Creatio screen, and have it insert data to the last row of an existing spreadsheet.
Any direction or suggestions you have are appreciated.
Thanks!
Rob
Like
I have something like that working (except I am using a hosted Google Spreadsheet) that is using make.com. I just execute a Make.com webhook from a process in Creatio, make.com receives that and then writes the line to the existing spreadsheet. All no code, so just thought I would mention.
Ryan
Hi,
Yes, it is possible to write a row to the bottom of an existing spreadsheet from Creatio.
There's an official Google Sheets connector for Creatio available on the Creatio Marketplace: https://marketplace.creatio.com/app/google-sheets-connector-creatio
It enables two-way sync with Google Sheets and lets you:
-Automatically send data from Creatio to Google Sheets;
-Map sheet columns to Creatio fields;
-Use Google Sheets as a staging point between systems.
This connector is fully no-code and works with current versions of Google Sheets - all you need is a Google Cloud account.
Have a nice day!
Thanks. However, we are not using Google Sheets, our corporate standard is Excel / MS Office. Creatio would need to integrate with an existing spreadsheet used by our Operations department -- Is there a connector for that too?
I have something that allow using a excel template to push data with some custom framework primitive for openxml. But it's not trivial to use, and it just download a file localy.