Has anybody played around with an ETL tool in order to grab query results from google sheet and into a database?
Any tips on tools and viability etc are welcome.
You can connect a Google Sheet as an ETL source for Google BigQuery. Use Supermetrics queries to update Google Sheet with a scheduled refresh and data will be updated in BigQuery accordingly
Hi Don, that's a great suggestion (only saw it now as no notification).
However, that's just a connection and I'm looking for a way to import the data and structure it into a database...
Have you found any solutions to your requirement ? I'm looking for the same solution.