appscript.dev

Approval workflows

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

Les articles de cet objectif proviennent de plusieurs hubs de services et d’intégrations.

AI-powered workflows

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

11 articles

Automatisation Avancé

Build a multi-step AI agent workflow

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

Mis à jour le 11 févr. 2026

Automatisation Intermédiaire Docs Sheets

Auto-write CRM notes from call summaries

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

Mis à jour le 26 janv. 2026

Automatisation Intermédiaire Sheets

Build an AI bug-triage system

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

Mis à jour le 22 janv. 2026

Automatisation Intermédiaire Docs Sheets

Extract follow-ups from call transcripts

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

Mis à jour le 10 janv. 2026

Automatisation Avancé Docs

Build a contract-clause risk analyzer

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

Mis à jour le 7 nov. 2025

Automatisation Intermédiaire Gmail

Predict email intent and route it

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

Mis à jour le 22 oct. 2025

Automatisation Intermédiaire Sheets

Build a content-moderation filter

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

Mis à jour le 23 août 2025

Automatisation Avancé Drive Sheets

Build an AI resume screener

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

Mis à jour le 15 août 2025

Automatisation Intermédiaire Docs Sheets

Turn meeting notes into assigned action items

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

Mis à jour le 7 août 2025

Automatisation Intermédiaire Gmail

Auto-draft email replies with AI

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

Mis à jour le 18 juil. 2025

Automatisation Intermédiaire Sheets Gmail

Score support tickets for urgency with AI

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

Mis à jour le 6 juil. 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

Automatisation Avancé Calendar

Auto-reschedule low-priority conflicts

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

Mis à jour le 16 oct. 2025

Automatisation Intermédiaire 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.

Mis à jour le 4 oct. 2025

Automatisation Avancé Calendar Sheets

Build a shift-rota scheduler

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

Mis à jour le 29 août 2025

Automatisation Intermédiaire Calendar Forms

Create events from appointment-form submissions

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

Mis à jour le 13 août 2025

Automatisation Intermédiaire Calendar Sheets

Schedule content as a publishing calendar

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

Mis à jour le 9 août 2025

Automatisation Avancé Calendar Sheets Gmail

Build an interview-scheduling coordinator

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

Mis à jour le 28 juil. 2025

Automatisation Intermédiaire Calendar

Auto-decline meetings outside working hours

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

Mis à jour le 20 juil. 2025

Automatisation Intermédiaire Calendar Sheets

Build a room and resource booking system

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

Mis à jour le 12 juil. 2025

Automatisation Intermédiaire Calendar

Auto-block focus time around meetings

Reserve prep and recovery slots automatically around every Northwind meeting.

Mis à jour le 30 juin 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

Automatisation Intermédiaire Drive Sheets

Build a recurring file-delivery system

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

Mis à jour le 15 déc. 2025

Automatisation Intermédiaire 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.

Mis à jour le 11 déc. 2025

Automatisation Intermédiaire Drive Sheets

Build a shared-folder onboarding kit

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

Mis à jour le 29 nov. 2025

Automatisation Avancé Drive Sheets Gmail

Build a digital-asset request and approval flow

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

Mis à jour le 9 nov. 2025

Automatisation Intermédiaire Drive Sheets

Auto-publish approved files to a public folder

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

Mis à jour le 1 nov. 2025

Automatisation Intermédiaire Drive Sheets

Apply folder-based permission rules to uploads

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

Mis à jour le 18 sept. 2025

Automatisation Avancé Drive

Build an external file-request intake system

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

Mis à jour le 17 août 2025

Automatisation Avancé Drive Sheets

Build a watched-folder processing pipeline

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

Mis à jour le 5 août 2025

Automatisation Débutant Drive Sheets

Spin up a client folder structure on intake

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

Mis à jour le 26 juin 2025

Google Forms automation

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

17 articles

Automatisation Intermédiaire Forms Gmail Drive Sheets

Trigger an onboarding sequence on form submit

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

Mis à jour le 17 oct. 2025

Automatisation Débutant Forms Sheets

Build a content-submission queue

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

Mis à jour le 9 oct. 2025

Automatisation Intermédiaire Forms Sheets Drive

Roll a form over each cycle

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

Mis à jour le 27 sept. 2025

Automatisation Avancé Forms Gmail

Build a conditional intake-form router

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

Mis à jour le 15 sept. 2025

Automatisation Intermédiaire Forms Sheets Gmail Drive

Build a form-driven expense claim system

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

Mis à jour le 7 sept. 2025

Automatisation Intermédiaire Forms Sheets Gmail

Build an asset or inventory request form

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

Mis à jour le 30 août 2025

Automatisation Débutant Forms Gmail

Re-send a recurring weekly check-in form

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

Mis à jour le 22 août 2025

Automatisation Avancé Forms Sheets

Build a 360-degree feedback collector

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

Mis à jour le 14 août 2025

Automatisation Intermédiaire 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.

Mis à jour le 6 août 2025

Automatisation Intermédiaire Forms

Push form data to a CRM or external API

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

Mis à jour le 2 août 2025

Automatisation Débutant Forms

Auto-close a form at a capacity limit

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

Mis à jour le 29 juil. 2025

Automatisation Intermédiaire Forms Sheets Gmail

Build a form-based help-desk ticket system

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

Mis à jour le 25 juil. 2025

Automatisation Intermédiaire Forms Sheets

Detect and flag spam or duplicate submissions

Filter junk before it reaches the Northwind response sheet.

Mis à jour le 21 juil. 2025

Automatisation Intermédiaire Forms Sheets

Refresh form dropdowns from a live Sheet

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

Mis à jour le 17 juil. 2025

Automatisation Intermédiaire Forms Calendar

Create a calendar booking from a form

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

Mis à jour le 13 juil. 2025

Automatisation Avancé Forms Sheets Gmail

Build a multi-stage approval form workflow

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

Mis à jour le 27 juin 2025

Automatisation Intermédiaire 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.

Mis à jour le 23 juin 2025

Email & Gmail automation

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

14 articles

Automatisation Intermédiaire Gmail Sheets

Turn forwarded emails into project tasks

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

Mis à jour le 30 mai 2026

Automatisation Débutant Gmail Sheets

Turn starred emails into a task list

Sync every starred thread into the Northwind Tasks sheet automatically.

Mis à jour le 26 mai 2026

Automatisation Avancé Gmail Sheets

Build a vacation-coverage auto-router

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

Mis à jour le 24 févr. 2026

Automatisation Avancé Gmail

Quarantine phishing-pattern emails

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

Mis à jour le 3 févr. 2026

Automatisation Intermédiaire Gmail

Auto-label and route emails by language

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

Mis à jour le 20 janv. 2026

Automatisation Avancé 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.

Mis à jour le 13 janv. 2026

Automatisation Avancé Gmail Sheets

Build an email-based approval system

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

Mis à jour le 23 déc. 2025

Automatisation Avancé Gmail Sheets

Build a shared team-inbox triage system

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

Mis à jour le 16 déc. 2025

Automatisation Débutant Gmail Sheets

Tag VIP senders and prioritize their threads

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

Mis à jour le 9 déc. 2025

Automatisation Intermédiaire Gmail Sheets

Chase unsigned contracts automatically

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

Mis à jour le 18 nov. 2025

Automatisation Intermédiaire 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.

Mis à jour le 11 nov. 2025

Automatisation Intermédiaire 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.

Mis à jour le 4 nov. 2025

Automatisation Intermédiaire 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.

Mis à jour le 21 oct. 2025

Automatisation Intermédiaire 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.

Mis à jour le 9 sept. 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

Automatisation Intermédiaire Sheets

Build a branded approval interface

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

Mis à jour le 8 nov. 2025

Automatisation Intermédiaire Sheets

Build an interactive quiz or assessment app

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

Mis à jour le 4 nov. 2025

Automatisation Avancé Drive

Build an expiring secure-download generator

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

Mis à jour le 23 oct. 2025

Automatisation Intermédiaire Sheets

Build a guided onboarding tour for Sheets

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

Mis à jour le 19 oct. 2025

Automatisation Avancé Sheets

Serve multiple tenants from one web app

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

Mis à jour le 3 oct. 2025

Automatisation Avancé Sheets Gmail

Build an end-to-end event-registration app

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

Mis à jour le 29 sept. 2025

Automatisation Avancé 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.

Mis à jour le 25 sept. 2025

Automatisation Avancé

Version and roll back a web app safely

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

Mis à jour le 17 sept. 2025

Automatisation Intermédiaire Sheets

Build a public form with conditional logic

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

Mis à jour le 13 sept. 2025

Automatisation Intermédiaire Sheets

Build a QR-code check-in app

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

Mis à jour le 5 sept. 2025

Automatisation Avancé Sheets

Build a Sheets-powered mini CRM app

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

Mis à jour le 28 août 2025

Automatisation Intermédiaire Sheets

Build an embeddable feedback widget

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

Mis à jour le 24 août 2025

Automatisation Avancé Sheets

Build a webhook receiver as a web app

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

Mis à jour le 16 août 2025

Automatisation Intermédiaire Drive

Build a Drive file-upload web app

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

Mis à jour le 12 août 2025

Automatisation Avancé

Add login and access control to a web app

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

Mis à jour le 8 août 2025

Automatisation Intermédiaire Sheets

Build a row-detail inspector sidebar

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

Mis à jour le 4 août 2025

Automatisation Avancé Calendar

Build a self-service booking web app

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

Mis à jour le 31 juil. 2025

Automatisation Avancé Sheets

Build an internal admin dashboard

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

Mis à jour le 27 juil. 2025

Automatisation Intermédiaire Sheets

Build a multi-step modal dialog wizard

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

Mis à jour le 11 juil. 2025

Automatisation Débutant Sheets

Create a custom menu with grouped actions

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

Mis à jour le 7 juil. 2025

Automatisation Intermédiaire Sheets

Build a custom sidebar data-entry form

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

Mis à jour le 3 juil. 2025

Automatisation Intermédiaire Sheets

Build a web form that writes to Sheets

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

Mis à jour le 29 juin 2025