New! Importing Data from Google Sheets

This article will provide you with the necessary information on how to import data from Google Sheets into your Knack application.

You can now easily import data from Google Sheets into your Knack application! This allows you to leverage data you already have in Google Sheets without needing to export and reformat it.

How to Import Data Using Google Sheets

1. In the Builder, add a new table, or navigate to the table you want to import data into. Select the Google Sheets option if adding a new table, or if you're importing into an existing table, select the "Import" button from the Records view.

   Then, you can select Google Sheets as the import source:

   

2. You will be prompted to sign into your Google account. Enter or select the account containing the Google Sheet that you want to import. Please read and understand the data that will be accessed from Knack while signing into Google. After selecting what Knack can access, select "Continue".

3. A list of your Google Sheets will then appear. Select the sheet you want to import data from:

4. If the Google Sheet contains multiple tabs, you can choose which tab to import from:

5. You can then map the columns from your selected tab to the fields in your Knack table:

6. Once mapped, select "Next". In the Advanced Import Options, you can select if you would like to update existing records in the table:

   You can also set defaults for any empty or missing fields in your import in the Confirm Your Import step:

The data from your chosen Google Sheet tab will then be available in your Knack application. This will be a one-time import.

Notes & Troubleshooting

• At this time, 250MB is the file size limit for any file type.

• If you have images stored in your Google sheet, those images will not be imported into your table.

• You can learn more here about mapping columns to fields.

• Due to the differences between Google sheets and Knack formulas and syntax, formulas are not preserved on import, but the values are.

• If you have any text/number formatting applied in your Google sheet, the formatting will not transfer over into Knack when importing.

  • Values in cells are imported. Cell formatting, such as bold, colors, and font formats are not imported.

• If you have more than one Google sheet to import from a workbook (multiple tabs), you will need to import each of the sheets individually. Knack will only retrieve data from the sheet selected during the initial import.