LinkedIn
Twitter
First, if you are building your app using the AppSheet Database as a datasource, know that this feature is very new and in preview only. It has some issues, as its under development, and there is no known timeline at the moment for when it will be considered "live" - for normal app use. If you have a need to get a "live" app out to users in the next few months, you likely should consider an alternative datasource such as Google sheets or a database.
Your title states "FROM Google sheets". If your CSV files are exported from an existing Google sheet, you might want to look into the possibility of pulling that source Google sheet directly into your app. Then you wouldn't need a CSV file at all - you'd already have the data! It may be that the sheet can be used as is or maybe only needs some minor adjustments to be used. You can use Security Filters to reduce the data rows to only what's needed. Then you can create a copy process to retrieve the desired columns of info.
If you must use the CSV files, you have some choices:
- Manually append the rows directly in a Google sheet or use AppSheet's Data Importer (Beta) - see image below.
- Build a Google script to grab the CSV file and add to your app sheet or insert into a database (not sure about AppSheet database)
- Use a third-party service provider, such as Integromat, to grab the CSV file and insert into a Google sheet or even other datasources.
I hope this helps!
AppSheet Data Importer
