I've been downloading the first sheet of old Google Spreadsheets as a TSV file using URLs like:
After creating some new Google Sheets, I notice that the URL format in exportLinks has changed to this sort of thing (could only see PDF and XSLX formats though):
But while either URL format works fine for the old Spreadsheets, neither of them works for the new Google Sheets... instead I get an error about this not being a P3P policy.
So can new Sheets only be downloaded using some new protocol surrounding the URL?
That would be sad.
I'm using the Python 2 Google API (because there hasn't been a Python 3 version).
Does it need to be upgraded?
Is there a Python 3 version?
Why does a P3P policy error show up?
What question should I be asking?
The Google Sheets I'm trying to download was created by me, although it is shared with others. I can export it from the menu in the browser, but can't grab it from my program. Would surely like to download data from the new Sheets, as well as the old Spreadsheets.
Here are my imports:
from apiclient import errors from apiclient.discovery import build from apiclient.http import MediaFileUpload from oauth2client.tools import run from oauth2client.file import Storage from oauth2client.client import OAuth2WebServerFlow
Edit: While I am using the Google Python library, additional testing using only the browser inspired by the first answer received from pnuts indicates that the same URLs have the same problems direct from an appropriately logged in browser, so the age of the Python library doesn't seem to be the issue.