I have been searching the Internet for a solution to automatically update a Google sheet doc with a dynamic CSV file hosted in Google drive. I have come across some paid solutions but nothing that works for the do-it-yourself users.
Linking a CVS file to a google sheet doc using the =IMPORTDATA(“”) works but does not update the google sheet when the CVS file changes. I am unsure if hosting the CSV file on Google drive creates issues when synching to a Google docs sheet.
Also, I try the Google script editor but was not able to make the Google sheet update automatically after setting up the update CVS function and trigger.
Has anyone found a way to automatically update a Google sheet with a dynamic CVS file? Is this a simple or complicated process?