We’re excited to announce a new way to bring data into your Knack applications - you can now import directly from Google Sheets!
With the new Google Sheets import option, you no longer have to export your sheets out to CSV before bringing them into Knack. Connect to your Google account and import data right from your spreadsheets.
This makes it seamless to leverage all the data you have in Google Sheets, from simple lists to robust tables.
Some key highlights:
Directly import from Google Sheets into Knack tables
Select which Sheet tab you want to import
Easily map Sheet columns to Knack table fields
No more exporting Sheets out to CSV first
The Google Sheets import option can be found in the import menu of any Knack table, and when you are creating a new table. Just connect your Google account, select the sheet, map the columns, and import.
This new method of importing Google Sheets gives you even more flexibility for bringing data into your Knack apps. Whether you want to import product catalogs, price lists, contact directories or anything else, it’s now simpler than ever.
Cheers!
Kara
Hi, @GazM ! The Google Sheets import option is available in the Builder only. If you would like to learn more about using this import option, you can check out our article here and our tour.
can this be leveraged to use ‘live’ data? like, can a view be designed to import data from google, manipulated in knack, and then saved back to google? this way it uses google as the backend and knack as a front end?
You can create new fields when importing via Google Sheets just like you can when you import data from a .CSV or Excel file. You can learn about this from the anchored section here in our Importing Records article.
