Click here to get the tool!!

“File > Make a Copy”

As SEO’s, we are dealing with a huge number of keywords most of the times and it is hard to filter and tag them even the numbers are not higher than 200, it could be a very boring job for us.

While I am dealing with them, I tried to find quick ways with Google Spreadsheet. I just used mostly basic Google Spreadsheet formulas and “regexmatch” to minimize my manual efforts.

On this Google Spreadsheet I shared, I wanted to combine a few techniques I am using for keyword research processes to show you what you can do and how you can use Google Spreadsheet.

I am always sharing this stuffs with this disclaimer, I am not a programmer, I am not an expert Excel guy and I am just copy/paste expert of Regex. 🙂 But still, I want to share the quick tricks to you, which help me a lot.

How to Use?

First paste your keywords to “Past&Filter” tab.

On this tab you can filter your keywords. Negative keywords which contain word on Negative part will be removed from your final list. Positive part is for necessary words to be in a final list. You can also see the keyword density to figure out which keywords you will need and which ones you need to be removed.

! All searches work with Regexmatch. So writing “one” to negative may delete your all “iphone” keywords from the list. You can use a few regex things to make betters filters. I tried to give some examples but you can improve with your regex knowledge. Check here for Google regex reference: https://github.com/google/re2/blob/master/doc/syntax.txt

“Auto Tagging” tab is for tagging your keywords. I tried to add useful examples to make it easier to use. It uses regex search and there is “Exclude” section for better tagging. You can name tags if you want or tag names come directly from “Search Term”. (“|” means or for Regex, as on example above, if you want to tag only “iPhone X”s not XR or XS, you can add xr|xs to Exclude tab just get iPhone X searches.”

At “All Tags” tab you can see the all tags and its keywords.

“Get a Tag” section provides you yo choose the tag and get all of the keywords with this tag.

Note: I limited number of KWs with 1.000 but you can extend it. It can be slower with a huge number of KWs but I tried 5K to 10Ks and it worked well but slowly.

Click here to copy the tool! (V2.1.1 Updated)

---

!!! Update 2.1.1 !!!

There was a little bug, fixed.

!! UPDATE !!

Hi, I have published an update as v2.1. On this new version, you can choose country too! It was an important need for this tool, sorry for the late update.

— Old version spreadsheet: V2

---

Hi,

I updated my Keyword Research Tool with Google Autocomplete API with some new features I think it will make it more like a real SEO tool and make keyword research easier. 🙂

Here is a demo screenshot:

• 

Quick Tutorial for better understanding but I believe after you start to use it you will get it out easily. Before you start you need to Click custom menu “KW Research” at the top right and click “Configure & Start”. (They will ask too many permissions but you can be sure I will have no access to any of your data, you can check out the codes. I just have a Google Analytics code on the popup when you click Configure.)

1.Write the keyword to start your research:

After the KW Ideas comes to screen you can click the + button to add them to your list!

2. Write new keywords to continue or click main topics:

You can click the main topics to continue with this keyword. It will be copied to Keyword cell. Also you can continue with typing new keywords.

3. You can make it automatic to adding to lists:

You don’t have to click + icon every time if you want to add all keywords to your list.

4. Filters:

Finally, you can use Negative and Positive filters to make your list better. For example on the case of Screenshot, I am doing a KW research for “iPhone 7” so I put it to “Positive” to avoid to see other stuff on my list, and also added some negatives that I am not interested for my content.

So if you want to restart your research click to (-). All saved Keywords will be deleted.

Note: If you have the main topics to choose from the list you can paste them “KW Topics” tab. KWs will be on the dropdown menu.

You can copy this Google Spreadsheet file to start use the tool.

Thanks ^_^

NOTE: For somes, Google says it is not secure to use this script. BUT you can check all of the codes that I have no access to any of your data because you are copying the ALL code to your Drive and there is no other possible way to I can see your data.

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.

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

Cheers.

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.)

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 🙂

---

Notes:

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. 🙂

---

---

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