Has anyone used Google Data Studio or BigQuery to run ETL jobs on their Tiller data? As I continue building out my arsenal of spreadsheets, I keep running into limitations with or having to resort to complex calculations to aggregate data for reports in Google Sheets.
For example, I have a spreadsheet that I use to calculate daily credit card debt (checking balance - sum of all credit cards). Now, Tiller doesn’t always report the balance for some credit cards every day. If the balance was not reported for a specific date, it throws off the calculation for that day. My solution to this was to write a Google Apps Script that will calculate the balance for a given day and defaults to the balance on the closest previous date. However, this isn’t very performance so my spreadsheet now takes ~15-30s to load on open.
Google Data Studio and BigQuery have piqued my interest because they can plug into my Tiller data stored in Google Sheets. From there I can run nightly jobs that will transform my data and generate new tables, reports, etc. For example, I would love to convert my credit card debt spreadsheet to a nightly job that runs the calculation.
I’m curious if anyone here has played around with Google Data Studio or BigQuery at all, and if so, what sort of things you have built with it?