Spreadsheet and Sheet Definition

Reviewing Spreadsheet and Sheet Definitions.

To work with TVAlertsManager we must review and understand the difference between a "Spreadsheet" and a "Sheet" on Google Sheets.

In Google Sheets, the spreadsheet is the overall document, which can contain multiple sheets inside.

Spreadsheet: In the example below, the current spreadsheet name is "TVAlertsManager" which contains the sheet named "Sheet1".

Sheet: In the example below, the current sheet is "Sheet1" which is located inside spreadsheet "TVAlertsManager".

When using TVAlertsManager the spreadsheet name is not recorded nor used. The spreadsheet ID (or link) is used instead to tell the extension which spreadsheet to work off of.

The sheet name is what is changed to differentiate which sheet the extension will save and load alerts on.

Last updated