Meraki Tools add-on for Google Sheets - Updated!

DexterLaBora
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!


MerakiTools-quick-demo.gif



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)

DexterLaBora_0-1652350560903.png

MerakiTools-cellfunction-demo.gif




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. 

 

DexterLaBora_1-1652350728540.png

 

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.

DexterLaBora_2-1652351034458.png

 

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.

 

DexterLaBora_3-1652351160600.png

 



MT sensor query selectors

Some additional query selectors, such as "metrics" have been updated to better support the new MT sensor options. 

 

DexterLaBora_4-1652351336479.png

 

 

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

 

 

2 REPLIES 2
Inderdeep
Kind of a big deal

@DexterLaBora : Thanks for the update 

Regards/Inder
Cisco IT Blogs awarded in 2020 & 2021
www.thenetworkdna.com
PhilipDAth
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.