In order to interpret our data stored in our tulup tables, I need to export csv files every hour from our tulip tables to a data visualization software like for example :
Google Sheets
Microsoft Power BI
Tableau
The problem is that I didn’t find any topic about the automatic scheduled export of tulip tables nor about a possible connexion with one of the solutions above. Should I contact Zapier to know if some APIs exist ? Is that possible to get data from tulip several times a day without exporting .csv files manually ?
@Beth I think it is a big stretch to say that Scheduled Automations has resolved this.
@ta-aoki Automations will not be “Exporting CSV” ever as that would be illogical for a background job.
Going back to the original question by @PierrickGuinot , automations can definitely help replicate data from a Tulip Table into other systems, but it is more complicated than a simple connector or scheduled job.
I imagine it will be quite difficult and expensive to have a scheduled automation replicate entire tulip tables on a regular basis. Instead, I would think about using automations to actively store data when it gets generated or updated in tulip into a secondary store such as google sheets or a SQL database. If set up correctly, this means that you will always have live access to tulip data in one of those systems. But you will need to carefully set up your connections for inserting vs. upserting when Tulip fires one of the two automations for “New Record Created” or “Record Updated”
There is also no automation for handling when a table record gets deleted, but the simple solution here is to just never delete data
