New Tool: Guest Blog Query Generator

By On May 30, 2013 • Guest Blogging Comments (10)

Find guest blog opportunities with ease

Many of you might have noticed that my 1st guest blog query generator has stopped working last January. It stopped because the tool can no longer pull data from ubersuggest. And I did some investigation; I noticed that ubersuggest now demands for captcha solving in order to be used. Obviously this problem can’t bypass because we are pulling the data via Google Spreadsheets.


That is a sad, sad thing – But worry no more.

Just like a movie title, our favorite tool is now reloaded with a more capable keyword generator tool. It now utilizes Google Sets, a Google labs project (Discontinued but still available at Spreadsheets) that allows you to generate lists of similar terms by just typing a few examples.

This helpful tool helps you find hundreds of guest blogging opportunities without getting into so much trouble. All you need to do is follow these simple instructions to make it work:

Get the tool and play with it.

  1. Login to your Gmail first.
  2. Grab the spreadsheet by visiting this link
  3. Go to file tab and make a copy
  4. Follow the instructions in Cell B

To make things easier, here’s a GIF file that demo Google sets.

gif sets

 The parts of the tool

reload tool

A. Do the Google sets trick in order to pull data on CELL A. See the demo GIF image above.
B. Follow the instructions if you still can’t figure it out.
C. Do not mess with C,D,E cells.
D. Click on the search triggers and see the results

The results of the tool:


Thanks to Sean for hitting Google Sets –

Thanks to this post from GOS -


Jayson Bagio is the lead strategist of SEOteky. A digital marketing team from Manila, Ph who specializes in content marketing and link building. Get in touch with him using the contact form on the side or by visiting the about page. You can also follow him on twitter & google+.

join conversation

Related posts:

  1. Search Query Generator for Guest Blogging
  2. Guest Blog Prospector via Twitter and Google Docs – Teky Tools 2.0
  3. Mastering the 4 Pillars of Guest Posting
  4. Blog Commenting – Being Effective, This is How We Do It
  5. How to Connect With People When Doing Outreach for Guest Posts

10 Responses to New Tool: Guest Blog Query Generator

  1. MCS says:

    Hi Jayson, this is the best thing since sliced bread! But I can’t get the Google Sets thing to work. I am following and understand the instructions completely. Its just not pulling in related “sets”. Has Google removed the tool?

    I suppose one could use other tools to find related terms and just slap them in column A. But let me know if Sets still works for you.

    • Jayson Bagio says:

      Hi Miguel,

      Google Sets is still working :)

      1. Input a keyword to A2 (seo)
      2. Input a related keyword to A3 (blogging)
      3. Select A2 and A3, put your cursor on the box like highlight, hold control to A20. (See the GIF demo file)

      I hope you can make it work this time :)

      You can pull keywords (google sets) even on a plain google doc spreadsheet :)

  2. Lory Zhang says:

    Great tool. easy to use and understand. I am just on the way to find urls to submit guest blog. Your tool helps me a lot. Thank you

  3. Rajesh says:

    Really nice tool, loved it. Thanks for sharing with us :)
    Rajesh recently posted..Quix App: Awesome Bookmarklet for Bloggers and Web Professionals

  4. will says:

    Does the tool stilll work? I have tried several times with no success.

Leave a Reply

Your email address will not be published. Required fields are marked *


You may use these HTML tags and attributes: <a href="" title="" rel=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

CommentLuv badge

« »