Book Rank Dashboard Setup – Numbers The Write Way

Set Up Your Book Rank Dashboard

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.

Step by Step Instructions

Download & save after purchase

When you click the link to download your dashboard a new screen will open in your web browser.

Click the Make a copy button

Rename the file to keep a master copy for future use

Watch video

Create a copy

When you want to set up a new dashboard, open the master file.

From the main menu, press: File > Make a copy

Give the dashboard a name e.g. Book Title Rank Dashboard

Click OK

The new dashboard will open in a new tab

Watch video

Insert Amazon URL

The first step is to insert your book's Amazon link. Type or paste your link in the light yellow box at the top next to Amazon URL. Press enter on the keyboard.

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

Watch video

Give permission & check Amazon

On the main menu, click Check Amazon > Run

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

Watch video

Setting up the scheduler

Open a new tab and go to: https://script.google.com

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

Watch video

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.

Product names, logos, brands, and other trademarks featured or referred to within this website are the property of their respective trademark holders.