Are you adding the sheet as a synced table or importing it into a Glide table? Do you have a plan that supports synced google sheets, or a plan that only allows importing? Which plan do you have? Can you share a screenshot of your tables from the data editor so I can see if the icons are green or black?
At the moment I uploaded the sheet manually (import), because when I tried to connect it as a synced Google Sheet it didn’t work for me.
I’m not sure if my current plan supports live syncing with Google Sheets or only imports. However, as far as I understand, Google Sheets syncing should be available even on the basic plan. Could you please clarify this?