I am trying to populate a Google sheet with data from my Bubble database. Does anyone have experience with this? I would prefer to use Google’s script editor to get the JSON data from bubble and the table in Google sheets just reads the Bubble data – I do not need to edit the data in Google sheets and post it back to the Bubble database.
I can connect and get the JSON data in Postman, but I can’t figure out how to replicate what Postman is doing in Google sheets. Any help or direction to other resources would be much appreciated.
Thank you!