Opensourceseo.org Blog

June 21, 2019 in Logs, tools

Free SEO Crawler and Log Analysis tool worth your time (web based) – Seolyzer

Seolyzer impressed me right from the start and while it’s not open source, it’s free…

Read More
May 10, 2019 in API

Google Search Console API reference request examples

I found the documentation for the search console API reference to be robotic to say…

Read More
May 7, 2019 in Live Tests

Functions easier in Google sheets than Excel

There are quite a few functions I find much easier to use in Google docs,…

Read More
April 23, 2019 in API, Google Apps Script, Google Docs

Semrush API Library in Google Sheets (Google Scripts)

Updated! Finally ūüėČ V2 is here and solves a lot of issues, adds caching and…

Read More
March 1, 2019 in Methods

How to find live examples of SEO configurations across the web

If you’re looking for live examples of how directives or configurations are being treated by…

Read More
February 4, 2019 in Automation, Methods, Screaming Frog

Automating Screaming Frog Using Batch Scripts

A simple batch script which creates a time and date stamped directory, runs screaming frog…

Read More
November 29, 2018 in Methods

Useful Xpath Extractors for Screaming Frog (and other SEO crawlers)

This post lists Xpath extractors that can be used in most SEO crawlers, but describes…

Read More
October 27, 2017 in API, Methods

How to find a list of old URLs for any domain using the Wayback CDX API

How many times have we had to correct a bad migration? Don’t you wish you…

Read More
June 26, 2017 in Methods, search console

How to fetch and render a page in a test or staging environment safely

This question comes up a lot, and it isn’t that hard to execute a fetch…

Read More
June 25, 2017 in Google Apps Script, Google Docs

Extract URLs from XML Sitemaps in Google sheets

Get the Script > GitHub repository here Installation Copy the code from the¬†GitHub repository¬†onto your…

Read More