Afternoon all!
I know that you can import directly from Google Sheets, but is there a way to EXPORT directly to GSheets also? The company I’m currently working for uses Google Workspace for everything, and I am using my personal Office 365 account to work on spreadsheets in excel when I need to do complex stuff (sorry Google - but you just ain’t Excel!)
However, I shall be leaving soon and there are a couple of reports that need to have some final manipulation before being distributed, and its a bit of a pain to export to the PC then upload into Google.
I’m just finishing up writing the Process Manual for their new app, so it would be good to give them a simple way to do this.
Any ideas anyone?
TIA
LesleyB 
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 
):
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
Many thanks - I think it would just overcomplicate things for the users I leave behind, but good to know for other projects!
1 Like