Google Sheets showing #ERROR! exporting data with lookerFetchData

Knowledge Drop

Last tested: Sep 17, 2018

If you can successfully load their data into Sheets with lookerFetchData on the same look, it may be due to them breaching limitations on Google’s side.

This goes over their quota restrictions. Notably the “Custom function runtime” being 30 seconds at the time of this card being created.