Connecting Googlesheet(Source) to Looker(target)

Looker Q&A Looker
1

Hi,

I am exploring on Looker and I want to create Looker dashboard using Google sheet. ( Google sheet as input to Looker)
Can you please suggest/provide me the steps/links/documents to connect Google sheet.

Thanks,
Viswa.

2

HI Viswa,

You can’t use Google Sheets as a direct source of data. You would have to push it into a some kind of database.

Here is an example implementation recommended by Looker themselves: https://help.looker.com/hc/en-us/articles/360023860613-How-to-use-Google-Spreadsheets-to-Input-Data-into-Looker

3

If you can access Google BigQuery: https://cloud.google.com/blog/products/gcp/how-to-crunch-your-business-data-from-sheets-in-bigquery

3 Likes