07-06-2018 04:45 AM
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/
If you have cool ideas or feedback, let me know!
11-15-2021 04:11 AM
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"
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.
Hope this helps!
12-28-2023 05:34 PM
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?
01-02-2024 05:52 PM
Ah nevermind.
I've found that you created an extension instead.
03-05-2024 06:46 AM
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?
03-05-2024 09:19 AM
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.
03-06-2024 02:05 AM
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.
03-25-2024 01:16 PM
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?
07-09-2024 07:43 AM
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.
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide