awesome-appscript

KO | EN

gitlite — search

#javascript #python #ai #llm #go #machine-learning #macos #nodejs #java #windows #awesome #pytorch #security #ios

awesome-appscript

(★ 33)

A collection of awesome Apps Script Functions, resources and shiny things.

awesome-appscript 최신버젼 다운로드

최종 버전 다운로드 (.zip)

// repository documentation

Was this content helpful?

★ 0 (0 ratings)

Awesome Google Apps Script
==========================

[![Awesome](https://awesome.re/badge.svg)](https://github.com/Flozad/Awsome-Appscript)

A curated list of resources for Google Apps Script, a scripting language based on JavaScript that lets you automate tasks and extend Google Workspace.

# Comprehensive Google Apps Script List

- [1. Resources](#1-resources)
  - [1.1. Useful Sites & Blogs](#11-useful-sites--blogs)
  - [1.2. Awesome Code & Things](#12-awesome-code--things)
  - [1.3. Lists & Collections](#13-lists--collections)
- [2. Development](#2-development)
  - [2.1. Starter Kits](#21-starter-kits)
  - [2.2. Shims and Polyfills](#22-shims-and-polyfills)
- [3. Libraries & Modules](#3-libraries--modules)
  - [3.1. Using Databases](#31-using-databases)
  - [3.2. ORM (O/RM and O/R Mapping Tool)](#32-orm-orm-and-or-mapping-tool)
  - [3.3. Utility](#33-utility)
  - [3.4. Parsing](#34-parsing)
  - [3.5. oAuth](#35-oauth)
  - [3.6. Images & Pictures](#36-images--pictures)
  - [3.7. Data Studio Community Connectors](#37-data-studio-community-connectors)
  - [3.8. Pack Modules and Universal Libraries](#38-pack-modules-and-universal-libraries)
- [4. Open Source Apps & Add-ons](#4-open-source-apps--add-ons)
- [5. Testing](#5-testing)
- [6. Logging](#6-logging)
- [7. Snippets and Assorted](#7-snippets-and-assorted)
  - [7.1. Snippets](#71-snippets)
    - [7.1.1. Collections](#711-collections)
    - [7.1.2. Spreadsheets](#712-spreadsheets)
    - [7.1.3. XML](#713-xml)
  - [7.2. Assorted](#72-assorted)

## 1. Resources
### A compilation of helpful resources for Google Apps Script users, including communities, blogs, and collections.

### 1.1. Useful Sites & Blogs
- [Digital Inspiration](https://www.labnol.org/topic/google-apps-script) Amit Agarwal's site
- [mashe.hawksey.info](https://mashe.hawksey.info/category/google/google-apps-script) Martin Hawksey's site
- [ramblings.mcpher.com](http://ramblings.mcpher.com/) Desktop Liberation - the definitive resource for Google Apps Script and Microsoft Office automation
- [googleappscripting.com](http://googleappscripting.com) Google Apps Script Tutorials and Examples • Making Google Apps Script Accessible to Everybody
- [scriptsexamples](https://sites.google.com/site/scriptsexamples/custom-methods) A set of code samples and libraries to foster programming in Google AppsScript to be easy
- [tanaikech.github.io](https://tanaikech.github.io/tags/google-apps-script/) The `Google Apps Script` tag of the Kanshi's blog
- [andrewroberts.net](http://www.andrewroberts.net) The Andrew Roberts's site
- [kutil.org](http://www.kutil.org/search/label/google%20apps%20script) The `google apps script` tag of Ivan Kutil's blog
- [googleappsscript.org](http://www.googleappsscript.org/) Google Apps Script Tutorial
- [scriptingwithshiva.blogspot.com](https://scriptingwithshiva.blogspot.com/) Scripting With Shiva It will help those wants to start Google Apps script Development from scratch
- [benlcollins.com](https://www.benlcollins.com/) Ben Collins's site
- [pulse.appsscript.info](https://pulse.appsscript.info/) User contributed tutorials and news

#### (Additional links from your list will also be included here)

### 1.2. Awesome Code & Things
- [Making a virtual machine in Google Sheets](http://briansteffens.com/2017/07/03/google-sheets-virtual-machine.html) Register of Apps Script consultants
- [Easy data scraping with Google Apps Script in 5 minutes](http://www.kutil.org/2016/01/easy-data-scrapping-with-google-apps.html)
- [Send SMS with Google Sheets and your Android Phone](https://www.labnol.org/send-sms-google-sheets-200402)

#### (Additional links from your list will also be included here)

### 1.3. Lists & Collections
- [Apps Script consultants](https://docs.google.com/presentation/d/1U1y6Vjf5ClEof15JLw4qg7tpjpo4MHk7uhVKpjVkA9M/edit?usp=sharing)
- [Learning Google Apps Script](https://gist.github.com/labnol/0b67f812a827fd9babc5) The best resources for learning Google Apps Script, the glue that connects GSuite services including Gmail, Google Drive, Calendar, Maps, Analytics and more
- [Google Apps Script Cheat Sheet](https://github.com/jychri/google-apps-script-cheat-sheet)
- [Andrew Roberts' Scripts and Snippets](http://www.andrewroberts.net/scripts-and-snippets/)

#### (Additional links from your list will also be included here)

## 2. Development
### Tools, extensions, and resources to aid in the development of Google Apps Script projects.

### 2.1. Starter Kits
- [ez-clasp](https://github.com/cristobalgvera/ez-clasp) A starter kit for building Google Apps Script projects with TypeScript, ESLint, Prettier, Jest and Rollup support out of the box.
- [apps-script-starter](https://github.com/labnol/apps-script-starter) A starter kit for building Google Apps Script projects with modern JavaScript ES6, Webpack, Babel and ESLint inside Visual Studio Code

#### (Additional links from your list will also be included here)

### 2.2. Shims and Polyfills
- [Using Es6 with Apps Script](https://ramblings.mcpher.com/gassnippets2/using-es6-with-apps-script)

#### (Additional links from your list will also be included here)

## 3. Libraries & Modules
### An extensive list of libraries and modules to enhance and extend the functionality of Google Apps Script.

### 3.1. Using Databases
- [FirebaseApp](https://github.com/RomainVialard/FirebaseApp) The Google Apps Script binding for the Firebase Realtime Database
- [oshliaer/alasqlgs](https://github.com/oshliaer/alasqlgs) AlaSQLGS is a library that enables the use of the AlaSQL.js library in Google Apps Script

#### (Additional links from your list will also be included here)

### 3.2. ORM (O/RM and O/R Mapping Tool)
- [Goodel](https://github.com/7imon7ays/Goodel) An ORM for Google Apps scripts
- [gs-spreadsheet-manager](https://github.com/jsoma/gs-spreadsheet-manager) A slightly more object-oriented, ORM-y, and altogether pleasant way of dealing with Google Spreadsheets when using Google Apps Script

#### (Additional links from your list will also be included here)

### 3.3. Utility
- [gas-underscore](https://github.com/simula-innovation/gas-underscore) Underscore for Google Apps Script
- [lodashgs](https://github.com/oshliaer/lodashgs) Lodash for Google Apps Script is a library that enables the use of the lodash.js library in Google Apps Script

#### (Additional links from your list will also be included here)

### 3.4. Parsing
- [Apps-Script-htmlparser2-library](https://github.com/Spencer-Easton/Apps-Script-htmlparser2-library) A browserified version of fb55/htmlparser2 modified to work in Google Apps Script
- [cheeriogs](https://github.com/tani/cheeriogs) HTML manipulation library with jQuery-like interface

#### (Additional links from your list will also be included here)

### 3.5. oAuth
- [apps-script-oauth1](https://github.com/gsuitedevs/apps-script-oauth1) An OAuth1 library for Google Apps Script
- [apps-script-oauth2](https://github.com/gsuitedevs/apps-script-oauth2) An OAuth2 library for Google Apps Script

#### (Additional links from your list will also be included here)

### 3.6. Images & Pictures
- [ImgApp](https://github.com/tanaikech/ImgApp) This is a library of image tools for Google Apps Script
- [GPhotosApp](https://github.com/sudtanj/gas-GPhotosApp) This is a Google Photos REST API library for Google Apps scripts

#### (Additional links from your list will also be included here)

### 3.7. Data Studio Community Connectors
- [googledatastudio/community-connectors](https://github.com/googledatastudio/community-connectors) This repository contains open source content for Google Data Studio

#### (Additional links from your list will also be included here)

### 3.8. Pack Modules and Universal Libraries
- [classroomtechtools/modularLibraries](https://github.com/classroomtechtools/modularLibraries.gs) A collection of importable, modular libraries for any Google Apps Script project

#### (Additional links from your list will also be included here)

## 4. Open Source Apps & Add-ons
### A selection of open-source applications and add-ons built using Google Apps Script, serving various purposes.

- [google-docs-add-on](https://github.com/Automattic/google-docs-add-on) Publish to WordPress from Google Docs
- [email-studio-gmail-addon](https://github.com/labnol/email-studio-gmail-addon) Gmail add-on for Mail Merge and Email Scheduler

#### (Additional links from your list will also be included here)

## 5. Testing
### Frameworks and tools to facilitate testing and quality assurance in Google Apps Script development.

- [huan/gast](https://github.com/huan/gast) Google Apps Script TAP Testing-framework
- [GSUnit](https://sites.google.com/site/scriptsexamples/custom-methods/gsunit) is a Google Apps Script based testing framework based on JUnit by Kent Beck and JSUnit by Edward Hieatt.

#### (Additional links from your list will also be included here)

## 6. Logging
### Libraries and tools for implementing advanced logging capabilities in Google Apps Script projects.

- [huan/gasl](https://github.com/huan/gasl) Google Apps Script Logging-framework
- [BetterLog](https://github.com/peterherrmann/BetterLog) Logging library that extends the native apps script Logger, mainly to allow logging to a GSheet

#### (Additional links from your list will also be included here)

## 7. Snippets and Assorted
### A mixture of useful code snippets and assorted resources for Google Apps Script developers.

### 7.1. Snippets
#### Useful code snippets covering various aspects of Google Apps Script, including spreadsheets, XML, and more.

#### 7.1.1. Collections
- [Google Apps Script snippets ᕦʕ •ᴥ•ʔᕤ](https://apps-script-snippets.contributor.pw/)
- [Collection of Apps Scripts for connecting to APIs](https://github.com/benlcollins/apps_script_apis)

#### 7.1.2. Spreadsheets
- [[Apps Script] Getting the unmerged ranges within a range](https://gist.github.com/erickoledadevrel/6fa9b256f41b5d7646ba6ed37e0f8018)
- [Google Apps Script to fill in a Document template with Spreadsheet data](https://gist.github.com/mhawksey/1170597)

#### 7.1.3. XML
- [xmlToJson](https://gist.github.com/erickoledadevrel/6b1e9e2796e3c21f669f) A function to convert an XML string to a JSON object in Apps Script, using logic similar to the sunset method Xml.parse()

### 7.2. Assorted
- [GoogleSheets](https://github.com/Max-Makhrov/GoogleSheets) best code I've tested in Google Sheets
- [google-docs](https://github.com/fastfedora/google-docs) Libraries and functions used within Google Docs

#### (Additional links from your list will also be included here)

[goto top ⇑](#comprehensive-google-apps-script-list)

awesome-appscript

awesome-appscript 최신버젼 다운로드

오늘의 추천 프로젝트

Was this content helpful?

Recent Feedback

awesome-appscript

awesome-appscript 최신버젼 다운로드

오늘의 추천 프로젝트

Was this content helpful?

Recent Feedback

Download README