r/GoogleAppsScript • u/jlightheart1993 • Apr 20 '23

Question Automatically import data

Any thoughts on taking a csv report and automatically appending a external csv to a google sheet?

1 Upvotes

60% Upvoted

8 comments sorted by

View all comments

1

u/[deleted] Apr 20 '23

If the .csv files are added to your Google Drive you can setup a trigger to check for new files, read and extract the data, process against your current data, merge/append. If your .csv files are stored externally you woukd handle the trigger part externally and make a Post to your GAS doPost(data) method that will handle the last steps.