Using GoogleSheets as a datasource for Looker

[SunnyD]

Hey Everyone,

My company is trying to consolidate our reporting and monitoring dashboards into Looker. Is there a quick and easy way to use GoogleSheets as a data source to build Looks and dashboards? I've found some mentions using JDBC drivers but is there something easier to implement?

I also saw the connected sheets for Looker documentation but that appears to only allow users to explore Looker data in GoogleSheets...not the other way around.

A similar ask to this post from 3 years ago : https://www.googlecloudcommunity.com/gc/Exploring-Curating-Data/Connecting-Googlesheet-Source-to-Loo...

Thanks 

[Lobo-Google · Accepted solution]

Hi @SunnyD ! It looks like you've found some of the resources that we've made available in the Looker Community (How to use Google Spreadsheets to Input Data into Looker,  and Uploading Spreadsheet (Excel, Google Sheets) Data into Looker). Unfortunately, there is no quicker way currently. I can definitely see how that would be useful, especially since you are using Looker as a way to consolidate your reporting. 

If you are able, can you please let our team know how important this feature is to your use case by filing a  feature request in the Looker platform? Here are directions on how to do so!  https://www.googlecloudcommunity.com/gc/The-Kitchen-Table/Feature-Requests-How-your-feedback-makes-L...

Thank you!