Hi community,
I would like to integrate an external google sheet document into the Glide tables, so that it would update automatically on Glide when the Google sheet gets updated as well.
What’s the easiest/best way to do this?
Thanks in advance!
Note that using Google Sheets as a data source is only supported on paid plans.
If you have a legacy plan you can use Google Sheets for free. If you don’t, you can’t use Google Sheets. If you are on a paid plan, just turn on Extra Sync to make the syncing easier.
Okay cool.
Here you can see I tried something similar, but it’s not letting me sync another table via Google Sheets.
Is there a way around this? Or what are some alternatives?
You can only connect to one google worksheet. If you want additional tables, then they need to be in that same worksheet as additional sheet tabs.
1 Like
Okay got it, thanks.
From what I understand the data is synced such that the spreadsheet data gets shown on Glide, but is the opposite possible (i.e., any data updates including adding/updating/removing rows on Glide would later show up on the google spreadsheets)?
Yes, that’s how it works. The google sheet is the data source, but Glide synchronized the data between Google and the glide servers. The data is kept the same in both locations.
Okay great.
I’m asking because on Glide I just added a column to one of the spreadsheets on the sheets doc that’s being synced, but on Google sheets it’s not showing up, even after a manual sync.
Is this supposed to happen?
Below are two screenshots showing the issue. The relevant sheet & column are circled in red.
That’s a Rollup column, which is a computed column. It doesn’t hold a value. It just calculates a value. There is nothing to store in a google sheet as it doesn’t actually hold a value.
1 Like
Got it, thanks a lot!
1 Like