To get started using your book rank dashboard, you will need to link it to your book on Amazon, give permission to the spreadsheet to link to this external source and automate checking Amazon for your latest rank.
It is always recommended that you make a copy of the original spreadsheet and rename it with the book you are tracking. This makes it easier to use the dashboard over and over again for all your books.
You can either view the full video instructions, or follow the steps below.
Click the Make a copy button
Rename the file to keep a master copy for future use
From the main menu, press: File > Make a copy
Give the dashboard a name e.g. Book Title Rank Dashboard
The new dashboard will open in a new tab
You will know if it's saved successfully when the cover appears
It is recommended that you use a clean link - no characters after the ASIN
A pop-up will appear saying Authorization Required. Click the Continue button
Click on the Google account you want to use
On the new screen, click on the word Advanced
Scroll down and click on the words Go to book rank dashboard
On the new screen, click on the Allow button
When you are back on the dashboard, repeast step 1
On the screen, you should see the last Rank Dashboard you setup on top of the list.
Click on the 3 dots on the right side
Click on the menu option, Triggers
On the new screen, click Add Trigger
On the popup, choose the following:
Dropdown 1 = saveData
Dropdown 2 = Head
Dropdown 3 = Time-driven
Dropdown 4 = Hour timer or daily
Dropdown 5 = select time of day or how often in hours
Click the Save button
Close the tab
Your dashboard will automatically save your rank information as per your schedule.
You no longer need to manually run this process. The latest date will automatically be presented on the screen.
You can see the full history on the History tab
If you require any more assistance in setting up your rank dashboard, or are interested in finding out how we can setup for you – email us by clicking here.
Copyright 2021 | Numbers The Write Way | © All rights Reserved
Product names, logos, brands, and other trademarks featured or referred to within this website are the property of their respective trademark holders.