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

2
votes

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

1
pythonpandasgoogle-sheetsgoogle-colaboratory
Write a cron job and let us know how it goes. Or use some scheduled notebook capabilities. – Kalanos
@HashRocketSyntax do you have some code you could direct me to? – Jordan Tindi
You need to change your mindset to "here is the exact code that i have tried, here is my error, help me figure out why or what i should do differently" post your code – Kalanos

1 Answers

1
votes

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.