Task
We have: a spreadsheet at Google Drive.
We need: to get that spreadsheet as a PHP array.
CSV format seems to be a suitable one for this task, though it allows to download one sheet only.
One-liner
Wget should be installed for this to work:
Expanded solution
Alternatively, we can use cURL:
How to get spreadsheet URL
Spreadsheet can be either shared via secret link or published. In both cases you should add &output=csv
. Also, you can add &gid=N
to get Nth sheet.
References
- Similar approach (discovered too late, doh!)