Connect to a Google Drive folder

[andnew]

I have a folder of identically structured Google sheets. I want to use this folder as a data source for a Looker Dashboard. Is there an easy way to achieve this or do I need to merge all the Sheets into a single doc? I want to be able to keep adding sheets to the folder in the future.

[marcwo]

Hello @andnew

there is no out of the box way to use a folder as a data source.

Two alternatives you could use though, depending on your setup:
1. Create an external table in BigQuery and use wildcard URIs to read from multiple source files.
2. Use Apps Script to programmatically combine the sheets of the source folder. You can schedule the run of that so new additions to the folder get incorporated with little delay. Example community post 

Hope that helps.

Thanks
Marc