Hello, I have a question about integrating data from Google Cloud Storage (GCS) into a Glide app. We plan to regularly extract Garmin data using services like Google Vertex AI and implement a mechanism for scheduled data extraction. Since we won’t be able to store this data directly in Google Drive, we plan to store it in GCS instead.
Is there a way for Glide to access and read data stored in GCS?
Additionally, if anyone has experience working with Garmin data in Glide, I’d appreciate any insights on the best approach to achieve this.
Is there a reason you can’t store that data directly in Google Drive? What does the extraction process look like, and can you use HTTP calls to bring that data to a Glide Table for example?
If your files in GCS have the right permissions at the bucket or file level (AllUsers, Viewer/Reader), you should be able to access your files with a simple fetch in JavaScript.
Check also if there any CORS issue, which you can solve by adding a cors configuration file from your bucket settings or using Google Cloud Console.
1 Like
@ThinhDinh Thanks for your response. We don’t want to use HTTP calls to bring the data directly to Glide because there are other teams that don’t use Glide but need to access the data. We’ve just learned that we could use Google Apps Script to sync data from GCS with Google Sheets, so we’ll try it. Thanks!
@burningmikey Thanks for your response. It looks like a fetch will require the data to be publicly accessible, which is not an option for us. We’ve just learned that we could use Google Apps Script to sync data from GCS with Google Sheets, so we’ll try it. Thanks!
1 Like
You’re welcome.
If you use Google Sheets as a datasource, you can indeed create a secure connection to private files in GCS with a script!