cancel
Showing results for 
Search instead for 
Did you mean: 

Meraki Dashboard Reports with Google Sheets

Meraki Employee

Meraki Dashboard Reports with Google Sheets

I created a simple tool to import Meraki Dashboard API data directly into a Google Sheet. 

 

Check out the full write-up

https://create.meraki.io/build/meraki-dashboard-reports-with-google-sheets/

 

(view in My Videos)

 

If you have cool ideas or feedback, let me know!

 

11 REPLIES
Head in the Cloud

Re: Meraki Dashboard Reports with Google Sheets

Very cool. I can see this being quite useful. Nice work!

Kind of a big deal

Re: Meraki Dashboard Reports with Google Sheets

Awesome thanks

Adam R MS | CISSP, CISM, VCP, MCITP, CCNP, ITILv3, CMNO
If this was helpful click the Kudo button below
If my reply solved your issue, please mark it as a solution.
Meraki Employee

Re: Meraki Dashboard Reports with Google Sheets

Now with more reports!

 

+ admins

+ device details

+ clients

 

GoogleSheetsMerakiReports-2.png

New here

Re: Meraki Dashboard Reports with Google Sheets

This is great, thank you! Anyway you could add a function to return the uplink status to the code? 

 

api call is {{baseUrl}}/networks/{{networkId}}/devices/{{serial}}/uplink 

 

 

Meraki Employee

Re: Meraki Dashboard Reports with Google Sheets

Hi Ben,

 

You can use the Device Status report to get the uplink status for every device in the org. This is a very fast call, as it returns an array of every device in the organization by default.

 

I could write a recursive script to iterate through every device in every network in every org... but that takes a lot longer. If there is critical information in that call that you still need, I could consider writing an additional report.

 

I added some extra reports and refined how the data is parsed be more dynamic with available attributes.

Make sure you the newest script (simply replace yours with this new one). 
https://gist.github.com/dexterlabora/9884aa4399715df8f453ea9de63255a0

 

(formatting colors were applied after report)

Google Sheets Meraki Reports - Device Status.png

Conversationalist

Re: Meraki Dashboard Reports with Google Sheets

This works great, however, I am getting 'Exceeded maximum execution time' when running the clients script.

 

Any ideas how to fix this?

Meraki Employee

Re: Meraki Dashboard Reports with Google Sheets

This script takes a while because it iterates through every device in every network to pull clients over a period of 86400 seconds.

 

 

I was motivated by this question, so I have updated the script with a few additions. I've added a timespan and network setting so you can focus on a particular network and limit the search range.

 

I also extended the reports with a Details version, that makes an API call for every client to get its SSID and other info. This will likely break on a large network, but I built it for another use case. 

 

Replace your existing code file with this one

Code.gs 

 

Delete the settings tab or rename it so you have a copy

Refresh the sheet to load the new version. 

It will generate a new settings sheet, which you must update.

Its a work in progress, so still working on the UI, etc. Happy to hear any feedback. 


Meraki Employee

Re: Meraki Dashboard Reports with Google Sheets

Hello!

 

This has been added to the report!

 

Overwrite your Code.GS file with this one 

https://gist.github.com/dexterlabora/9884aa4399715df8f453ea9de63255a0

 

Delete or Rename your settings sheet

Refresh the Sheet window to load new script

Update the new settings sheet

Screen Shot 2018-08-30 at 5.43.57 PM.png

Conversationalist

Re: Meraki Dashboard Reports with Google Sheets

Love your work. Thanks!

Comes here often

Re: Meraki Dashboard Reports with Google Sheets

@DexterLaBora

 

I have a fairly large org and want to pull a client list. Can you give me some ideas how to overcome a the time out (settings tab?) and the 2,000,0000 limit in sheets? Is there a way for it to break the data up between sheets?

Meraki Employee

Re: Meraki Dashboard Reports with Google Sheets

Hi,

 

I have updated a few things with this script. It now has an Org-wide and Net-wide menu. This will allow for some large reports to be more focused, such as Clients.

 

Script: https://gist.github.com/dexterlabora/9884aa4399715df8f453ea9de63255a0
(replace your existing script with this one)


google sheets reports network-wide menu.png