Write/Insert a row to an Excel Spreadsheet?

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 0

Like

4 comments

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.

Show all comments