Easy and Fast Keyword Research Tool with Google Autocomplete API

Shut up and give me tool's link: is here

When I am doing Keyword research for content, I don’t like to give the keywords and search volumes and say put them into the content to content writers. I think for SEO content and writers should focus on what the audience is searching for on the topics.

Google Autocomplete is an important tool to find out what the people are searching. And interestingly while some of Google API’s are so limited or hard to use, Google Autocomplete API is free, unlimited and works without API key.

So I created a very basic new tool with Google Spreadsheets to make easier and faster Keyword research for SEO and Content writers by this API. It just gives you keywords by the API, very similar to Keywordshitter but searches for the keyword you entered and search again for the suggested keywords of the result keywords.

Keyword Research Tool

To use the tool just copy this Google Spreadsheet file!

Just change the Keyword and Language to get the results!

“KW Research” tab is the main page of the tool. Just change the keyword in the grey area and you will get the autocomplete words.

“ALL KWs” tab will give you the list of all keywords so you can just copy them to share or get search volumes on Google Keyword Planner.

“KW Topics” is the tab, if you are sharing this tool with your content writer. You can just paste your main keywords for the topics and content writer will be able to choose the keyword from the drop-down menu on “KW Research” tab:

Note: I used Google Spreadsheet importjson code of bradjasper. It is also really helpful code to get any JSON content easily to Google Spreadsheet.  https://github.com/bradjasper/ImportJSON


Free SEO Tool to Monitor Website Changes with Google Spreadsheet

SEOcheck is updated. “v1.1” to find out the upgrades, check the descriptions below the post. And also please subscribe my mail list to get the updates.

I have created a free SEO tool with Google Spreadsheet to monitor and get email alerts important SEO changes on pages of your or client’s websites like Title, H1, Description, Canonical and also robots.txt. I named it SEOcheck. 🙂

When I started to work as SEO, my colleagues were complaining about our clients were changing important SEO aspects of the pages on the important pages. Later on I searched for tools to monitor changes important elements of the page and could not find any working well, easily ones. I tried to build tools to monitor daily organic traffic and also change monitors like this tool. Today I wanted to share this tool to help you monitor most important pages of your clients’ websites to prevent important SEO crises.

What is SEOcheck?

SEOcheck will be checking 20 most important pages of websites for every 15 minutes and robots.txt for every 30 minutes so you will be able to catch up the important changes nearly as it happens.

Because of the limits of Google App Script, I limited it with 20 URLs. Also most of the websites get mostly all of their traffic from first few pages of them.

Please copy this Google Spreadsheet File to use SEOcheck v1.1

How to Use?

This is the screenshot of the configuration page of the tool. On this stage, you need to fill the fields like Name of Website (It will be used on emails you get, You can name your websites anything you want.) Website will be used for checking robots.txt so you need to put correct URL with “/” end of it. Alerts Emails are the email addresses will be notified if there is an important change. Finally, you can paste Top 20 URLs of your website to monitoring. These URLs will be monitoring for changes. (You can just export the important URLs from Google Search Console, Google Analytics or put the pages important for you.)

Free SEO Tool

After that you will see the custom menu to start your tool to work:

Click to Configure and to start monitoring Titles, Descriptions, H1s and Canonicals for 20 URLs and robots.txt of the website. After you need to give access* the Google App Script code to execute, SEOcheck will be ready.

If you have any important changes on your pages in the URL list you will get Email alert like this:

And if there is a change on your Robots.txt file you will get an email like this:

Thanks 🙂


  1. I am not a programmer, I am just trying to use Google App Script to automate SEO processes so the code and the script created by using, mixing and manipulating other sources so there could be some problems on the tool. I added a line in the main page of the tool to announce if there is a new or fixed version of the tool. There could be some problems on the script please let me know if you found any bugs.
  2. Hope this will be helpful for you 🙂 If you have any comment or questions please write to me mert@mertural.com

* By giving this access you will give permission to script to operate. This will not give me any access to any of your information. But I have a Google Analytics code on the page after you see after you give the access to monitor the usage of the tool. Also, I added some fields to the right of the grey line on “conf” tab on the spreadsheet file to be in communicate with you if I have anything new to announce.

But this a Google Spreadsheet tool all free and open code so you can change and edit all of the options. 🙂

Subscribe to mailing list to get updates

* indicates required

SEOcheck v1.1 – WHAT IS NEW?

Bug fixes:

There was a 2 important bugs, one of them was about giving 404 errors when website was not reachable by the tool and the second was failing executions because of the Google App Script limits.

  1. If script couldn’t reach the website, tool was giving 404s for pages. It was annoying for the websites with huge traffic because sometimes they could be not reachable for a little time and you can get 404 alerts so many in a day. Now If tool can’t reach website, It sets a trigger to re-check after 10 minutes.
  2. Because of limitations of Google App Script, and if you use the tool for so many websites you can reach the limits of Google. That is why I updated checking times for URL’s from 15 minutes to 30 minutes and for Robots.txt from 30 minutes to 1 hour.
  3. I realized if you click Configure more than 1 times, script creates new triggers, so it could also cause to use Google sources more. Now everytime you click to Configure it starts over.

Better Now:

  1. I updated the custom menu. You can now Stop and Check whenever you want. Also when you click “Check Now!” you get little popups about the results:

Older versions:

v1.0: SEOcheck V1.0