Bubble.io is fantastic! We love it for its flexibility and its ability to adapt to one’s needs as well as the community.
But what if you wanted to bring in data from your Google Sheets to bubble and have it dynamically update the changes on the sheet? or even better! – have users interact with the UI on Bubble and make changes on Google Sheets.
Well, there is a solution and it’s simple – converting your Spreadsheets into JSON APIs and linking it to bubble with their API connector”.
There are a number of ways to convert Spreadsheets into JSON API. A couple of good starting points are SheetsDB as well as Sheet2API. Both platforms are easy to use and serve the job just right.
But we also stumbled upon a new player in the game – NocodeAPI.
NocodeAPI lets you do the same stuff that the others do, but with a number of other platforms!
Setting up the sheet and getting the endpoint is as easy as authenticating your google account and selecting the sheet that you need data from.
You can right away test the API, copy the endpoint and be on your way if everything works.
Once everything checks out, you can head over to bubble, and install the API connector.
All you need to do at this point is click on add another call and paste the endpoint here.
You can choose to rename the API at this point (will come in handy when you have multiple APIs connected).
Fetching this data on to bubble can be achieved by adding an element corresponding to the type of data we want to display. In this example since we are bringing in text, we’ve added a repeated group and included a text element. Now all that is left to do is add dynamic data for the data source and make an API call for the data that you need.
See the full tutorial on our youtube channel for a step-by-step breakdown.