Hi I have a python script that scrapes a football statistics website and saves two files of the same data to a directory "Round 14 2022 data" (1 file a .txt, 1 file a .csv). This process happens 4 times a week and overwrites each "Round" file where applicable, or creates a new "Round" file if there is not one previously. I am trying to use sheetgo to - 1. daily at Get the latest "Round" 2. transfer the data to a new tab on an existing google sheet 3. name the tab in the existing google sheet the same as the original file- ie "Round XX 2022 data" 4. add an identifier as to when it was transferred so I can see if any of the stats in that tab are new/updated 5. If the following night, there have been changes to the original file, then update the existing tab on the google sheet All help appreciated!! Regards - John

@"johnrock"#p536 any final feedback? Did it work out?

csv file to Google Sheet - overwrite and/or new tab

johnrock

Hi
I have a python script that scrapes a football statistics website and saves two files of the same data to a directory "Round 14 2022 data" (1 file a .txt, 1 file a .csv). This process happens 4 times a week and overwrites each "Round" file where applicable, or creates a new "Round" file if there is not one previously.

I am trying to use sheetgo to -

daily at Get the latest "Round"
transfer the data to a new tab on an existing google sheet
name the tab in the existing google sheet the same as the original file- ie "Round XX 2022 data"
add an identifier as to when it was transferred so I can see if any of the stats in that tab are new/updated
If the following night, there have been changes to the original file, then update the existing tab on the google sheet

All help appreciated!!

Regards - John

Cliff

johnrock does the CSV file always stay the same?

Then I think you could use consolidate from folder to only get the latest file. See this:

johnrock

thanks Cliff - the file name changes each time a new round is created!

Petr

johnrock I think even then @Cliff solution should work. Have you tried it already?

It should get the latest file from that folder regardless it's name.

Support from Sheetgo

johnrock any final feedback? Did it work out?

Willian from Sheetgo

@johnrock I think "Files in a folder" might solve your needs, you can either try using "Only data from the latest file" or "All the folder files", and the single Google Sheets file as a destination, in this way Sheetgo will automatically split your data into tabs (or new tabs when needed) in the final file, it will keep updating it whenever there is an update or a new CSV file in the folder.