Concepts

Concepts used in Google Sheets book.

The following documentation is for Google Sheets v2.0.1 (BDK).

Google sheet table reference

Reference to a table inside a Google Sheets spreadsheet's sheet.

Field Name	Description	Type
id	Id of the table	text
name	Name of the table	text
sheet_reference	Sheet the table belongs to	json

Google sheet reference

Reference to a sheet inside a Google Sheets spreadsheet file.

Field Name	Description	Type
id	Id of the sheet	number
name	Name of the sheet	text
file	spreadsheet file the sheet belongs to	json

Google drive folder reference

Contains all information required to identify a folder in Google Drive.

Field Name	Description	Type
id	The id of the folder	text
folder_name	The name of the folder	text
parents	The ids of the parent folders	list of text

Google drive file reference

Contains all information required to identify a file in Google Drive.

Field Name	Description	Type
id	The id of the file	text
file_name	The name of the file	text
parents	The ids of the parent folders	list of text

Google sheet column reference

Reference to a column inside a Google Sheets spreadsheet's sheet.

Field Name	Description	Type
index	Index of the column	number
name	Name of the column	text
table	Table the column belongs to	json

Google sheet row reference

Reference to a row inside a Google Sheets spreadsheet's sheet.

Field Name	Description	Type
index	Index of the row	number
values	Values in that row	list of list of any
table	Table the row belongs to	json