When to use Googlesheet, air table or glide table?

When would you guys use any of these tables?

example what use case or dependency?

I personally only use Glide table for now… but if i want to have 2 separate apps that use same tables, can Glide table do sync for both apps with the same data table? Or i need to use air table or google sheet?

Answered the following just recently.

I build most Apps using native Glide Tables. In the past I also built a lot of Apps using a Google Spreadsheet as a data source, but I generally avoid that these days.

Reasons why I might connect a Google Sheet:

  • If I need multiple Roles per user, I will use a Google Sheet as the source of the User Profiles (only because native tables do not support this)
  • If the data needs to be used outside the Glide App, and the plan I’m working with does not have API support.
  • If there is a 3rd party integration required that either can’t be done with native tables, or is easier done with Apps Script. (Sometimes I will use a Google Sheet purely as a place to host code, without actually connecting it to a Glide App).

I’ve never used Airtable as a data source (or at all).
I’ve never used Excel as a data source.
I’ve not (yet) used any SQL data sources, but I can foresee this in the future.

You can have as many Apps as you want sharing the same data source - regardless of the data source.

4 Likes