Semrush or Ahrefs? Which Is More Cost-Effective       read the results →

Performing keyword research with Google sheets

Google Keyword research sheet

Keyword research helps you to uncover the words your audience enter into Google when looking for a service or product.
Performing keyword research can be a time consuming task and for this reason I’ve build the Google spreadsheet designed to make live just a little bit easier.

The “Google keyword research sheet” is a pre-programmed spreadsheet that connects with the SEO Review Tools keyword API. This means you can work with the API without any programming knowledge.

View the sheet Make your copy

Keyword data

  • Directly related keywords
  • Competition
  • CPC, average Cost Per Click
  • Monthly search volume

How to use this sheet

View the sheet Make your copy

The first time you use the sheet

Please note that I will NOThave access to your account and you will be the owner of the script running in your account. Becuse the Google authorisation screens can look pretty intimidating ;-))

  • Google will ask for authorization, click “Continue”
  • Select the account you want to use
  • Google will show the “Google hasn’t verified this app” message, click “advanced”
  • Click “Go to ImportJSON (unsafe)”.
  • On the “ImportJSON wants to access your Google Account”, click “Allow”

If you have any additional question or suggestions, don’t hesitate to contact me.

Related SEO spreadsheets

Please share Google SEO sheets, SEO Academy

Leave a Reply

Your email address will not be published.

Seen on …

Numbers and stats

103,705

Registered Members

9.3 / 10

Avg. tool rating

185,000

Monthly visitors

45%

Returning visitors

SEO Chrome ExtensionGet the new Chrome Extension!

SEO REVIEW TOOLS = built with in the Netherlands {Grunn'}!

Chrome extension

SEO Review Tools for Chrome is a Free extension which allows you to quickly check the URL you're visiting, with one of these 61 SEO tools.

Download now!

SEO Review Tools for Chrome
Close