Meraki Tools add-on for Google Sheets - Updated!

Meraki Employee

Meraki Tools add-on for Google Sheets - Updated!

There have been some exciting new updates added to Meraki Tools!


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!


What's New?

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.


DexterLaBora_6-1652352571983.png.           DexterLaBora_5-1652352416780.png




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. 





Add Meraki Tools to your Google Sheets now!

Visit the Google Marketplace to get the add-on.


Or, add it from within your Google Sheets
Toolbar --> Extensions --> Add-ons --> Get Addo-ons --> Search: Meraki Tools



Kind of a big deal

@DexterLaBora : Thanks for the update 

Cisco IT Blogs awarded in 2020 & 2021
Kind of a big deal

I'm looking forward to the Excel version ... you know, the #1 used BI tool globally, by a long way.

Get notified when there are additional replies to this discussion.
Welcome to the Meraki Community!
To start contributing, simply sign in with your Cisco account. If you don't yet have a Cisco account, you can sign up.