Hi, I've searched the forums, but don't see any recent answers/responses.
Is it possible to connect to a CSV (the file updates daily but the file name remains the same) via an FTP connection/url to the csv that's hosted on an ftp server?
The dashboard was created in Tableau Desktop but is published to Tableau Public updated automatically on a daily basis (currently using google sheets but this is no longer an option).
Thanks in advance!
I've used the gspread package to write to Google Sheets. In the beginning, I wrote each cell one-by-one, but that is very very very slow, so I switched to a method where you essentially create a two-dimensional array (or maybe it's a dictionary) where the dimensions are row and column. You can then push all of those to the Google Sheet at once using the update_cells method. I've used that method in the following code: https://github.com/flerlagekr/Tableau-Public-Stats/blob/main/Stats.py
Since your source data is csv, it should be pretty easy to read in the csv file, write it to an array, then push it to google sheets.
