You sure can. It’s configured to hit the Bubble general data endpoint and pull down a full table, but it’s very easy to add filters in and is a good idea if you’ve got a lot of data.
I’ve made it easy for people to get started with limited Bubble & Google Sheets knowledge. So there are some fields where you just copy paste a few things from Bubble and I stitch them together in the right format for the API call. The idea is that you’re up and running at a basic level in like 5 minutes
If you wanted to add filters, it depends which ones to how complicated it would be. Essentially the field where I stitch everything together just needs to match back to Bubble’s documentation on the Data API
But in the instance of filtering to a particular ID value it’s super easy. You just add that ID to the end of the Data API Root URL field and it’ll still stitch together correctly.
For example to pull down a full table you’d paste this into where I ask for the Data API Root URL:
And to filter by ID you’d just add
/unique_ID to the end of that and it would become…
If you want to add search constraints it does get a little more complicated (see Bubble docs for more details) but again, totally possible and only involves changing a few things in the Google Sheet itself - you don’t need to touch any of the code that sits in the background. I wish I could have addressed this and made it easy for people, but it’s very difficult for me to build something generic that’ll work across any table and not be super confusing at the same time
In terms of the ability to replicate this across multiple tables/projects…
Once you’ve bought the template you have free rein to duplicate it and modify it as much as you like. So you can use it across an unlimited number of tables, bubble projects, in different google sheets etc. There’s no middleware so no limits basically.
The sheet is created around pulling in a single table. But there is no reason why you couldn’t duplicate what’s there and have 10 sheets in the same workbook pulling down 10 different tables, or 10 different filtered versions of the same table or whatever.
Hope this helps