cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
30195
Views
18
Helpful
22
Replies

Meraki Dashboard Reports with Google Sheets

DexterLabora
Cisco Employee
Cisco Employee

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!

22 Replies 22

If you want the script launch the menu when you open the Google Sheet, just add a Trigger.

Do this in the Script editor section.

Select the "onOpen" function to run for the event type "On open"

image.png

You could also create macros that will run a specific function and insert the data on scheduled basis.

create a new file called macros.gs and then add this code

// example function I want to run via macro
function DeviceUplinkDetails() {
  var spreadsheet = SpreadsheetApp.getActive();
  spreadsheet.getRange('A2').activate();
  callUplinkInfos();
};

Then create a new trigger for this that calls the function on a schedule.

image.png

Hope this helps!

wellyhartanto
Level 3
Level 3

Hi @DexterLabora

I just stumbled upon your amazing work, and after looking at the code, it is still using API v0.

Any chance that you have updated this to the latest v1?

Ah nevermind.

I've found that you created an extension instead.

BDillon1
Level 1
Level 1

Afternoon;
Could this be setup to interrogate and report back on Meraki MT10 Sensors?
E.g. Name, Latest Readings for Temp,Humidity and Battery life?

Yes, you can achieve this by combining the organizations > Organization Devices (set device model as mt10)and sensor > Organization Sensor Readings Latest calls (with the targeted devices selected)

The reason you will need the Organization Devices is in the sensor reading returns there is no device names but serial numbers.

Nice one - thanks
Its going to take a little more investigation then. I'm not very clued up on JSON scripting etc at the moment. This gives me something to work with though.

jagan.chowdam
VIP Alumni
VIP Alumni

While running "Organization Wireless Devices Ethernet Statuses" report for an Organization with more than 4000 APs, what should be the Optional "Per Page" and "Pages" settings?

BDillon1
Level 1
Level 1

I have now created another work around for my issue - collecting MT Sensor information.
Using POSTMAN and API GET queries.

This was a great place to start however.