This listing gives a partial view of the sheets available for access
(why just partial? see below). For these sheets, we retrieve sheet title,
sheet key, author, user's permission, date-time of last update, version (old
vs new sheet?), various links, and an alternate key (only relevant to old
sheets).
The resulting table provides a map between readily available information,
such as sheet title, and more obscure information you might use in scripts,
such as the sheet key. This sort of "table lookup" is exploited in the
functions gs_title
, gs_key
, gs_url
,
and gs_ws_feed
, which register a sheet based on various forms
of user input.
Which sheets show up in this table? Certainly those owned by the user. But
also a subset of the sheets owned by others but visible to the user. We have
yet to find explicit Google documentation on this matter. Anecdotally, sheets
owned by a third party but for which the user has read access seem to appear
in this listing if the user has visited them in the browser. This is an
important point for usability because a sheet can be summoned by title
instead of key only if it appears in this listing. For shared sheets
that may not appear in this listing, a more robust workflow is to specify the
sheet via its browser URL or unique sheet key.