Api - sheety (google sheets)

Good Afternoon all,

I hope you are well. I was hoping someone with a little more experience in API’s and bubble could give me a little bit of guidance.

So, I am using sheety to currently transform my data in my google sheet into live data on an app which i’ve built in bubble.

For reference, my sheet includes a basic set of information such as Car Registration, Status of Vehicle (Sold, Etc), Location (Bodyshop, OnSite etc).

I have the info from Sheety such as the URL to make the request. I want to be able to pull specific information when clicking buttons.

Screenshot 2025-03-02 at 14.43.31

I have buttons which I have attached a screenshot of when I click the buttons I want to be able to only show the relevant date in the group below. for Example - when I click sold, I want to only display the data from the API from the SOLD Section on my sheet. I know I can use the URL parameters (https://api.sheety.co/xxx/sheet1?filter[status]=SOLD
** Ive had to hide the url as it has sensitive information in **

I just need to understand better, how to only pull info from that parameter and then for each button repeated but of course show relevant info based on which button is pressed.

I hope this isn’t too confusing to understand

Thank you

Hi,

In your google sheet, how did you define these categories? Is it possible to organize a separate sheet for each category? if yes, then you separately call sheety API to retrieve data.

Hi, yeah I had that currently…

However, when it comes to wanting to add new rows via api, it’s hard to do that when they are all independent? Or am I missing something?

Thank you

Jack Anthony

Book a meeting - Calendly