If there's anyone out there who's been using the Looker to Google Sheets functionality, I'd love to hear how reliable you find it and if you have any hacks to make it work.
I'm pulling in over 1,000 rows and 22 columns, the query takes on average 38 seconds to run. My gut says this is too much effort for Google Sheets to wait for. I have reduced the query size to 10 seconds though and I still experience issues, but not as frequently.
I would much prefer a manual refresh of the data if anyone knows how to do that...the help would be appreciated!