After working with a variety of tech executives over the years, the one thing we know everyone needs is quick and easy access to Key Performance Indicators (KPIs). Some reports are complicated, but there are also certain simple topline numbers that are needed all the time, to prep for an investor call, or just to keep a finger on the pulse. The data exists in a spreadsheet, but pulling it up can take a big context switch that breaks the flow of whatever else you’re doing. So it’s nice to just be able to say, “Alexa, ask sheets KPI for our week over week revenue,” and that’s what this skill is for.
It works by linking your Google account with the skill. It’s is free for personal use (linking an @gmail.com account), and requires a subscription for business use (linking an account at your own guite domain). You’ll be prompted to subscribe right within the skill if needed, and there’s a 7 day free trial.
You can ask for single cells of data by column and row, for example, “read cell B12.” It is also designed to work well with named ranges, so you can say “give me monthly revenue by category,” and it will look for the closest matching named range, and read it back to you.
On first run, we send you an email, and you reply with the url of your spreadsheet copy-pasted into the email. Then, as long as your linked account has at least read access to that spreadsheet, you can read data from it, and switch to different sheets within it by voice.