Meraki Google Sheets Automation

Easily import Meraki Network data into Google Sheets using the Meraki Dashboard API.

Pre-Reqs

• Google Account
• Meraki API Key for personal use

Note: Meraki Sandbox API Key and IDs are present for ease of use.

Installation

Open the following Google Sheets

• Then MAKE A COPY of the file to your own account by selecting File -> Make a copy. This will allow the script to run and ensure your credentials are kept within your account.

• If using personal API Key update the settings tab on Google Sheet to start.

Create new sheet

• Then run the report “Organizations for API Key”. You will get a list of organizations and their IDs.
• Need to accept script with your gmail account

Import Meraki Data use API

Original Author

Meraki Developer Hub

Who to contact if you experience issues?

Ruben Dedman