Hi, I am considering the move to bubble from glideapps. My data is stored on Gsheets as a contingency in case the service goes down, my client can still access and manage the date.
I am looking to add/edit/delete data from bubble to gsheets in both directions WITHOUT using any third party applications like sheetly. Is this possible?
I tried creating an API using Google Developer Console, but its pretty complex. I found some threads on this forum, but some of them might be outdated.
Yea you can hook up google sheet api calls in Bubble’s API Connector to use with Database Triggers that will send data to the Google Sheets every time something is updated in the Bubble Database. Then with AppScript you can set up the edit triggers to send data to Bubble’s Backend Workflow API endpoints and update the Bubble Database from changes to the Google sheet as well. So it is possible for the data to flow back and forth automatically.
How is Bubble DB ties in to this? If I’m reading my data from gsheets, I’m not using bubble db.
Also, is there any material you can point me to how to set this up. Thanks in advance