How to get data from google docs?

Question

Google

Good day to all!
Such is the question. There are about a dozen or two documents stored on google spreadsheets in the public domain.
(I think it matters)
I would like to parse information from these documents.
PS Nothing legal - I just want to systematize them in the right form for myself. Data from different documents are connected))
I found with a quick Google search from 10 scripts and libraries - but API_TOKEN is needed everywhere - there is no access to the account through which the documents were created (I'm not the owner).
Is there any way to do this without a token? Or what would you recommend?

Answer 1

is it hard to save? even tables are downloaded as a file, not page by page

Answer 2

dimonchik2013 (it might be interesting)
The most interesting thing is that everything turned out to be much easier than expected! The entire document (on Google docs) is built so that there are only those columns and rows that are filled.
Eat if the table has 5 columns and 40 rows. That are numbered (according to exel ABC | 1 2 3) exactly 5 columns and 40 rows.
Therefore, the usual file_get_contents($googleDocUrl);one will return the pages))
And if you go through the parser, you can get

<table>
  <tr>
    <td></td>
    ....
    <td></td>
  </tr>
  ....
  <tr>
    <td></td>
    ....
    <td></td>
  </tr>
</table>