EssentialsData Sources

Google Sheets

Use Google Sheets as the data source for your Glide app.
25,000 Row Limit on Spreadsheet Data Sources

Rows from spreadsheet data sources have a total cap of 25,000 rows across all tables. If you need more than 25,000 rows of data in a team, consider a high-scale data source like Big Tables.

Google Sheets is a cloud-based spreadsheet program that’s similar to Excel. You can choose a spreadsheet from your Google account to serve as the Data Source for your Glide app. Users on any plan can export a Google Sheet and import the resulting .csv or .xlsx file into Glide. Google Sheets syncing is available starting with the Maker plan. Browse our plans to find the right fit for you.

How to connect Google Sheets with Glide

If you created your Glide account using your work email, you must create an associated Google account to integrate Google Sheets with Glide. To learn how to create a Google account using an email type that isn’t Gmail, see Create a Google Account.

1

From the dashboard, select New app.

2

Select the template type you want to get started with.

3

Select Google Sheets as the data source, then Continue.

4

When prompted, select the file from Google Drive to use as your app’s data source, then Select.

Glide creates a starter app using your Google spreadsheet as the data source.

More about Google Sheets

We’ve gathered some resources to help you understand Google Sheets better.

  • Start with the Google Sheets Help Center for a full list of topics.
  • View the Google Sheets function list for a variety of formulas you can apply within your spreadsheet.

Frequently Asked Questions

If new rows are appearing very far down in your sheets, or in a strange place you don’t expect, it could be that you have formulas or other macros in your spreadsheet that Glide does not want to write over. Even if the row looks empty, these formulas or macros could be present.

To solve for this, we recommend deleting the empty rows from your spreadsheet. This will allow Glide to generate a new row in the appropriate place.

Glide supports frozen rows. If you have less than 20 frozen rows, Glide will take those frozen rows for the column names. When there’s more than one cell in the frozen rows for a column, the lowest one will be the column name.

Unfortunately not. But you can use IMPORTRANGE to pull in data from other sheets into your original sheet.

Google Sheets has an IMAGE formula to display images in cells. Glide doesn’t support this formula—IMAGE(URL) will not work, but URL will.

Depending on your location and spreadsheet’s settings, Google Sheets will expect a certain format for your dates. You can change the settings for your Locale and affect the way Google Sheets formats your dates. Go to File/Spreadsheet Settings. It’s possible to change your Locale and not affect your timezone. For example, you could make the timezone London GMT but the Locale the United States.