Google Spreadsheets for Digital Marketers

Extract data from Wikipedia
Wikipedia is a trusted source of information that ranks for the majority of two-word search queries, so looking at its data can reveal trends and popularity. With this post, you are a few clicks away from creating a simple data mining tool. This handy add-on gives you the power...
Download Search Analytics data
This post shows you how to set up automatic monthly backups of Search Analytics data from Google Search Console. Spoiler alert: No coding skills required. Google Search Console (formerly Google Webmaster Tools) is a powerful tool that provides insights into how Google understands your website. It’s a set of tools...
Web Scraping
This tutorial shows you how to scrape web pages by using Google Spreadsheets instead of using web scraping tools. The suggested method is very useful for a smaller set of URLs. What is Web Scraping? Web Scraping is a process of extracting specific information from web pages. How to Scrape a Website? You...
Google Analytics Event Tracking
Google Analytics event tracking is a powerful feature that allows you to track visitors’ interactions with your website that would not be tracked normally. It’s important to mention that Google Analytics is only as good as the setup. If you only insert the JavaScript code into the source code and...
301 Redirect Generator
Use 301 redirects to protect hardly gained positions in search results and don’t let visitors find your certainly awesome 404 page. This straightforward 301 generator helps you manage simple redirect rules in one spreadsheet. What is a redirect? Redirection is forwarding website’s visitors and crawlers to a different URL than the...