in Product Updates

New Feature : Embracing the Spreadsheet

If you just want to know about the feature, the scroll down to see the header, however if you’d like a bit of backstory, read on!

When I sit down and think of a new tool to build, the thought process often starts with, “what are people using spreadsheets for that could be easier with an app” and then set off to work.

Spreadsheets seem to be at the core of every company and there is usually a 3 year old spreadsheet with macros, vlookups and some magic that makes some core functionality of the business work.

However, there is a reason that spreadsheets are so universal, because they are EASY to start with, shareable, simple to learn and can grow with complexity as needed.

So when Declan Reilly from The SEO Works suggested that he manage the URLs and notification options in LW, I was originally skeptical…

But the more I thought about it, the more I realised that we receive URLs from customers in spreadsheets all the time so why wouldn’t we do this.

So from today, when you go to add URLs to your account, you’ll be given the option of doing so via Google Sheets.

Once created, each sheet is initially locked down to the email address on the account but others can be added in settings.

When you click the sheet, you are given three tabs.

  • Source
  • Overview
  • Renewal Report

Source

This tab is the only one you are able to edit, you and your team can quickly add/remove URL’s, notification options and enable checks, this sheet is imported and updated every hour.

Just add a URL to the spreadsheet and it will be added with the default checks and notification options, if you’d like you can configure the checks more specifically

Overview

This tab gives you a quick heads up to any outstanding issues on the URLs and links directly to those URLs so you can configure the checks (or disable them).

This could look a bit prettier I know but we are trying to limit API commands

Renewal Report

This tab gives you a quick overview of domains and SSL certificates that are expiring.

Feedback from our testing team has been overwhelmingly positive and we are really really excited to ship this update to everyone for free now.

Next up we’ve got a few speed improvements to do on the backend and then another feature we’ve been excited to launch for a while.

Thanks

Dom, Heather (and Scarlett)

Write a Comment

Comment

  1. Appreciate the mention! This has really helped us out.

    We combined this new LW feature with the “=QUERY(IMPORTRANGE(” formula to automatically bring in data from our own list of client URLs.

    So now we know that all URLs being monitored are fresh and relevant to us, as well as the notifications going to the right places. We all know that it can be annoying to still receive notifications for a project you no longer directly work on!

    I can do a demo article of how this can work if anyone thinks it could help them?