This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
@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.
I do have workflow, user access to a certain Google Spreadsheet, and type data in bulk. And then fire the GAS to upload the data onto SQL Server via Appsheet API, working perfect.
I would prefer this feature over my solutions that I’ve cobbled together… The best part is the ability to leverage the existing validation that we’ve already spent time/effort to perfect in the front end. The other thing is then the users have multiple avenues to get info INTO the system… It is LOW CODE after all…
No doubt, it is useful if we could get function load bulk data in CVS, with sort of interface. But the problem my clients is not waiting for me until it happens, so I need to think about alternative like solution I pushed, it is my basic notion to avoid coding though.
Action to import a file exists, as far as I know, this is a manual trigger to be done by the user.
We now need a WORKFLOW to do the same (indicate file type, where the file is, a what time to upload it etc.). A log file should be provided to indicate any issue with the import.