Import file

It would be great to be able to import like a csv file to update the data.
Or this is something you do directly in gsheet via google script ?

@Cyril_L
Your CSV file is just a text file and not really in good format to connect Appsheet directly to. You should import it into any of the available data sources Appsheet can connect to.

I use google script to automatically import CSV into google sheets using automatic triggers. That way Appsheet uses that gSheet as a source and is always reading from the latest data.

Some examples using GAS to import CSV into a gsheet:

https://ctrlq.org/code/20279-import-csv-into-google-spreadsheet

1 Like

Thanks, my problem is to synchronize it, I will do some Script

Le sam. 6 avr. 2019 à 20:20, Mike via AppSheet Creator Community appsheet@discoursemail.com a écrit :

@Cyril_L
I tend to handle data blending and refreshes in the source data with scripting, with Appsheet for access and additional data entry.

1 Like