User Tools

Site Tools


ranktank_google_sheet_add-on

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
Next revisionBoth sides next revision
ranktank_google_sheet_add-on [2020/04/16 07:11] jacoranktank_google_sheet_add-on [2023/02/06 12:23] jaco
Line 12: Line 12:
  
 [[{}https://gsuite.google.com/marketplace/app/ranktank/22225448367|Install Add-On]] [[{}https://gsuite.google.com/marketplace/app/ranktank/22225448367|Install Add-On]]
 +
 +===== 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]]
 +
 +===== Special Discount =====
 +
 +<hi>**RankTank COVID-19 Recovery Special:** Grab the “Recruit” package in the sidebar under “Subscription” in the [[https://gsuite.google.com/marketplace/app/ranktank/22225448367|RankTank Google Sheet Add-On]] before the end of May 2020 and… **Lock-in 5000 scans/month forever @ $9/month (60% OFF)** -> **No domain or keyword limit!**</hi>
  
 ===== How does it work? ===== ===== How does it work? =====
Line 17: Line 27:
 With the RankTank Add-On you can easily automate the task of checking where your domain name is ranking within search engine result pages. This is all done from within any new or existing Google Sheet. With the RankTank Add-On you can easily automate the task of checking where your domain name is ranking within search engine result pages. This is all done from within any new or existing Google Sheet.
  
-RankTank runs within any Google Sheet via the "Add-Ons" menu. You can either "Get add-ons" from the menu and search for RankTank or follow the steps below to browse to it directly.+RankTank runs within any Google Sheet via the "Extensions" or "Add-Ons" menu. You can either "Get add-ons" from the menu and search for RankTank or follow the steps below to browse to it directly.
  
   - Get add-ons within any Google Sheet or search the G Suite Marketplace for RankTank.   - Get add-ons 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 "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.
  
-|< 100% >| +**Note:** You may select your profile picture in the top right to open the RankTank app menu and subscribe to any of the paid packages in order to get more scan credits
-**Note:** You may select your profile picture in the top right to open the RankTank app menu and subscribe to any of the paid packages in order to get more scan credits.+ 
 +**Note:** Please be aware of the important known issues below.
  
 ===== Known Issues (Important) ===== ===== Known Issues (Important) =====
  
-**Do not include "https://" in your domain name to search rankings for, use only "example.com" instead of "https://example.com".**+**New ->** **Any issue with logging into the RankTank sidebar**, logout of all Google accounts, make sure to login to the same Google account on https://drive.google.com as on the sheet, your browser (e.g. Chrome) and the RankTank add-on. 
 + 
 +**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. 
 + 
 +**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.
  
-//**Fixed ->** We have found that sometimes the add-on help wizard does not fully complete on loading the add-on 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 add-on help wizard does not fully complete on loading the add-on 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.
  
 ===== Getting Started ===== ===== Getting Started =====
Line 45: Line 62:
  
 |< 100% >| |< 100% >|
-^ 2. Open Google Sheet Menu "Add-ons" -> "RankTank" -> "Open sidebar" ^+^ 2. Open Google Sheet Menu "Extensions" or "Add-ons" -> "RankTank" -> "Open sidebar" ^
 |{{:ranktank-add-on_screenshot_1.png?direct |}}| |{{:ranktank-add-on_screenshot_1.png?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]] or [[https://twitter.com/Jaco_van_Wyk|@Jaco_van_Wyk]].|+|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]].|
  
 ===== Scan Keyword Rank ===== ===== Scan Keyword Rank =====
ranktank_google_sheet_add-on.txt · Last modified: 2023/03/27 11:15 by jaco