---
title: "Alexa Rank Tracker built in Google Sheets with formulas and Google Apps Script – bencollins.com"
author: "Martin Hawksey"
date: 2020-11-25T14:31:00+00:00
modified: 2020-11-23T21:32:51+00:00
canonical_url: https://pulse.appsscript.info/p/2020/11/alexa-rank-tracker-built-in-google-sheets-with-formulas-and-google-apps-script-bencollins-com/
markdown_url: https://pulse.appsscript.info/p/2020/11/alexa-rank-tracker-built-in-google-sheets-with-formulas-and-google-apps-script-bencollins-com.md
categories:
  - "Beginner"
  - "Sheets"
  - "Snippet"
  - "Solutions"
tags:
  - "@benlcollins"
  - "benlcollins.com"
featured_image: https://pulse.appsscript.info/files/2020/11/chart-1-1024x436-1.jpg
description: "Clever post from Ben Collins highlighting how Google Sheets functions can be used to scrape Alexa tracking data. As a bonus Ben includes a little snippet of Google Apps Script to let you archive data over time. "
---

# Alexa Rank Tracker built in Google Sheets with formulas and Google Apps Script – bencollins.com

![Alexa Rank Tracker built in Google Sheets with formulas and Google Apps Script – bencollins.com](https://pulse.appsscript.info/files/2020/11/chart-1-1024x436-1.jpg)

> [https://www.benlcollins.com/spreadsheets/alexa-rank-tracker-sheet/](https://www.benlcollins.com/spreadsheets/alexa-rank-tracker-sheet/)
> Tutorial on how to build an Alexa Rank tracker in Google Sheets, using the powerful IMPORTDATA and REGEXEXTRACT functions and Apps Script.

Clever post from Ben Collins highlighting how Google Sheets functions can be used to scrape Alexa tracking data. As a bonus Ben includes a little snippet of Google Apps Script to let you archive data over time.

Source: *[Alexa Rank Tracker built in Google Sheets with formulas and Apps Script*](https://www.benlcollins.com/spreadsheets/alexa-rank-tracker-sheet/)

---

*Published by [Martin Hawksey](https://pulse.appsscript.info/p/author/admin/) on [Pulse](https://pulse.appsscript.info/). Original article: [https://pulse.appsscript.info/p/2020/11/alexa-rank-tracker-built-in-google-sheets-with-formulas-and-google-apps-script-bencollins-com/](https://pulse.appsscript.info/p/2020/11/alexa-rank-tracker-built-in-google-sheets-with-formulas-and-google-apps-script-bencollins-com/)*