3 ms·
Yes, IMPORTHTML fetches your csv, but you can have your CSV populated by your server dynamically on each request. You can't push to a Google Sheet as far as I k
by fragsworth 9y ago
Yes, IMPORTHTML fetches your csv, but you can have your CSV populated by your server dynamically on each request. You can't push to a Google Sheet as far as I know.
But polling is just as good for these purposes, your data will be up to a few minutes old.
If you want true live data then you should use something else, but that's not what the finance chiefs are complaining about. They want people to stop manually importing CSV data because it's really slow, and causes lots of errors.
EDIT:
I was going off the assumption that there was actually a database somewhere. Turns out they're using Excel as the database.
I'd still argue that one person who codes can fix it. Take your Excel sheets, put them into an SQL database, and dump to CSV for importing to Google Docs for graph/display purposes.