Guest Blog Prospector via Twitter and Google Docs – Teky Tools 2.0

By On December 18, 2012 • Link Building Comments (3)

Increasing your efficiency to any SEO or link building work is important. It was just a month when we presented our search query generator for guest blogging and many people find it useful and effective on their guest blog prospecting assignments.

Today let us share to everybody another great tool that we use here in SEOteky.  A simple twitter prospector for guest blogs (via Google Docs Spreadsheet).

finding robot

Why use the tool?

Social integration is important for many blogs. In guest blogging, one of many signals that we look into is the blogs activity on twitter and Facebook. Having good numbers in social space always reflect readership and thought leadership of the blog in its industry. Using this tool, you will be able to track tons of guest posts from different blogs and opportunities at the same time – all in twitter.

What this tool does?

1.Track shared guest posts in twitter from different blogs in one spreadsheet.
2.Track people who are looking for guest contributors, bloggers, writers.
3.Track people who tweeted and RTd the posts and engage them.

The Tool

teky tools twitter tool

A much easier way to track guest blogging related posts in twitter. NO TWITTER API USED so don’t ask for impossible stuffs that needs twitter API :)

Grab a copy of the tool

Steps to follow in order to have a copy of the tool:

1. Make sure that you are logged in to your Gmail account.
2. Go to this link –
3. Go to File tab in the menu and click make a copy
4. Save your copy on whatever name you want
5. Done

Working with the Tool

Assemble your tool by choosing the footnote or byline and adding your keyword of choice through the select drop down options.

teky tools 2

Choose your footnote from the list (B1), “guest post by, guest blog by, this is a guest post, looking for guest bloggers and so on

teky 2-3

Choose your keyword from the list (D1), and see a refreshed result of your search

Important: This tool scrapes the latest tweets that involve your search. Also display the current and fresh tweets to the oldest. Up to 200 tweets at the same time. Every time you load the tool or select any choice from the drop down menu, the results get updated.

To save your search, follow the simple instruction below:

duplicate sheet
 Go to the bottom of your spreadsheet and click the current tab, choose duplicate

Authors Note:

Finding high quality guest blogging gigs is the most crucial part of taking your guest blogs into a higher level. Having tools like this adds more prowesses to the scalability of your guest blogging work and improves your link building strategy as a whole. Guest blogging is just a tactic included in your strategy, doing it with efficiency is important to increase productivity.

If you love the tool, show your appreciation by following us on twitter, add us on your Google+ circle and like us on Facebook.

If you feel like the tool is short on keywords, you can also download the sheet that allows you to put your own keywords on D2 : Grab it here


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. 70 Ways To Find Guest Posting Opportunities Using Google
  3. Blog Commenting – Being Effective, This is How We Do It
  4. Mastering the 4 Pillars of Guest Posting
  5. How to Connect With People When Doing Outreach for Guest Posts

3 Responses to Guest Blog Prospector via Twitter and Google Docs – Teky Tools 2.0

  1. Armon Gatus says:

    Thank you SEOteky for this wonderful tool. ^_^
    Armon Gatus recently posted..How Does Affiliate Marketing Work?

  2. I’ve been blogging for three years and this year I am planning to explore guest posting. Thank you for this article Jayson.
    Guillermo Bautista recently posted..6 Awesome Sites for Learning Number Properties

  3. Kath says:

    Great post! My website is new and I am planning to do guest blogging and I found this post while searching on Google. Thanks for the helpful post, I will try to use your tool since I’ve been using Google docs for awhile now.
    Kath recently posted..2013: Top 5 SEO Tips for Content

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

« »