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.
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.
Dom, Heather (and Scarlett)