How to do manual sync with Google Sheets

How do I manually sync Google Sheets to my app?

Go to the Data layout. You’ll see a list of data sources in the bottom left corner, along with a refresh button you can use to manually sync your data (for Google Sheets, Airtable etc.).

Hi, thank you for the reply. Herewith the screenshot of the Data tab - I see the words “Data Sources” but no sync button.

Hey, It doesnt look like any of those tables are a Linked Google sheet?

They look to be standard Glide tables which do not require a manual sync?

See below, linked google sheets appear Green

image

Can I link them on a free plan? The drop down tab seems to indicate it is linked?

No, the free plan does not support external data sources. The unlink option you see there is to unlink the Glide (native) table from your App.

What you can do is import data from a Google Sheet, but that is a one time thing - it does not create any permanent link with the sheet.

Is there no manual syncing at all? Would the best option to add data inside the native table?

Like I said, you can manually import data from a Google Sheet, but you cannot create a permanent connection on a free plan.

And yes, you are probably much better off using native Glide tables, unless you have a very good reason why you need the data in a Google Sheet. Most experienced Glide Developers try to avoid Google Sheets altogether.

Thank you for your input. Do they prefer Glide tables or alternative data sources?

It depends on the use case. Native tables are perfectly fine for the vast majority of use cases. Perhaps if you can tell me what you plan to do with Glide I can tell you if native tables are a good choice.

2 Likes

Id say its mostly glide tables and glide big tables.

Enterprise apps might use some larger sql based external data sources.

Ive got apps for 50+ users at a single time. making rows and updates almost every minute in a working day.

All native tables

1 Like