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.

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.

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).

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)
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?