topic Re: Meraki Tools for Google Sheets add-on in Network Platform API

Meraki Tools for Google Sheets add-on

DexterLabora — Mon, 24 Jun 2019 14:04:34 GMT

Hi All,

I’ve published a beta version of my Meraki Tools for Google Sheets add-on.

http://cs.co/meraki_tools

This app started out as a proof of concept to test Meraki APIs and the new SDKs, but quickly became a super powerful tool. I've polished it up and would like to share it with everybody.

Features

Over 100 Meraki reports
Reports are dynamically generated by the latest Meraki Open API Specification
Dynamic form selectors using Node SDK
A few common tools to make changes to your network.
Improved UI
Looper! - custom widget to loop through many orgs/nets/serials for a given report. This solves so many custom report requirements.

Please let me know how it works out. If you already had it installed, it should just update automatically.
Once it's been tested for a bit, I will go through the admin of listing it properly on the Google Marketplace so that its easily discoverable.

FYI, here is the repo, which is still being cleaned up. The application was written with Vue.js and a bunch of clever tricks to shove it in a Google Add-on sidebar.

Enjoy!

Re: Meraki Tools for Google Sheets add-on

kYutobi — Mon, 24 Jun 2019 14:34:06 GMT

Nice addon 🙂

Re: Meraki Tools for Google Sheets add-on

SoCalRacer — Mon, 24 Jun 2019 15:22:13 GMT

@DexterLabora

Looks awesome! Can't wait to try it out later today.

On a side note any idea if the Meraki Alexa skill will ever be migrated to Google Assistant?

Re: Meraki Tools for Google Sheets add-on

PacJ — Tue, 23 Jul 2019 14:59:58 GMT

Hello,

Is there any work around for the "Sign in with Google temporarily disabled for this app This app has not been verified yet by Google in order to use Google Sign In". I am still unable to bypass.

Thanks!

Re: Meraki Tools for Google Sheets add-on

DexterLabora — Tue, 23 Jul 2019 15:46:51 GMT

Hi @PacJ , I still need to do a laundry list of tasks to get the app verified by Google.
FYI, for internal Meraki employees, this message does not happen but I decided to release it publicly in its current state, because it's a really useful reporting tool.

That being said, you should just click on the links to force the app install. Just click on the "Advanced" link and then "Got to Meraki tools"

Re: Meraki Tools for Google Sheets add-on

PacJ — Tue, 23 Jul 2019 16:10:57 GMT

Thanks for the quick response. It does appear this tool would be very useful for us.

I have been trying to install the tool for weeks before I saw you uploaded this as an add-on.

Appreciate the feedback and the tools. The Meraki API Express Server is great.

For some reason I do not get the advanced option for this add on, but I do on others. Anyway I'll keep trying and see if I can get through.

PS. Have you seen this error " VUE_APP_SERVICE' is not recognized as an internal or external command, operable program or batch file" when running the local server?

Re: Meraki Tools for Google Sheets add-on

DexterLabora — Tue, 23 Jul 2019 21:29:13 GMT

@PacJ
Odd that you can't scroll down to see the link. It wasn't on the landing page, but if I just scrolled a bit I could navigate.

Regarding your local server question, I have updated the Readme doc with more dev instructions.

https://github.com/dexterlabora/meraki-tools-gas-vue-webpack

Basically, you are getting that message because you have not pulled in the packages for the project.

While in the project directory simply type yarn to pull everything in.

$ yarn

That being said, there will be a few more steps if you plan on using the dev version.

- install clasp (Google utility to push script files into their system)
- create an new Gsheet and attach a blank script, noting its Project ID

- update your .clasp.json file with the new scriptId

- run yarn deploy to push the app to Google.

- Now, in the Google Script editor, click on Run --> Run function --> onInstall

The "Meraki Tools" will appear directly in the toolbar of your Google Sheet.

Hope this helps. If you totally get stuck, there might be a way to forklift the built code as well.

Re: Meraki Tools for Google Sheets add-on

PacJ — Wed, 24 Jul 2019 16:46:03 GMT

Thanks, one last question : ) When I run yarn I get the following error.

[2/4] Fetching packages...
error An unexpected error occurred: "https://registry.yarnpkg.com/websocket-driver/-/websocket-driver-0.7.2.tgz: Request failed \"404 Not Found\""

Any idea?

Re: Meraki Tools for Google Sheets add-on

DexterLabora — Wed, 24 Jul 2019 20:34:45 GMT

Delete the yarn.lock file and the run yarn again. Should fix it.

I'll update the repo and fix a few things while I'm in their. Vuitify just updated their version and it broke some of the styling.

Re: Meraki Tools for Google Sheets add-on

Shockey74 — Mon, 12 Aug 2019 19:06:51 GMT

This works great with pulling site-2-site rules but I'm wondering is there a way to use the API to push the rules back to Meraki after making a change in the sheet? thanks!

Re: Meraki Tools for Google Sheets add-on

DillonWhite9048 — Thu, 15 Aug 2019 00:52:37 GMT

@DexterLabora Just an FYI that this app won't work for accounts that are part of Google Advanced Protection Program. Sadly as a Super admin for my organization that won't change!

Helppppppppp! This was the best way of reporting without any code workkkkkk

Please?

Re: Meraki Tools for Google Sheets add-on

Jon Hurd — Sat, 17 Aug 2019 12:59:56 GMT

getting same issue:

This app has not been verified yet by Google in order to use Google Sign In.

Re: Meraki Tools for Google Sheets add-on

SoCalRacer — Mon, 19 Aug 2019 15:45:34 GMT

Didn't this tool used to have an option to pull from all Orgs or all Networks within an Org? Is that something that was removed?

Re: Meraki Tools for Google Sheets add-on

DexterLabora — Mon, 19 Aug 2019 21:08:04 GMT

@SoCalRacer , The reports are now all automatically generated from the Meraki OpenAPI spec. Meaning, there are no custom "scoped reports". Instead.... use the "Looper" widget in the report section to iterate over multiple organizations, networks or devices, depending on the report.

Re: Meraki Tools for Google Sheets add-on

Roux — Wed, 20 Nov 2019 21:12:52 GMT

@DexterLabora Awesome work! I been leveraging the API's in Powershell. It is great for automation and weekly reports, but not for searching real-time data.

Re: Meraki Tools for Google Sheets add-on

DexterLabora — Mon, 16 Nov 2020 09:03:35 GMT

Meraki Tools is now Google Verified !

What does this mean?

Anybody can now install this free Meraki utility to instantly generate reports with Google Sheets.

- No coding required -

Download: https://cs.co/meraki_tools

Docs

Updates:

- Refactored for Dashboard API v1

- Added advanced JSON filtering

- OpenAPI explorer for the Meraki API (like a mini embedded Postman)

- Lots of UI improvements

- note: I removed the legacy sample tools like provision a client, since they relied on the old v0 SDK.

Re: Meraki Tools for Google Sheets add-on

hjiang123 — Tue, 13 Jul 2021 08:35:23 GMT

Hi, the link to G sheets add-on 404'ed for me. I think link is dead? Can you please repost?

Re: Meraki Tools for Google Sheets add-on

A.R.M — Fri, 07 Mar 2025 04:21:05 GMT

Is it working still? I can't open the link

Re: Meraki Tools for Google Sheets add-on

DexterLabora — Fri, 07 Mar 2025 09:31:30 GMT

Here is the direct link to the Google Marketplace listing
https://workspace.google.com/marketplace/app/meraki_tools/11340767263

Re: Meraki Tools for Google Sheets add-on

A.R.M — Tue, 11 Mar 2025 02:21:19 GMT

Great, many thanks!