Question

Is Google Sheets importXML to Looker connection unreliable to anyone else?

  • 2 July 2015
  • 4 replies
  • 141 views

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!


4 replies

Hi Joel,


This is how you can do a manual refresh


in B1,

=ImportXML(“https://yourcompany.looker.com/looks/look_ID.html?now()"&A1,"//tr”)


What this will do is every time the value of A1 changes, it will refresh the data/

Let me know if that works!

Userlevel 3

You may also want to consider this option from Looker’s Segah Meer:


Amazing! Thanks Brett

@Dave_Suchmann: Might be useful for us

Reply