appscript.dev

File management

Organise, audit, and back up Drive content. Generate, route, and clean up documents at scale.

Los artículos de este objetivo provienen de varios hubs de servicios e integraciones.

AI-powered workflows

Use Claude, Gemini, and other LLMs from Apps Script to classify, summarise, extract, and generate content.

7 artículos

External APIs

Call REST APIs, import third-party data, and send messages from Google Apps Script using UrlFetchApp.

4 artículos

Google Calendar automation

Create events from Sheets, sync calendars, and email weekly meeting summaries with Apps Script.

1 artículo

Google Docs automation

Generate documents from templates, batch-create invoices and contracts, and export Docs to PDF with Apps Script.

4 artículos

Google Drive automation

Organise, audit, and back up Google Drive files and folders at scale with Apps Script.

39 artículos

Automatización Intermedio Drive Sheets

Archive a project folder when it's marked done

Zip and shelve completed Northwind work — keep active folders focused on in-flight projects.

Actualizado 11 dic 2025

Automatización Intermedio Drive Sheets

Build a Drive search index in Sheets

Make Northwind's file metadata searchable in a Sheet — like Spotlight for Drive.

Actualizado 7 dic 2025

Automatización Intermedio Drive Sheets

Detect and report broken file shortcuts

Find Drive shortcuts in Northwind folders pointing at deleted or inaccessible files.

Actualizado 3 dic 2025

Automatización Intermedio Drive Sheets

Build a shared-folder onboarding kit

Auto-grant new Northwind hires the folders they need on day one.

Actualizado 29 nov 2025

Automatización Intermedio Drive Gmail

Route saved email attachments to project folders

File Gmail attachments into the right Northwind client folder based on subject keywords.

Actualizado 25 nov 2025

Automatización Avanzado Drive Sheets

Build a Drive cleanup recommendation report

Suggest what Northwind can delete or archive — large, stale, duplicate, or untouched files.

Actualizado 21 nov 2025

Automatización Avanzado Drive

Bundle a folder of images into one PDF

Combine Northwind scans into a single deliverable PDF using a generation service.

Actualizado 17 nov 2025

Automatización Intermedio Drive Docs

Keep a self-updating contents file per folder

Auto-create a `_contents.md` Doc inside every Northwind folder, refreshed nightly.

Actualizado 13 nov 2025

Automatización Avanzado Drive Sheets Gmail

Build a digital-asset request and approval flow

Route Northwind asset requests through Drive — request, review, approve, deliver.

Actualizado 9 nov 2025

Automatización Intermedio Drive Sheets

Generate a folder-level changelog

Track additions and deletions in a Northwind folder over time — a written history.

Actualizado 5 nov 2025

Automatización Intermedio Drive Sheets

Auto-publish approved files to a public folder

Promote Northwind files once a status flips — from `drafts/` to `published/` automatically.

Actualizado 1 nov 2025

Automatización Intermedio Drive Sheets

Download and file documents from a link sheet

Pull referenced files from URLs in a Sheet into Northwind's Drive automatically.

Actualizado 24 oct 2025

Automatización Intermedio Drive Sheets

Enforce file naming and tagging governance

Flag Northwind files that don't match required naming or tagging conventions.

Actualizado 16 oct 2025

Automatización Principiante Drive Docs

Visualize a deep folder hierarchy

Generate a sitemap-style outline of Northwind's nested folders into a Doc.

Actualizado 12 oct 2025

Automatización Avanzado Drive

Build a shared-drive migration helper

Move Northwind files between drives with structure intact — from My Drive to a Shared Drive.

Actualizado 8 oct 2025

Automatización Intermedio Drive

OCR scanned documents into searchable text

Extract text from image-based PDFs in Drive — Drive's free OCR on conversion to Docs.

Actualizado 4 oct 2025

Automatización Avanzado Drive

Split a multi-page PDF into separate files

Break a scanned Northwind batch into individual docs — one PDF per page.

Actualizado 30 sept 2025

Automatización Avanzado Drive

Merge many PDFs from a folder into one

Combine PDFs in a Northwind folder into a single deliverable — for client handovers.

Actualizado 26 sept 2025

Automatización Intermedio Drive

Build a version-snapshot system for key files

Keep dated copies of Northwind's critical Sheets before risky edits.

Actualizado 22 sept 2025

Automatización Intermedio Drive Sheets

Apply folder-based permission rules to uploads

Auto-share new files in Northwind project folders with the right team.

Actualizado 18 sept 2025

Automatización Intermedio Drive

Bulk-restore accidentally trashed files

Recover everything trashed in a date range — Northwind's emergency-undo button.

Actualizado 14 sept 2025

Automatización Avanzado Drive

Auto-watermark PDFs in a folder

Stamp Northwind documents with a confidentiality watermark before they're shared.

Actualizado 6 sept 2025

Automatización Principiante Drive

Pre-create dated archive folders

Generate per-month folders ahead of time so nothing lands in `misc/`.

Actualizado 2 sept 2025

Automatización Avanzado Drive

Build a document-retention policy enforcer

Delete Northwind files past their retention date — keep finance, drop drafts.

Actualizado 29 ago 2025

Ver los 39 en Google Drive automation →

Google Forms automation

Notify, route, and post-process Google Forms responses automatically with Apps Script.

2 artículos

Email & Gmail automation

Automate inbox triage, mail merges, scheduled reports, and attachment handling with Gmail and Google Apps Script.

12 artículos

Automatización Principiante Gmail

Auto-forward receipts to your accountant

Route anything that looks like a receipt to a fixed address on a monthly schedule.

Actualizado 16 jun 2026

Automatización Intermedio Gmail Drive

Auto-file quotes and proposals you receive

Detect inbound proposal PDFs and store them in Drive by client.

Actualizado 13 jun 2026

Automatización Intermedio Gmail Drive

Forward attachments to Drive and reply with the link

Strip large attachments out of incoming threads, save them to Drive, and reply with the link.

Actualizado 9 jun 2026

Automatización Intermedio Gmail Docs

Convert long email threads into a summary note

Collapse a thread's history into a Doc for handover — perfect for client transitions or vacation cover.

Actualizado 6 jun 2026

Automatización Intermedio Docs Drive

Generate a printable address book from contacts

Export Northwind's Google Contacts to a formatted Doc you can actually print.

Actualizado 21 abr 2026

Automatización Avanzado Gmail

De-duplicate and merge your Gmail contacts

Find near-duplicate contacts in Google Contacts and consolidate them into one canonical record.

Actualizado 10 feb 2026

Automatización Avanzado Gmail

Bulk-unsubscribe from senders you never open

Score senders by open rate over 90 days and stage unsubscribe actions for the worst offenders.

Actualizado 2 dic 2025

Automatización Intermedio Gmail Sheets

Detect bounced emails and clean your list

Read delivery-failure notices in your inbox and mark dead addresses on the Subscribers sheet.

Actualizado 25 nov 2025

Automatización Principiante Gmail

Auto-archive threads once you've replied

Keep only conversations awaiting a response visible in the inbox by archiving threads where you spoke last.

Actualizado 28 oct 2025

Automatización Principiante Gmail Sheets

Auto-categorize emails by project keyword

Apply Gmail labels from a keyword map stored in a Sheet, so every email lands under the right project tag.

Actualizado 14 oct 2025

Automatización Principiante Gmail

Archive newsletters automatically after seven days

Sweep read promotional mail on a daily schedule to keep the inbox clean.

Actualizado 23 sept 2025

Automatización Intermedio Gmail

Auto-label incoming invoices by sender and amount

Parse the body of incoming invoice emails, tag the thread, and route it to a finance label.

Actualizado 9 sept 2025

Google Sheets automation

Automate data entry, formatting, custom functions, and dashboards in Google Sheets with Apps Script.

10 artículos

Automatización Intermedio Sheets

Build a multi-sheet search-and-jump tool

Find a value across every tab of a workbook and click through to the cell that contains it.

Actualizado 7 ene 2026

Automatización Intermedio Sheets Drive

Auto-import every CSV dropped in a folder

Append new vendor CSV exports into a master sheet automatically — drop the file, walk away.

Actualizado 10 dic 2025

Automatización Avanzado Sheets

Build a two-way sync between two spreadsheets

Keep a shared client-facing sheet and a private internal sheet in step — both directions.

Actualizado 1 nov 2025

Automatización Principiante Sheets

Auto-archive completed rows to a Done sheet

Move finished tasks out of the active Projects view and into a Done archive on a schedule.

Actualizado 25 oct 2025

Automatización Intermedio Sheets Drive

Split a master sheet into per-owner sheets

Generate a filtered copy for each team member from the master Tasks sheet.

Actualizado 15 oct 2025

Automatización Intermedio Sheets Drive

Restore a sheet to any previous snapshot

Keep dated backups of the Pipeline sheet and roll back to any of them with one function call.

Actualizado 11 oct 2025

Automatización Principiante Sheets

Auto-generate a clickable workbook index

Build a Contents tab linking to every sheet in a workbook — refreshed when tabs are added.

Actualizado 1 oct 2025

Automatización Intermedio Sheets

Auto-snapshot a sheet to a dated archive tab

Freeze month-end values before formulas recalculate — keep a permanent record of what they were.

Actualizado 27 sept 2025

Automatización Avanzado Sheets

Build a self-cleaning data import pipeline

Pull, dedupe, and normalise external data on every refresh — no manual cleanup required.

Actualizado 20 sept 2025

Automatización Principiante Sheets

Mask sensitive columns for shareable copies

Redact PII with a custom function so you can share a copy of the sheet without exposing names, emails, or numbers.

Actualizado 26 jul 2025

Google Slides automation

Generate decks from spreadsheets, batch-export slide content, and personalise presentations with Apps Script.

3 artículos

Web apps & deployment

Build webhooks, internal tools, and tiny web services with Apps Script deployed as a web app.

2 artículos