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
4

I see the option below in Google. Is there a video/guide for me to use Power Automate to perform this?

Workflow overview

  1. A CSV file is updated in SharePoint. This action triggers a Power Automate flow.

  2. Power Automate parses the CSV content. The flow reads the data from the CSV file.

  3. Power Automate sends a request to the Tulip Tables API. The flow calls the Tulip API to update the corresponding Table in Tulip.

  4. The Tulip Table is updated. The table is either overwritten or new records are added, based on your API request.