What is the Best Way to Automate Data Backups from Glide?
I am currently using a mix of Google Sheets and Glide Tables for data management, though the datasets are relatively small. I’m looking for an efficient, automated approach to back up this data on a regular basis (every three days or weekly).
I’m aware of the CSV export option but find it limiting for my purposes, as I’m interested in a fully automated solution. I know that Glide’s API could potentially facilitate this, but I’m unsure how to implement it effectively. Additionally, I’m considering tools like Make (Integromat) or Zapier for automation, though I need guidance on setting these up.
Could anyone provide advice, recommended solutions, or tutorials for implementing an automated backup system in this setup?
You could always “Duplicate” (under three dot menu on project when viewing team folder) your project and select “Copy the sheet”. This won’t be as automated as you’d probably prefer, but a good way to retain your platform & its data in their current states.
1 Like
Combining this with the Glide API can work, but I believe you have to export each table separately.
Another option is waiting for automated workflows to come out, then do exports for each table and store them somewhere as CSV links.
Can you guide me on this a bit like how i can send data to the Make/Zapier , one option i know is Webhook but for that i think i have to send each row seperately like i have to send every row one by one as i want each row in the backup.
But not sure how the Call Api will help here.
Check out the Get Rows section here, it should give you all rows of a table.
And I meant the Glide API through Make/Zapier if you intend to use that, not to confuse with the Call API action in Glide.