CODEWITHSUNDEEP
pythonpandasgoogle-sheetsgoogle-colaboratory
Jordan Tindi
Jordan Tindi

Reputation: 99

How do i automatically import a new csv file from my local pc to google sheets every minute?

i have a csv file in my computer that gets updated every minute. i currently know how to import this csv file to google sheets manually. is there an automatic way to import the csv file each minute and overwrite the data that is in the current sheet? i tried using IMPORTDATA() but it needs a url instead of retrieving from local drive

Upvotes: 2

Views: 1995

Answers (1)

Royce Yang
Royce Yang

Reputation: 43

Actually, I would recommend trying the absolute file address as a parameter passed to IMPORTDATA(). Like this:

IMPORTDATA("file:///C:/Users/myUserName/myFolder/myData.csv")

Another idea would be to sync your Google Drive with the local file. This way, you can provide a URL as input.

Upvotes: 1

Related Questions