Google Sheets

Configure Google Sheets with Zing

Google Sheets is widely used cloud spreadsheet. Setting up Zing with Google Sheets is the easiest way to to get started with Zing, as it requires no database connection. You simply provide the URL to your Google Sheet, and you can set up Zing to connect to as many Google sheets as you’d like. This is also the best way to import CSVs (assuming they are within Sheets’ size limitations).

You can also connect to a Microsoft Excel file by importing it into Google Sheets and then connecting Google Sheets to Zing.

You can connect Zing to Google Sheets from either the Zing web console, the Zing web app, the iOS app, or Android.

You’ll need:

  1. A correctly formatted Google Sheet with field names in the header row. Your sheet should contain only the data you wish to import. Only one table per sheet (for now). Field names should not include special characters.

  2. Permissions to that sheet - meaning that your Google Account has at least ‘view’ rights to the sheet, OR the sheet has ‘available to anybody with the link’ access

Note that unlike all other data sources in Zing, Google Sheets imports are not ’live’ connections. That is, Zing takes a ‘snapshot’ of the sheet at the time of import but subsequent changes to the sheet will not automatically update in Zing. If you’d really like it to be a live connection, let us know.

Web Console

Add a Google Sheet as a data source from the web:

  1. Go to your Zing Data Web Console and ensure you are logged in

  2. Tap the ‘data sources’ tab

  3. Tap ‘Google Sheets’

  4. To connect Zing to Google Sheets that are not public, authenticate into your Google account by clicking ‘Access your Google Sheets’ and enabling both Zing read access to your Sheets, and Google Drive read permissions when prompted. Both of these permissions must be granted for Zing to list your sheets and connect to your sheets as a data source.

    From there you’ll see a list of your Google Sheets. Select one you’d like to import or search by name and click the name of the sheet, then click ‘Select’

  5. To connect Zing to a publicly shared (available to anybody with the link) Google Sheet, you don’t need to authenticate into a Google account and can simply enter your Google Sheet URL.

  6. Tap ‘Save’

  7. Check for any warning messages which might indicate the sheet was incorrectly formatted

  8. The data source you just added will be available to everybody in your organization.

App

To add a Google Sheet as a data source from your phone:

  1. Go to the sources tab

  2. Tap ‘Add a new data source’

  3. To connect Zing to Google Sheets that are not public, authenticate into your Google account by clicking ‘Access your Google Sheets’ and enabling Zing read access to your Sheets when prompted. From there you’ll see a list of your Google Sheets. Select one you’d like to import or search by name and click the name of the sheet, then click ‘Select’

  4. To connect Zing to a publicly shared (available to anybody with the link) Google Sheet, you don’t need to authenticate into a Google account and can simply enter your Google Sheet URL.

  • Tap ‘Confirm data source’. After a few seconds, Zing will show you if the sheet was successfully connected.