Exporting to Google Sheets?

Hi @Lesley,

Good question! If you’re looking to import all records from a data table or an entire app’s data into Google Sheets, you can use Knack’s API and Google’s App Script extension to import your data directly into Google Sheets without having to export the data to your PC first.

Here is where you can find that extension in Google Sheets (test sheet :smiley:):
2024-11-07_13-52-27 (1)

You would need a script to implement into the App Script extension and you can utilize AI services like ChatGPT to get the script and a breakdown of how to implement it into the extension.

I’m not sure that doing this would be easier for you than exporting the data to your PC and then importing it into Google Sheets, but this certainly is an alternative way to accomplish that.

1 Like