I am trying to connect google sheets API to collect and read data but can’t seem to find a video or tutorial on it (new to working with APIs and they confuse me)
I would prefer not to use a third-party connector but if I have to does anyone know the best value one out there?
Just a note for @ankur1. In your GET REST API Video, to pass the parameter ID into the URL you just need to add something like [ID] instead of the ID number. Then a parameter field will show up that you can use dynamically. Then just uncheck private so you can set it in a workflow or in data.
@pattokane Just FYI. I think Google Sheets is a lot more complicated than this API. I will see if there is documentation for it. Otherwise, the easiest thing to do would be to import it as a CSV file directly into bubble or a different place like TypeSense for quick searches with a lot of data.