usaussie Goto Github PK

appscript-batch-rename-google-drive-files

batch rename files in google drive, such as "Untitled Document" using the file's contents in the rename formula

appscript-bigquery-csv

Loading CSVs from Google Drive into BigQuery

appscript-bigquery-reporter

Appscript code to query and collect information about bigquery datasets/tables, and write the results back to BigQuery or Google Sheets

appscript-book-tracker

Apps Script to handle looking up Books via ISBN using the Google API, then storing details in a google sheet.

appscript-chat-rss

AppScript code to fetch RSS and post to Google Hangouts Chat

appscript-directory-to-sheets

Pull directory info about users from GSuite / Workspace and put results into Google Sheets

appscript-gmail-stats

Appscript to pull stats from gmail and store in a google sheet

appscript-gmail-to-chat-notifier

appscript-google-drive-folder-structure

This Apps Script is perfect for project managers, team leads, teachers or anyone who needs to set up a set of Google Drive folders and subfolders quickly and efficiently using automation instead of manual clicks.

appscript-google-drive-notifier

Appscript to check a google drive folder for contents, then send email notifications if files are found.

appscript-google-shared-drive-inventory

If you're a Google Workspace Super Admin, you've probably been thinking of ways to inventory and keep a handle on Google Shared Drives. They are a really great addition to the Workspace offering, but there are still some gaps in reporting & oversight that some people have wanted. This solution uses Google Apps Script and the Drive API to pull information about all the Shared Drives in a domain into a Google Sheet. Then, it uses the Drive API again to loop through all the drives and get the top-level permissions. Note, this does not traverse down into subfolders' permissions inside every shared drive. While this is entirely possible to script, the exponential size and scope of the data collected is too large to be effectively stored in a single Google Sheet (in my opinion). This solution is meant to solve two fairly basic questions: Who owns and has access to the Shared Drives in my domain? Can I perform an inventory on a schedule, so I can see how things change over time?

appscript-json-google-sheets

Loading JSON data into Google Sheets

appscript-multiple-bigquery-pipelines-google-sheet

Manage Multiple CSV to BigQuery Pipelines using a Google Sheet and Apps Script

appscript-twitter-data

Parse twitter data using apps script and google sheets into tabular format.

appscript-university-data

Appscript method to pull university data and store in Google Sheets

box-jwt-play-stuff

Temp repo for Box JWT stuff

box-powershell-sdk-v2

Windows PowerShell SDK for Box API v2.

docker-geoheatmap

Geoheatmap docker container

dockerized-gam

Docker container for running GAM (Google Apps Manager)

g_suite_metrics

google-api-php-client

A PHP client library for accessing Google APIs

google-calendar-aggregator

Appscript method to aggregate google calendar data into a google sheet for analysis & dashboarding in DataStudio

google-meet-attendance-tracker

google_drive_access_reporter

AppScript to audit a user's google drive content, and write details to a google sheet.

guilford-cip

The code and data standards for the Guilford County Community Indicators Project dashboard

guilfordcip

otframework

unccause2021-apps-script-samples

Apps Script samples for UNCCAUSE 2021 Presentation

workshops

xmatters_api_appscript

Appscript code to work with the xmatters REST API