Automated: Tulip Table to CSV, then CSV back to same Tulip table

1

I created some Tulip tables that I will be exporting to csv. The csv will be in a folder on our company network. Various managers will enter data into the csv. I would like to be able to have this csv be pulled at a certain time each day, then imported back into the Tulip table that it originated from, so Tulip table data is updated.

2

Cody,

just a technical note on your question: there is no native functionality in the platform to automatically pull a CSV from a file server. However, you could define a Node RED flow that picks the file from the file server at regular intervals, parses it, and pushes the data to a Tulip table via the Table API. More on tulip <> node red integration here: Use Node-RED with the Tulip API

Stepping back, it’s worth considering whether you really need to manage the data in multiple places. If users can update the data directly in Tulip, you might be able to eliminate the need to handle CSVs altogether.

Tarun

3

I found that Tulip does have a Microsoft365 connector, which includes Excel. Which of the options below would I need to set up my original request. I’d prefer to use something native in Tulip rather than Node-RED or a python script, if possible.

image
image1909×625 88.8 KB

1 Like