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".
Spreadsheet name: "TVAlertsManager" Sheet name: "Sheet1"
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 spreadsheet ID or link is used instead of the spreadsheet name 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.
The sheet name is used to tell the extension where to save and load alerts.