The Scoop for Sheets plugin allows you to query Scoop datasets and inject live Scoop data into your Google Sheets.

With the Scoop for Sheets plugin, you can create queries that access Scoop datasets and then use those queries to populate sheets in your spreadsheet workbook. Each query, when executed by the plugin, will populate a single sheet.

For more information on creating Scoop dataset queries see Dataset Queries.

Each query can be edited using the plugin, and refreshed individually. Or you can choose to refresh all queries at the same time.

Query Definition Sheet

If you want more control over your queries, you can actually bypass the plugin UI screen, and directly modify the underlying Scoop Queries sheet that actually drives each of your queries. You can do this by clicking on the "Show Query Tab" slider which will make this sheet visible. This is useful if you want to make any of your queries parameterized. Say, for example, you want to calculate the date range, or have a formula that calculates what a filter value should be. You can do this by modifying the query sheet template directly. Note, that when refreshing your data, Scoop will scan the query sheet page and use that as the definitions of the queries it will run.

The query template makes clear which cells you can modify to drive your query parameters. However, filters require a bit more description. You can create filters on any column by typing in a filter type - like "Equals" in the filter type row, then the values in the rows below the column. You can play around with the plugin UI to see how changing it, changes the underlying query sheet and how filters get represented in the sheet. The advantage of using the sheet, as mentioned above, instead of the UI, is that you can type formulas into the sheet and the results of the formulas will be used to drive your query. So, for example, you can have your start and/or end date driven by a formula of your choosing. This creates some poweful possibilities to have your worksheet updated automatically and a regular basis.

📘

Scoop uses spreadsheet logic, so tools like ChatGPT can help you easily create and refine formulas.