Google sheets can also be retrieved in JSON format, which is what we use to process them with XSLT.

-Hans

Am Mi., 22. Mai 2019 um 05:45 Uhr schrieb Luís Oliveira <luismbo@gmail.com>:
On Wed, May 22, 2019 at 10:36 AM Nick Levine <nick@nicklevine.org> wrote:
> Has anyone tried reading a google spreadsheet from lisp (Allegro)? Searching produced a couple of libraries for this, and neither of them compiled cleanly (which is not where I wanted to spend my morning).

Would downloading the speadsheet in CSV format help or do you need to
access formulas, mark-up, etc? The CSV URL would be
https://docs.google.com/spreadsheets/d/{key}/gviz/tq?tqx=out:csv&sheet={sheet_name}
and then you could use one of the csv libraries.

Cheers,

--
Luís Oliveira
http://kerno.org/~luis/