Working with the Zscaler API from Google Sheets Scripts

Secure Internet Access (ZIA)
1

Hi,

Before I head down a rabbit hole of APIs within Google Scripts I wanted to see if anyone else has worked with the Zscaler API via Google Sheets.

Some Background:

I am working in Google Data Studio to aggregate traffic across all our Zscaler portals. Currently, I use a GCP VM to query the data I need from the Zscaler API and store this in a CSV. This CSV is then uploaded to my Google Drive to update a Google Sheet file. This Google Sheet is linked to a Data Studio report to make things look all pretty. It’s not elegant, but does the job.

Question:

Can the Zscaler API be worked with directly from Google Sheets Scripts and has anyone actually done this? (Hopefully with the code examples! :slight_smile: )

Many thanks!

Andrew.

2

Update: I worked out a way to work with Google Drive OAUTH and some Python to streamline the Google Sheet process and automate the upload part.

3

This topic was automatically closed 5 days after the last reply. New replies are no longer allowed.