Concepts

Concepts used in Google Sheets BDK Book.

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	google sheet reference

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	drive file reference

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

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

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	sheet table reference

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	sheet table reference