Download from Public Google Sheet as CSV
I keep forgetting the syntax for this so here it is:
Second part - the spreadsheet ID :
Put it all together:
If you want a specific sheet, other than the first from the left, add the gid [&gid=xxxx] to the Third part above.
The gid can be found in the url address bar of the google sheet.
If you just want a range to download, then add, for example: [&range=A2:G] to the Third part above.