Auto copy data from external source on change

[AndreStolpinsky]

Hi everyone,

After a long time of trying to figure it out on my own, I come here to ask for advice.

I have a csv file that is exported automatically from my sales software. It includes all the orders we create.

The file has columns: company, project, item, order number, qty etc.

What I'm trying to do is every time there's a new row in this spreadsheet to copy it automatically to the AppSheet database. Is there a way to do it?

Thank you

[dbaum]

Consider just using the spreadsheet as a data source for your app.

If you indeed need to move the data and your spreadsheet is a Google Sheets file, it's possible to  Call AppSheet API from Apps Script; so, if you have an app that uses AppSheet database as a data source then using the API to import the data into the app will populate the database. Here's a similar use case involving a .csv file: Reference User's Last Access Timestamp. 

[Steve]

AppSheet Databases is in preview and is not suitable for use in any important app.

Please report AppSheet Database problems here:

Introducing new AppSheet database feature in publi... - Google Cloud Community

[Marc_Dillon]

I think your description of what you're trying to do is very ambiguous, and you should greatly elaborate on it. Some questions: What is the record addition that is triggering the action? How is it related? Where is the CSV stored? Are you wanting to import a CSV into an Appsheet Table or spreadsheet? Are you actually using the new "Appsheet Databases" feature, or did you just use that as a generic term for an Appsheet Table?

[AndreStolpinsky]

Hi everyone, thanks for the answers.

I guess I didn't clarify it.

What I'm trying to do is. Take the information from the CSV file, and copy it to another table automatically when new rows are added to the csv file.

[dbaum]

That seems likely possible--although not necessarily easy or straightforward. There are lots of potential scenarios regarding how to monitor for new rows, how to retrieve the new rows, and how to replicate the new rows. To be able to offer concrete suggestions, community members with relevant expertise likely need more information--e.g., responses to the questions that @Marc_Dillon posed.

[AndreStolpinsky]

What is the record addition that is triggering the action? - Data Change in the CSV file

How is it related? Where is the CSV stored? Are you wanting to import a CSV into an Appsheet Table or spreadsheet? The CSV is stored in Google Drive. I want to import it to another table. Doesn't matter if it's Appsheet Database or just a table on the same drive.

Are you actually using the new "Appsheet Databases" feature, or did you just use that as a generic term for an Appsheet Table? I do use the Appsheet Database but don't have to

[dbaum]

It ought to be possible to use Apps Script to regularly check the .csv file and then replicate any updates elsewhere--e.g., in a Sheets spreadsheet that serves as the data source for an AppSheet table or by invoking the AppSheet API. If it met your need, you could presumably even just have Apps Script regularly read the entire .csv and fully overwrite a spreadsheet data source for an AppSheet app.

[Marc_Dillon]

Appsheet has no capability for monitoring of new data within a CSV.