The content of this article has been updated and migrated to a Looker Help Center article.
Already have an account? Login
Login to the community
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
There is also an updated version of this below.
Open Script Editor
Create a Blank Project
Paste Looker Code (on a Blank Canvas)
Awesome function. One additional thing to consider, formatting is stripped in this function, but a slight change will maintain formatting.
Is there anyway to make the data persist in the Sheet? It seems to clear the data and refresh the sheet when you open it
Thanks for your question! If you’d like to persist the data in your Google sheet, I would recommend using Looker’s native Google Sheet Import capabilities. This script is meant to automatically update the sheet with fresh data upon opening but the native export will let the data persist.
Let me know if I’m misunderstanding your request.
A small update to the script due to a change in the URL (.html becomes .gsxml):
I’m not a dev but that did work for me so someone else please feel free to update more thoroughly if it’s required.
Thank you for catching that
@favrot - have updated the OP now.