appscript.dev

Approval workflows

Multi-step approvals, sign-offs, and routing flows built on Forms, Sheets, and Gmail.

Articles in this goal come from multiple service and integration hubs.

AI-powered workflows

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

11 articles

Automation Advanced

Build a multi-step AI agent workflow

Chain Claude prompts to complete a Northwind task end to end — research → draft → critique → finalise.

Updated Feb 11, 2026

Automation Intermediate Docs Sheets

Auto-write CRM notes from call summaries

Generate Northwind account updates after each client call — pulled from the transcript.

Updated Jan 26, 2026

Automation Intermediate Sheets

Build an AI bug-triage system

Categorise and prioritise Northwind's reported issues automatically — type, severity, owner.

Updated Jan 22, 2026

Automation Intermediate Docs Sheets

Extract follow-ups from call transcripts

Turn Northwind sales calls into actionable tasks — owner + task + due date per extracted item.

Updated Jan 10, 2026

Automation Advanced Docs

Build a contract-clause risk analyzer

Flag risky terms in Northwind contract text — auto-renewal, exclusivity, broad IP grants.

Updated Nov 7, 2025

Automation Intermediate Gmail

Predict email intent and route it

Classify inbound Northwind mail and apply the right Gmail label automatically.

Updated Oct 22, 2025

Automation Intermediate Sheets

Build a content-moderation filter

Flag unsafe or off-topic Northwind user submissions before they reach the team.

Updated Aug 23, 2025

Automation Advanced Drive Sheets

Build an AI resume screener

Score and summarise Northwind applicants against a role spec, into a hiring sheet.

Updated Aug 15, 2025

Automation Intermediate Docs Sheets

Turn meeting notes into assigned action items

Extract tasks and owners from Northwind meeting transcripts into the Tasks sheet.

Updated Aug 7, 2025

Automation Intermediate Gmail

Auto-draft email replies with AI

Stage contextual draft replies in Gmail for every incoming Northwind support thread.

Updated Jul 18, 2025

Automation Intermediate Sheets Gmail

Score support tickets for urgency with AI

Triage incoming Northwind support tickets by predicted priority — high, normal, low.

Updated Jul 6, 2025

External APIs

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

8 articles

Google Calendar automation

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

9 articles

Automation Advanced Calendar

Auto-reschedule low-priority conflicts

Move flexible Northwind events around fixed ones — focus blocks bend, client calls don't.

Updated Oct 16, 2025

Automation Intermediate Calendar Sheets

Apply attendee rules by event type

Auto-invite the right Northwind people from a Sheet — design reviews get design, client calls get account leads.

Updated Oct 4, 2025

Automation Advanced Calendar Sheets

Build a shift-rota scheduler

Assign and rotate Northwind support shifts from a Sheet — fair distribution, week to week.

Updated Aug 29, 2025

Automation Intermediate Calendar Forms

Create events from appointment-form submissions

Book slots from a Google Form into the Northwind appointments calendar automatically.

Updated Aug 13, 2025

Automation Intermediate Calendar Sheets

Schedule content as a publishing calendar

Drive a Northwind content plan from calendar events — title, channel, status.

Updated Aug 9, 2025

Automation Advanced Calendar Sheets Gmail

Build an interview-scheduling coordinator

Slot Northwind candidates into available interview windows from a Sheet of preferences.

Updated Jul 28, 2025

Automation Intermediate Calendar

Auto-decline meetings outside working hours

Protect Northwind schedules — decline invites that land outside 9-6 London time.

Updated Jul 20, 2025

Automation Intermediate Calendar Sheets

Build a room and resource booking system

Manage shared spaces in the Northwind studio through a Sheet — book by adding a row.

Updated Jul 12, 2025

Automation Intermediate Calendar

Auto-block focus time around meetings

Reserve prep and recovery slots automatically around every Northwind meeting.

Updated Jun 30, 2025

Google Docs automation

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

4 articles

Google Drive automation

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

9 articles

Automation Intermediate Drive Sheets

Build a recurring file-delivery system

Drop a fresh report file into a Northwind client folder weekly — they don't even ask.

Updated Dec 15, 2025

Automation Intermediate 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.

Updated Dec 11, 2025

Automation Intermediate Drive Sheets

Build a shared-folder onboarding kit

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

Updated Nov 29, 2025

Automation Advanced Drive Sheets Gmail

Build a digital-asset request and approval flow

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

Updated Nov 9, 2025

Automation Intermediate Drive Sheets

Auto-publish approved files to a public folder

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

Updated Nov 1, 2025

Automation Intermediate Drive Sheets

Apply folder-based permission rules to uploads

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

Updated Sep 18, 2025

Automation Advanced Drive

Build an external file-request intake system

Collect uploads from outside people into a Northwind intake folder via a web app.

Updated Aug 17, 2025

Automation Advanced Drive Sheets

Build a watched-folder processing pipeline

Act on every new file dropped in a Northwind folder — convert, log, route, notify.

Updated Aug 5, 2025

Automation Beginner Drive Sheets

Spin up a client folder structure on intake

Create the standard Northwind folder set for every new client — design, dev, contracts, invoices.

Updated Jun 26, 2025

Google Forms automation

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

17 articles

Automation Intermediate Forms Gmail Drive Sheets

Trigger an onboarding sequence on form submit

Kick off tasks when a new Northwind hire submits their starter form.

Updated Oct 17, 2025

Automation Beginner Forms Sheets

Build a content-submission queue

Collect Northwind guest posts or ideas for review through a Form.

Updated Oct 9, 2025

Automation Intermediate Forms Sheets Drive

Roll a form over each cycle

Archive old responses and reset for the next Northwind cycle — quarterly OKR check-ins.

Updated Sep 27, 2025

Automation Advanced Forms Gmail

Build a conditional intake-form router

Send long Northwind forms only to relevant respondents based on short pre-survey answers.

Updated Sep 15, 2025

Automation Intermediate Forms Sheets Gmail Drive

Build a form-driven expense claim system

Collect Northwind receipts via a Form and route them through approval for payment.

Updated Sep 7, 2025

Automation Intermediate Forms Sheets Gmail

Build an asset or inventory request form

Track stock requests through approval — Northwind teammates ask, Awadesh approves, the warehouse ships.

Updated Aug 30, 2025

Automation Beginner Forms Gmail

Re-send a recurring weekly check-in form

Push a status form to the Northwind team each week — no Friday reminder needed.

Updated Aug 22, 2025

Automation Advanced Forms Sheets

Build a 360-degree feedback collector

Gather and aggregate multi-rater reviews for Northwind teammates anonymously.

Updated Aug 14, 2025

Automation Intermediate Forms Sheets Gmail

Build a registration system with waitlists

Manage Northwind workshop signups and overflow — first N get a slot, the rest get a waitlist.

Updated Aug 6, 2025

Automation Intermediate Forms

Push form data to a CRM or external API

Send Northwind form submissions downstream to HubSpot, Notion, or a custom endpoint.

Updated Aug 2, 2025

Automation Beginner Forms

Auto-close a form at a capacity limit

Stop accepting Northwind RSVPs once a quota is hit — no overselling the workshop.

Updated Jul 29, 2025

Automation Intermediate Forms Sheets Gmail

Build a form-based help-desk ticket system

Convert Northwind support submissions into tracked tickets with an ID and status.

Updated Jul 25, 2025

Automation Intermediate Forms Sheets

Detect and flag spam or duplicate submissions

Filter junk before it reaches the Northwind response sheet.

Updated Jul 21, 2025

Automation Intermediate Forms Sheets

Refresh form dropdowns from a live Sheet

Keep Northwind form choices in sync with a source-of-truth Sheet — no manual editing.

Updated Jul 17, 2025

Automation Intermediate Forms Calendar

Create a calendar booking from a form

Schedule Northwind appointments from form data — slot, attendee, confirmation.

Updated Jul 13, 2025

Automation Advanced Forms Sheets Gmail

Build a multi-stage approval form workflow

Chain Northwind forms for request, review, and sign-off — three approvals in sequence.

Updated Jun 27, 2025

Automation Intermediate Forms Gmail

Route form responses to the right team

Branch Northwind form submissions to the right owner based on the answer to a routing field.

Updated Jun 23, 2025

Email & Gmail automation

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

14 articles

Automation Intermediate Gmail Sheets

Turn forwarded emails into project tasks

Forward to [email protected] and a row lands in the Projects sheet under the right client.

Updated May 30, 2026

Automation Beginner Gmail Sheets

Turn starred emails into a task list

Sync every starred thread into the Northwind Tasks sheet automatically.

Updated May 26, 2026

Automation Advanced Gmail Sheets

Build a vacation-coverage auto-router

Reassign a teammate's incoming mail to a designated cover while they're away.

Updated Feb 24, 2026

Automation Advanced Gmail

Quarantine phishing-pattern emails

Flag suspicious sender and link patterns into a review label so they never sit in the active inbox.

Updated Feb 3, 2026

Automation Intermediate Gmail

Auto-label and route emails by language

Detect the message language and send each thread to the localised support owner.

Updated Jan 20, 2026

Automation Advanced Gmail

Pre-stage overnight draft replies for review

Run an AI drafting pass overnight so the support team starts the day with replies queued, not blank threads.

Updated Jan 13, 2026

Automation Advanced Gmail Sheets

Build an email-based approval system

Let managers approve Northwind expense requests by clicking a link in an email — no portal needed.

Updated Dec 23, 2025

Automation Advanced Gmail Sheets

Build a shared team-inbox triage system

Round-robin assign incoming support@ mail to teammates by labelling each thread with an owner.

Updated Dec 16, 2025

Automation Beginner Gmail Sheets

Tag VIP senders and prioritize their threads

Maintain a VIP list in a Sheet and auto-star and label their incoming mail.

Updated Dec 9, 2025

Automation Intermediate Gmail Sheets

Chase unsigned contracts automatically

Track sent agreements in a Sheet and follow up on the ones still open with escalating reminders.

Updated Nov 18, 2025

Automation Intermediate Gmail Sheets

Auto-respond to job applications with next steps

Acknowledge applicants on receipt, log them to a hiring sheet, and email the next step in the process.

Updated Nov 11, 2025

Automation Intermediate Gmail Sheets

Detect and flag duplicate customer emails

Spot the same person emailing twice (across different addresses) and group their threads with a shared label.

Updated Nov 4, 2025

Automation Intermediate Gmail Sheets

Auto-draft replies from canned-response templates

Match incoming questions to a template and stage a draft reply in Gmail you only need to send.

Updated Oct 21, 2025

Automation Intermediate 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.

Updated Sep 9, 2025

Google Sheets automation

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

4 articles

Google Slides automation

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

1 article

Web apps & deployment

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

22 articles

Automation Intermediate Sheets

Build a branded approval interface

Approve Northwind requests through a custom UI — clients click, decision is logged.

Updated Nov 8, 2025

Automation Intermediate Sheets

Build an interactive quiz or assessment app

Run Northwind tests with scoring and feedback — questions in a Sheet, results in another.

Updated Nov 4, 2025

Automation Advanced Drive

Build an expiring secure-download generator

Issue time-limited Northwind links via a web app — token in URL, server-side check.

Updated Oct 23, 2025

Automation Intermediate Sheets

Build a guided onboarding tour for Sheets

Walk Northwind's first-time users through dialogs — each step explains one feature.

Updated Oct 19, 2025

Automation Advanced Sheets

Serve multiple tenants from one web app

Show different Northwind client data per visitor — same script, customer-specific view.

Updated Oct 3, 2025

Automation Advanced Sheets Gmail

Build an end-to-end event-registration app

Handle Northwind event signups, payment, and confirmation in one Apps Script web app.

Updated Sep 29, 2025

Automation Advanced Sheets

Build a data-validation review panel

Surface and fix bad Northwind rows in a sidebar UI — click a row, see the issue, accept the fix.

Updated Sep 25, 2025

Automation Advanced

Version and roll back a web app safely

Manage Northwind web-app releases without breaking users — deploy slots, blue/green.

Updated Sep 17, 2025

Automation Intermediate Sheets

Build a public form with conditional logic

Show Northwind form fields based on earlier answers — branchy intake without Google Forms.

Updated Sep 13, 2025

Automation Intermediate Sheets

Build a QR-code check-in app

Scan to register attendance at Northwind events — the page logs to a Sheet.

Updated Sep 5, 2025

Automation Advanced Sheets

Build a Sheets-powered mini CRM app

Manage Northwind contacts in a real interface — search, edit, log activity.

Updated Aug 28, 2025

Automation Intermediate Sheets

Build an embeddable feedback widget

Collect input from any Northwind page via a small JavaScript snippet that posts to your script.

Updated Aug 24, 2025

Automation Advanced Sheets

Build a webhook receiver as a web app

Accept and process incoming Northwind events from Stripe, Slack, GitHub — log and act.

Updated Aug 16, 2025

Automation Intermediate Drive

Build a Drive file-upload web app

Let external users send Northwind files via a web form — no Drive account needed.

Updated Aug 12, 2025

Automation Advanced

Add login and access control to a web app

Gate Northwind pages behind authentication — Workspace email allowlist or token.

Updated Aug 8, 2025

Automation Intermediate Sheets

Build a row-detail inspector sidebar

Show full Northwind record details on cell click — opens a sidebar with the row expanded.

Updated Aug 4, 2025

Automation Advanced Calendar

Build a self-service booking web app

Let people reserve Northwind slots themselves — pick a time, get a confirmation.

Updated Jul 31, 2025

Automation Advanced Sheets

Build an internal admin dashboard

Manage Northwind data through a custom interface — clients, projects, invoices, all in one place.

Updated Jul 27, 2025

Automation Intermediate Sheets

Build a multi-step modal dialog wizard

Walk Northwind users through a complex task — collect inputs across screens.

Updated Jul 11, 2025

Automation Beginner Sheets

Create a custom menu with grouped actions

Give Northwind users a clean control panel inside Sheets — grouped tools, no scripting required.

Updated Jul 7, 2025

Automation Intermediate Sheets

Build a custom sidebar data-entry form

Capture structured input inside Northwind's Sheets — sidebar UI bound to the workbook.

Updated Jul 3, 2025

Automation Intermediate Sheets

Build a web form that writes to Sheets

Collect Northwind submissions without Google Forms — full control over fields and styling.

Updated Jun 29, 2025