User Tools

Site Tools

Trace:
ranktank_google_sheet_extension

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
ranktank_google_sheet_extension [2023/03/23 09:45] – jacoranktank_google_sheet_extension [2025/03/27 08:11] (current) – [Get Credits?] jaco
Line 1: Line 1:
 ====== RankTank Google Sheet Extension ====== ====== RankTank Google Sheet Extension ======
  
-{{::rt-application-banner_320x204.png?nolink |}}+{{::rt-application-banner_220x140-psy.png?nolink |}}
  
 Keyword rank checking automated for your domain using Google Sheets. Keyword rank checking automated for your domain using Google Sheets.
  
-RankTank removes limits found in many other keyword position tracking tools by allowing you to scan millions of keywords via an easy to manage and maintain [[https://gsuite.google.com/marketplace/app/ranktank/22225448367|Google Sheet Extension]].+RankTank removes limits found in many other keyword position tracking tools by allowing you to scan millions of keywords via an easy to manage and maintain [[https://gsuite.google.com/marketplace/app/ranktank/22225448367|Google Rank Checker Sheet Extension]].
  
 Our tools allow you to find out where you website ranks on Google in many common public and private locations. E.g. Canada, Vancouver International Airport (YVR). Our tools allow you to find out where you website ranks on Google in many common public and private locations. E.g. Canada, Vancouver International Airport (YVR).
Line 11: Line 11:
 Select the [[seo:technical:Google domains|Google Location]] and [[seo:technical:Google languages|Google Language]] from where you wish to scan and RankTank will go out and crawl, returning super-accurate SERP and finding where your domain ranks in real-time. Select the [[seo:technical:Google domains|Google Location]] and [[seo:technical:Google languages|Google Language]] from where you wish to scan and RankTank will go out and crawl, returning super-accurate SERP and finding where your domain ranks in real-time.
  
-[[{}https://gsuite.google.com/marketplace/app/ranktank/22225448367|Install Extension]] +[[{}https://gsuite.google.com/marketplace/app/ranktank/22225448367|Install Extension]] [[{}https://www.youtube.com/watch?v=u9-ubVHfCEk|Watch "How To" Video]]
- +
-===== Need an API instead of a tool? ===== +
- +
-This API is used by RankTank in all it's tools and allows access to a search engine proxy service, which is used to query and collect information about search engine results. +
- +
-[[{}https://seobot.com|Access the SEO Bot Rank API]]+
  
 ===== How does it work? ===== ===== How does it work? =====
Line 27: Line 21:
   - Get extensions within any Google Sheet or search the G Suite Marketplace for RankTank.   - Get extensions within any Google Sheet or search the G Suite Marketplace for RankTank.
   - Install individually to your account or to your G Suite domain.   - Install individually to your account or to your G Suite domain.
-  - Open a new Google Sheet or a new tab within an existing Google Sheet (required as RankTank will overwrite the styling on the tab).+  - **Open a new Google Sheet** or **a new tab within an existing Google Sheet** (required as RankTank will overwrite the styling on the tab).
   - Choose "Open sidebar" from the "RankTank" menu under "Extensions" or "Add-Ons" menu on your Google Sheet.   - Choose "Open sidebar" from the "RankTank" menu under "Extensions" or "Add-Ons" menu on your Google Sheet.
   - Login with your desired Google account and follow the tutorial.   - Login with your desired Google account and follow the tutorial.
Line 41: Line 35:
 **New ->** **Do not attempt to scan more than 400 keywords per tab**, also do not scan multiple tabs until each subsequent tab has 100% completed. **New ->** **Do not attempt to scan more than 400 keywords per tab**, also do not scan multiple tabs until each subsequent tab has 100% completed.
  
-**New ->** **Blocked by X-Frame-Options Policy** in sidebar, we have no idea what is causing this yet. Could by bypassed by installing the following browser plugin: [[https://addons.mozilla.org/en-US/firefox/addon/ignore-x-frame-options-header/]], theory is that underlying drive.google.com account not authenticated for Google user trying to login to sheet.+**New ->** **Blocked by X-Frame-Options Policy** in sidebar, we have no idea what is causing this yet. Could by bypassed by installing the following browser plugin: [[https://addons.mozilla.org/en-US/firefox/addon/ignore-x-frame-options-header/]], theory is that underlying drive.google.com account not authenticated for Google user trying to login to sheet. Try [[https://addons.mozilla.org/en-US/firefox/addon/multi-account-containers/|FireFox Multi-Account Container plugin]] if you use one browser with many Google Accounts active.
  
 **Careful ->** There is a known issue where **you should not use** https://example.com or http://example.com in your domain name to be searched for, **only use "example.com"**. **Careful ->** There is a known issue where **you should not use** https://example.com or http://example.com in your domain name to be searched for, **only use "example.com"**.
  
-**Fixed ->** There is a known issue where the sidebar does not load after signing in with Google if you have multiple Google accounts which are currently logged in, we are investigating this and will find a resolution to switch between accounts. For now the workaround is to make sure your browser is only logged into your primary Google account.+**Fixed ->** There is a known issue where the sidebar does not load after signing in with Google if you have multiple Google accounts which are currently logged in, we are investigating this and will find a resolution to switch between accounts. For now the workaround is to make sure your browser is only logged into your primary Google Account or try [[https://addons.mozilla.org/en-US/firefox/addon/multi-account-containers/|FireFox Multi-Account Container plugin]] if you use one browser with many Google Accounts active. 
  
 **Fixed ->** We have found that sometimes the extension help wizard does not fully complete on loading the extension and you may need to select help from the menu on the right (your profile picture) if you're still unsure of what to do to get started. You can also read more in the section below. **Fixed ->** We have found that sometimes the extension help wizard does not fully complete on loading the extension and you may need to select help from the menu on the right (your profile picture) if you're still unsure of what to do to get started. You can also read more in the section below.
Line 55: Line 49:
 |< 100% >| |< 100% >|
 ^ 1. Choose "Install" on the "RankTank Extension"   ^ ^ 1. Choose "Install" on the "RankTank Extension"   ^
-|{{:ranktank_g_suite_marketplace.png?direct |}}|+|{{:ranktank_g_suite_marketplace_new.png?direct |}}|
  
 |< 100% >| |< 100% >|
 ^ 2. Open Google Sheet Menu "Extensions" or "Add-ons" -> "RankTank" -> "Open sidebar" ^ ^ 2. Open Google Sheet Menu "Extensions" or "Add-ons" -> "RankTank" -> "Open sidebar" ^
-|{{:ranktank-add-on_screenshot_1.png?direct |}}|+|{{:rt-screenshot-1.jpg?direct |}}|
  
 |< 100% >| |< 100% >|
-^ 3. Sign in with your Google account, or any Google account linked to your profile. ^ +^ 3. Sign in with your Google Account, or any Google Account linked to your profile. ^ 
-|Now follow the steps below in **"Scan Keyword Rank"** to get scanning. Should you encounter any difficulty, feel free to get in touch by contacting us directly on Twitter via [[https://twitter.com/ranktankapp|@RankTankApp]].|+|Now follow the steps below in **"Scan Keyword Rank"** to get scanning. Should you encounter any difficulty, feel free to get in touch by contacting us directly [[https://ranktank.net/#contact|via our contact form]].|
  
 ===== Scan Keyword Rank ===== ===== Scan Keyword Rank =====
  
 ^ Step     ^ Description       ^ Screenshot   ^ ^ Step     ^ Description       ^ Screenshot   ^
-|**Set Domain**|//Enter the domain name you want to scan rankings for here.//|{{ ::rt-screenshot-2_1280x800.png?direct |}}| +|**Set Domain**|//Enter the domain name you want to scan rankings for here.//|{{ ::rt-screenshot-2.jpg?direct |}}| 
-|**Choose Locale**|//Choose which Google locale to use when scanning.//|{{ ::rt-screenshot-3_1280x800.png?direct|}}| +|**Choose Locale**|//Choose which Google locale to use when scanning.//|{{ ::rt-screenshot-3.jpg?direct |}}| 
-|**Choose Language**|//Choose which Google language to use when scanning.//|{{ ::rt-screenshot-4_1280x800.png?direct |}}| +|**Choose Language**|//Choose which Google language to use when scanning.//|{{ ::rt-screenshot-4.jpg?direct |}}| 
-|**Enter Keywords**|//Enter your keyword list to scan here and hit scan.//|{{ ::rt-screenshot-5_1280x800.png?direct |}}| +|**Enter Keywords**|//Enter your keyword list to scan here and hit scan.//|{{ ::rt-screenshot-5.jpg?direct |}}| 
-|**Hit Scan**|//Hit the big red scan button and experience keyword rank checking joy :D//|{{ ::rt-screenshot-1_1280x800.png?direct |}}|+|**Hit Scan**|//Hit the big red scan button and experience keyword rank checking joy :D//|{{ ::rt-screenshot-1.jpg?direct |}}|
  
 ===== Get Credits? ===== ===== Get Credits? =====
  
-Select your profile picture in the top right corner of the sidebar to open the RankTank menu and subscribe to any of the paid packages (Private, Major and General) in order to get more scan credits.+Select your profile picture in the top right corner of the sidebar to open the RankTank menu and subscribe to any of the paid packages (Recruit, Private, Major and General) in order to get more scan credits.
  
 ===== Scan Status Messages ===== ===== Scan Status Messages =====
ranktank_google_sheet_extension.1679564753.txt.gz · Last modified: 2023/03/23 09:45 by jaco