Google Spreadsheet Prerequisite
How to create a spreadsheet to use for TVAlertsManager.
TVAlertsManager stores your TradingView alerts using Google storage via a Google Sheet. This means a Google Sheet is needed to be accessible to the TVAlertsManager extension. We recommend creating a new Google Sheet for this purpose. While it is possible to use an existing Google Sheet, it is not advised. These instructions assume creation of a new Google Sheet.
How to create the Spreadsheet:
Ensure the Google Account that will store the TVAlertsManager spreadsheet is signed in.
This is easily confirmed by go to http://google.com/ and the familiar account profile icon appears in the top right of the web-page. Clicking on the profile icon will display a pop-up showing the Google account currently logged in. The spreadsheet will be created on the Google Drive associated with the Google Account that is currently signed in..
Step 1: Head over to https://docs.google.com/spreadsheets/, then click the "+" sign to start a new blank spreadsheet as seen below.
![](https://guide.tvalertsmanager.com/~gitbook/image?url=https%3A%2F%2F2310143482-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FhlMz1tYQ3aK9UUEiqhSP%252Fuploads%252FdUh4z0n389XIMA1N10t4%252F20%2520-%2520Google%2520Sheets%2520-%252001-Static.png%3Falt%3Dmedia%26token%3Dac79616a-8161-4265-b474-f575c8c31a5a&width=768&dpr=4&quality=100&sign=505daa45&sv=1)
Google Sheets will create a new blank spreadsheet and display it ready for editing, etc.
Step 2: Google has the requirement that prior to being able to share a Google Sheet, it must have a file name other than the default name ‘Untitled spreadsheet’. Therefore rename the new blank Google Sheet to a descriptive name.
Click on the name field containing ‘Untitled spreadsheet’ found in the top-left corner of the window, then type a descriptive name, such as in this guide the Google Sheet is renamed to ‘TVAlerts’. Afterwards typing the new name either press the <enter> key, or click anywhere on the sheet to complete renaming the Google Sheet.
![](https://guide.tvalertsmanager.com/~gitbook/image?url=https%3A%2F%2F2310143482-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FhlMz1tYQ3aK9UUEiqhSP%252Fuploads%252FEIwBZgI1zHDTeXIzMLrk%252F21%2520-%2520Google%2520Sheets%2520-%252002%2520-%2520Static.png%3Falt%3Dmedia%26token%3Dffa55e0d-ce54-4847-a6f8-fda3ba068319&width=768&dpr=4&quality=100&sign=37ec2afa&sv=1)
As seen below, the spreadsheet is renamed to the title that has been entered.
Tip: Name the Google Sheet appropriately, so you can find it later easily.
![](https://guide.tvalertsmanager.com/~gitbook/image?url=https%3A%2F%2F2310143482-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FhlMz1tYQ3aK9UUEiqhSP%252Fuploads%252FHMXbNOt5tdQGJYNWDM7H%252F21%2520-%2520Google%2520Sheets%2520-%252003%2520-%2520Static.png%3Falt%3Dmedia%26token%3D9a5bb51d-ca2a-43bc-95df-e7c00c1667bc&width=768&dpr=4&quality=100&sign=880258c4&sv=1)
Step 3: (optional) Tip: Bookmarking the spreadsheet will allow finding the spreadsheet again easier. To bookmark the Google Sheet, press <CTRL> + <D> to open the bookmark pop-up, or click the browser’s bookmark icons (typically an icon of a star on the same row as the browser’s URL bar), as shown below following the numbered tasks 1 & 2:
![](https://guide.tvalertsmanager.com/~gitbook/image?url=https%3A%2F%2F2310143482-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FhlMz1tYQ3aK9UUEiqhSP%252Fuploads%252F5LhWLOW7Z5CIwtoYTf7k%252F23%2520-%2520Google%2520Sheets%2520-%252004%2520-%2520Static.png%3Falt%3Dmedia%26token%3Df078041b-4175-466b-b5ec-d0d94565fc60&width=768&dpr=4&quality=100&sign=7819af26&sv=1)
Step 4: The Google Sheet created needs to be accessible using the Google Drive Sharing option. To share the new TVAlerts Google Sheet, click on the ‘File’ menu, click on the ‘Share’ menu, then click on the menu option ‘Share with others’ as in the example below following the numbered tasks 1, 2 & 3:
![](https://guide.tvalertsmanager.com/~gitbook/image?url=https%3A%2F%2F2310143482-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FhlMz1tYQ3aK9UUEiqhSP%252Fuploads%252Ff8HiAGpy6yRDiGQOpF3U%252F24%2520-%2520Google%2520Sheets%2520-%252005%2520-%2520Static.png%3Falt%3Dmedia%26token%3D3086259d-8173-4d62-adef-1c9a837a96e9&width=768&dpr=4&quality=100&sign=baefa1dc&sv=1)
Step 5: In the Google Sheet Sharing pop-up window, click on the ‘down arrow’ (drop-down control box) labelled as ‘Restricted’, then select from the drop-down list ‘Anyone with the link’, then click on the ‘Done’ button, as in the example below following the numbered tasks 1 & 2:
![](https://guide.tvalertsmanager.com/~gitbook/image?url=https%3A%2F%2F2310143482-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FhlMz1tYQ3aK9UUEiqhSP%252Fuploads%252F4pmRFr1YevTmspxJZAeQ%252F25%2520-%2520Google%2520Sheets%2520-%252006%2520-%2520Static.png%3Falt%3Dmedia%26token%3Da3503351-ac4a-4b70-b728-c952933ac62f&width=768&dpr=4&quality=100&sign=99dcd8a2&sv=1)
The Sharing pop-up dialogue will change to show new options by revealing a new drop-down list used to define sharing permissions.
Click on the drop-down list arrow containing the word ‘Viewer’, then select ‘Editor’. Finally click on the ‘Done’ button, as in the example below:
![](https://guide.tvalertsmanager.com/~gitbook/image?url=https%3A%2F%2F2310143482-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FhlMz1tYQ3aK9UUEiqhSP%252Fuploads%252F4Jsy7Fb8u4P4ApkcKx4M%252F25%2520-%2520Google%2520Sheets%2520-%252007%2520-%2520Static.png%3Falt%3Dmedia%26token%3D41881a0f-3248-4ce9-bafd-b3f09961c231&width=768&dpr=4&quality=100&sign=b352cdc8&sv=1)
Step 6: Click on the ‘Copy link’ button located in the bottom left corner of the 'Share TVAlerts' pop-up window. This will copy the 'access URL' of the Google Spreadsheet to the clipboard as it will be needed later to enter into TVAlertsManager Chrome extension in the setup process.
Pasting this link into an empty notepad file may be helpful, if you use the clipboard frequently.
Last updated