Google-Apps-Scripts

KO | EN

gitlite — search

#javascript #python #hacktoberfest #react #golang #android #machine-learning #deep-learning #awesome #awesome-list #pytorch #mcp #ios #open-source

Google-Apps-Scripts

(★ 1)

20 ready‑to‑paste Google Apps Script snippets for Google Sheets. Note: a project can only have one simple trigger named onEdit(e) / onOpen(e). If you want to use multiple edit/open handlers, rename them (e.g., onEditTimestamp) and create installable triggers for each, or merge their logic.

Google-Apps-Scripts Latest Version Download

Download Latest Version (.zip)

// repository documentation

Was this content helpful?

★ 0 (0 ratings)

# Google Apps Scripts

A curated collection of custom **Google Apps Script (GAS)** utilities and automation workflows designed to seamlessly integrate, enhance, and automate tasks across the Google Workspace ecosystem (Google Sheets, Gmail, Google Drive, and Google Calendar).

---

## 🚀 Overview

Google Apps Script is a rapid application development platform that makes it fast and easy to create business applications that integrate with Google Workspace. This repository serves as a centralized hub for custom scripts that eliminate repetitive manual tasks, bridge gaps between different Google services, and extend the native functionality of Google apps.

---

## 📂 Repository Contents

While the specific scripts may evolve over time, this repository generally houses modules for:

* **Google Sheets Automation:** Custom macros, complex data formatting, automatic row processing, and specialized custom functions (`=CUSTOM_FORMULA()`) built in JavaScript.
* **Gmail Integrations:** Scripts to automatically parse incoming emails, extract specific attachments, or trigger spreadsheet logging based on label/filter criteria.
* **Google Drive Management:** Batch folder creation, automated file organization, and bulk permission/sharing updates.
* **Google Calendar Sync:** Dynamic event creation or modification pulled directly from spreadsheet rows and tracking data.

---

## 🛠️ How to Use These Scripts

1. **Open Google Apps Script Editor:**
   * From any Google Sheet, Doc, or Form, click on **Extensions > Apps Script**.
   * Alternatively, go to [script.google.com](https://script.google.com/) to create a standalone script.
2. **Copy the Code:**
   * Select the desired `.gs` (Google Script) file from this repository and copy its contents.
3. **Paste & Save:**
   * Paste the code into the `Code.gs` file in your Google Apps Script editor. 
   * Click the **Save** icon (or press `Ctrl+S` / `Cmd+S`).
4. **Authorize Permissions:**
   * Click **Run** on the function you wish to execute. 
   * Google will prompt you to review and grant the necessary permissions for the script to access your Workspace data.
5. **Set up Triggers (Optional):**
   * Click the **Clock icon** (Triggers) in the left-hand menu to automate the script (e.g., run daily, on-edit, or on-form-submit).

---

## 👨‍💻 Author & Credits

* **Developer:** Erick Villeta
* **Website:** [https://ericksonvilleta.com](https://ericksonvilleta.com)

## 📄 License

This repository is licensed under the **MIT License**. Feel free to use, modify, and distribute these scripts in your own personal or commercial Google Workspace environments.

Google-Apps-Scripts

Google-Apps-Scripts Latest Version Download

Today's picks

Was this content helpful?

Recent Feedback

Google-Apps-Scripts

Google-Apps-Scripts Latest Version Download

Today's picks

Was this content helpful?

Recent Feedback

Download README