Concepts

Concepts used in Google Sheets book.

The following documentation is for Google Sheets v1.6.3 (BDK).

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

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

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

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

json

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 in that row

list of list of any

table

Table the row belongs to

json

Last updated

Was this helpful?