Hello - I’m looking to automate integration of data from Excel into Google Sheets.
I’m extracting data from a business tool to Excel quite easily on a specific rythm (ie: twice a day), I can sync up these data in Google drive, by synchronizing the folder where I store locally the Excel files.
But to be able to get this data into Glide app, I need to pull them into a google sheet file. I’m struggling to do this automatically.
I have been testing google sheet add on “Sheet-to-go” on trial, that seems to do the job, but to integrate .xls file, I’ll need to buy the advanced version, which is 230$/year, that is a bit too much for my project.
Also not sure that I’ll be able to have fancy features (like using arrayformula), when integrating excel data to google sheet with this add on.
Has anyone already face this use case? Tried “Sheet-to-go”?
Any advice are welcomed!
Thank you for the support!