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.