Is it possible to schedule an automatic import of a csv file

AppSheet AppSheet Q&A
1

We have a csv file that will drop in a directory folder on Google Drive daily let’s say at 6:00am. We’d like to schedule AppSheet to import the csv file and post the data to a specific table. Can this be done?

Based on what I’m reading it appears to only be possible to import into a view meaning the user would have to manually do this each day?

Thanks everyone

2

Import CSV is limited to a manual user action since the user needs to find the file on it’s file explorer of choice to upload the data.

If you need to import data perdiocally, I’d start thinking about other methods

4 Likes
3

Thanks so much for clarifying

2 Likes
4

Got the same problem…
What could be the others methods ?

5

google apps script can be a good method if you are using google suit (gmail, drive,…)

1 Like
6

Could you kindly explain to me how?

7

Bigquery can watch GCP Buckets and automatically append to specific tables that can be shared with Appsheet. There is an Appsheet API that could be used to ingest content using JSon format. A scheduled process will need to be used to run. Using Appscript , Appsheet can be used as a scheduled to periodically run CRUD actions.