I have noticed that many new users appear to get a little confused when it comes to understanding what constitutes a sheet vs a table, and how they interact. The introduction of Glide Tables a while back has possibly exacerbated this situation somewhat.
So I’m creating this FAQ topic in an attempt to provide some clarification. Please note that this is the way that I choose to think about it, which works for me. Others may think about it differently, and that’s fine
The way I like to think of it is as follows: Tables belong in Glide, and sheets belong in Google Spreadsheets
TABLES - are found in the Glide Data Editor, and there are two types:
- “Normal” tables: these are essentially a copy of your Google Sheets. When you add a new Google Sheet, or modify an existing one, the changes will sync with Glide and automagically appear in the Glide Data Editor.
- Glide Tables: These are special tables that only exist within Glide. These tables will not appear in your Google Spreadsheet, nor will the data sync in any way. Glide tables can be identified by the distinctive icon next to the table name.
SHEETS - are found in your Google Spreadsheet. As a general rule, all sheets will also exist as tables in the Glide Data Editor, however there are a few notable exceptions, as follows:
Depending on which features are enabled/used within your app, Glide may automatically generate a number of new Google Sheets. These sheets can be identified by the name, which will always be in the format
App: XXX. Examples are
App: Metadata &
App: Comments. Important things to understand about these sheets:
- Whilst Glide will generate and populate these sheets with data, it is a one way sync. The sheets will not appear in the Glide Data Editor, nor are the sheets or the data contained in them available to use in your app (but you can make a copy of them if you want to use the data in your app)
- The rows in these sheets do not count against your row quotas.
I hope this is helpful