Spreadsheets

A view that displays all Google spreadsheets. Note that the ID returned in this view will be different than the ID returned for the same entry in the Documents table. The ID obtained from the Spreadsheets view is used to make updates to, query, and execute other Spreadsheet specific operations.

Columns

Name	Type	Description
Id [KEY]	String	The assigned ID of the spreadsheet.
AuthorEmail	String	The email of the author of this spreadsheet.
AuthorName	String	The name of the author of this spreadsheet.
Name	String	The name of this spreadsheet.
Updated	Datetime	The last updated data and time of this spreadsheet.
Weblink	String	Link to the spreadsheet.

Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name	Type	Description
Email	String	The user name for the Google Account credentials.
Password	String	The password for the Google Account credentials.