If you don't know, this Google Sheets add-on enables you to easily query the Meraki API and insert the formatted data into the Sheet. No coding required. Simply browse the available "reports" for the information you are looking for, fill in the query form and print to sheet!
Custom Cell Function
Now you can easily fetch Meraki data from a cell function and have the results inserted into the sheet.
=merakiFetchReport(url, apiKey, title, refresh)
Dynamic report option
This new button will insert a dynamic report utilizing the new custom function. This allows you to configure all of your query parameters required for the API call.
With this new capability, you can build custom dashboards using Google's Explore tool to quickly build charts, graphs and pivot tables that stay up to date.
OpenAPI spec selector
You may have access to beta or customer specific features limited to an organization.
Now you can select the version of the API.
Custom report for the OpenAPI specification
You may want to explore some common properties of the API, like the path, operationId or parameters. The natural JSON is pretty difficult to parse, so this custom report extracts the most important information and flattens the data into Sheet format.
MT sensor query selectors
Some additional query selectors, such as "metrics" have been updated to better support the new MT sensor options.
Initially, I was trying to run the "Organization Networks" report but it would never populate the data into the sheet even though the JSON data was available. We have over 200 Networks in one Org and ~40 in the other. Since that did not work, I tried something simple, like trying to list all my Org's (3 Orgs). But I got the same results, the JSON data was there but would not populate the sheet.
Hmm, so I just tried it using the Firefox browser and it's working. So it must be something with my Brave/Chrome browser. I have Shields disabled and even reviewed the browser extensions to see what else could be interfering. 🤷