Hi,
my customer is storing Excel files on Dropbox.
The easiest way for me would be to make a Make.com automation to copy those files to Google sheets and from Glide access them in Google Sheets.
Is there a better solution?
Is there any automation tool that connects to Glide?
Is it a one-off thing or do you have to import it regularly?
At this stage: once a month.
I hope there is going to be second stage. Then once a day.
I’d started to make a Zapier.
Glide has to be the app starting the workflow in Zapier.
I would suggest exploring a way to do it through an API. I mostly use Make.com for automations.
Assuming you have the data structure in Glide ready, I think what you can do is tell the scenario to access the file in Dropbox, download it, read its content and import that to the centralized Google Sheets that is linked to your app.
I’m not sure how it works if you have multiple sheets in your Excel file. I usually import CSVs.