A Quick Way Find Guest Post Opportunities with Google Sheets & Google Search Results (For Free)

Hi guys, I often see questions on this sub about what tools to use for SEO when you get started, but I feel like when you’re starting out, you don’t need a lot of fancy, expensive tools…

For example, for a really long time, I just used Google Sheets to find guest post opportunities by doing this:

Step 1: Collect a list of Google Search operators to find interesting guest posts

Eg : “[your keyword]” + “this is a guest contribution” / “[your keyword]” + “guest author” / “[your keyword]”+ inurl:guest-posts / “[your keyword]” + inurl:write-for-us

Step 2: Sign up for ScaleSerp, a freemium service that allows you to scrape the google search results (you get 125 searches for free/month)

Step 3 : Add the ImportJSON script by brad jasper on GitHub to your Google Sheet to be able to read JSON results

Step 4: Use your ScaleSerp API Key to scrape the results. The formula should look like this :

=ImportJSON("https: // api. scaleserp .com/ search?api_key=YOURSCALESERPAPIKEY &url=https: //www. google. com/search?q=%22%22+inurl%3Aguest-posts") 

That’s it! It’s pretty basic, but I feel that as a beginner, you don’t need to overcomplicate things too much! Just using this method is enough to get a few guest posts and start building relationships with other blog owners in your industry.

submitted by /u/moniquesexperiments
[link] [comments]

from Search Engine Optimization: The Latest SEO News https://www.reddit.com/r/SEO/comments/r5nxln/a_quick_way_find_guest_post_opportunities_with/>