appscript.dev

Approval workflows

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

Os artigos deste objetivo vêm de vários hubs de serviços e integrações.

AI-powered workflows

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

11 artigos

Automação Avançado

Build a multi-step AI agent workflow

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

Atualizado em 11 de fev. de 2026

Automação Intermediário Docs Sheets

Auto-write CRM notes from call summaries

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

Atualizado em 26 de jan. de 2026

Automação Intermediário Sheets

Build an AI bug-triage system

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

Atualizado em 22 de jan. de 2026

Automação Intermediário Docs Sheets

Extract follow-ups from call transcripts

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

Atualizado em 10 de jan. de 2026

Automação Avançado Docs

Build a contract-clause risk analyzer

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

Atualizado em 7 de nov. de 2025

Automação Intermediário Gmail

Predict email intent and route it

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

Atualizado em 22 de out. de 2025

Automação Intermediário Sheets

Build a content-moderation filter

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

Atualizado em 23 de ago. de 2025

Automação Avançado Drive Sheets

Build an AI resume screener

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

Atualizado em 15 de ago. de 2025

Automação Intermediário Docs Sheets

Turn meeting notes into assigned action items

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

Atualizado em 7 de ago. de 2025

Automação Intermediário Gmail

Auto-draft email replies with AI

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

Atualizado em 18 de jul. de 2025

Automação Intermediário Sheets Gmail

Score support tickets for urgency with AI

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

Atualizado em 6 de jul. de 2025

External APIs

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

8 artigos

Automação Avançado

Build an API-key vault and rotation system

Manage Northwind credentials securely at scale — centralised storage, scheduled rotation.

Atualizado em 22 de dez. de 2025

Automação Avançado

Build a two-factor SMS verification step

Add phone verification to a Northwind workflow — code via Twilio, validated by web app.

Atualizado em 18 de dez. de 2025

Automação Avançado Sheets

Sync invoices to QuickBooks or Xero

Push Northwind accounting data automatically — invoices created in Sheets flow to your books.

Atualizado em 16 de nov. de 2025

Automação Iniciante Sheets

Bridge Sheets to Zapier or Make

Trigger external automations from Northwind Sheets via webhooks — no Apps Script logic needed downstream.

Atualizado em 8 de nov. de 2025

Automação Intermediário Sheets

Sync tasks with Trello or Asana

Keep Northwind work aligned across Sheets and your client's tool of choice.

Atualizado em 23 de out. de 2025

Automação Avançado Sheets

Build a payment-webhook receiver

Catch Stripe payment events into a Northwind sheet — paid invoices flip status instantly.

Atualizado em 11 de out. de 2025

Automação Avançado Sheets

Build a Jira issue importer and exporter

Move Northwind tasks between Jira and Sheets — useful for client teams on Jira.

Atualizado em 25 de set. de 2025

Automação Intermediário Sheets

Schedule posts to social media APIs

Publish Northwind content from a Sheet automatically — drafts queued, posted on date.

Atualizado em 17 de set. de 2025

Google Calendar automation

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

9 artigos

Automação Avançado Calendar

Auto-reschedule low-priority conflicts

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

Atualizado em 16 de out. de 2025

Automação Intermediário 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.

Atualizado em 4 de out. de 2025

Automação Avançado Calendar Sheets

Build a shift-rota scheduler

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

Atualizado em 29 de ago. de 2025

Automação Intermediário Calendar Forms

Create events from appointment-form submissions

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

Atualizado em 13 de ago. de 2025

Automação Intermediário Calendar Sheets

Schedule content as a publishing calendar

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

Atualizado em 9 de ago. de 2025

Automação Avançado Calendar Sheets Gmail

Build an interview-scheduling coordinator

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

Atualizado em 28 de jul. de 2025

Automação Intermediário Calendar

Auto-decline meetings outside working hours

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

Atualizado em 20 de jul. de 2025

Automação Intermediário Calendar Sheets

Build a room and resource booking system

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

Atualizado em 12 de jul. de 2025

Automação Intermediário Calendar

Auto-block focus time around meetings

Reserve prep and recovery slots automatically around every Northwind meeting.

Atualizado em 30 de jun. de 2025

Google Docs automation

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

4 artigos

Google Drive automation

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

9 artigos

Automação Intermediário Drive Sheets

Build a recurring file-delivery system

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

Atualizado em 15 de dez. de 2025

Automação Intermediário 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.

Atualizado em 11 de dez. de 2025

Automação Intermediário Drive Sheets

Build a shared-folder onboarding kit

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

Atualizado em 29 de nov. de 2025

Automação Avançado Drive Sheets Gmail

Build a digital-asset request and approval flow

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

Atualizado em 9 de nov. de 2025

Automação Intermediário Drive Sheets

Auto-publish approved files to a public folder

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

Atualizado em 1 de nov. de 2025

Automação Intermediário Drive Sheets

Apply folder-based permission rules to uploads

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

Atualizado em 18 de set. de 2025

Automação Avançado Drive

Build an external file-request intake system

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

Atualizado em 17 de ago. de 2025

Automação Avançado Drive Sheets

Build a watched-folder processing pipeline

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

Atualizado em 5 de ago. de 2025

Automação Iniciante Drive Sheets

Spin up a client folder structure on intake

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

Atualizado em 26 de jun. de 2025

Google Forms automation

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

17 artigos

Automação Intermediário Forms Gmail Drive Sheets

Trigger an onboarding sequence on form submit

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

Atualizado em 17 de out. de 2025

Automação Iniciante Forms Sheets

Build a content-submission queue

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

Atualizado em 9 de out. de 2025

Automação Intermediário Forms Sheets Drive

Roll a form over each cycle

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

Atualizado em 27 de set. de 2025

Automação Avançado Forms Gmail

Build a conditional intake-form router

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

Atualizado em 15 de set. de 2025

Automação Intermediário Forms Sheets Gmail Drive

Build a form-driven expense claim system

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

Atualizado em 7 de set. de 2025

Automação Intermediário Forms Sheets Gmail

Build an asset or inventory request form

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

Atualizado em 30 de ago. de 2025

Automação Iniciante Forms Gmail

Re-send a recurring weekly check-in form

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

Atualizado em 22 de ago. de 2025

Automação Avançado Forms Sheets

Build a 360-degree feedback collector

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

Atualizado em 14 de ago. de 2025

Automação Intermediário 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.

Atualizado em 6 de ago. de 2025

Automação Intermediário Forms

Push form data to a CRM or external API

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

Atualizado em 2 de ago. de 2025

Automação Iniciante Forms

Auto-close a form at a capacity limit

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

Atualizado em 29 de jul. de 2025

Automação Intermediário Forms Sheets Gmail

Build a form-based help-desk ticket system

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

Atualizado em 25 de jul. de 2025

Automação Intermediário Forms Sheets

Detect and flag spam or duplicate submissions

Filter junk before it reaches the Northwind response sheet.

Atualizado em 21 de jul. de 2025

Automação Intermediário Forms Sheets

Refresh form dropdowns from a live Sheet

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

Atualizado em 17 de jul. de 2025

Automação Intermediário Forms Calendar

Create a calendar booking from a form

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

Atualizado em 13 de jul. de 2025

Automação Avançado Forms Sheets Gmail

Build a multi-stage approval form workflow

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

Atualizado em 27 de jun. de 2025

Automação Intermediário 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.

Atualizado em 23 de jun. de 2025

Email & Gmail automation

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

14 artigos

Automação Intermediário Gmail Sheets

Turn forwarded emails into project tasks

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

Atualizado em 30 de mai. de 2026

Automação Iniciante Gmail Sheets

Turn starred emails into a task list

Sync every starred thread into the Northwind Tasks sheet automatically.

Atualizado em 26 de mai. de 2026

Automação Avançado Gmail Sheets

Build a vacation-coverage auto-router

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

Atualizado em 24 de fev. de 2026

Automação Avançado Gmail

Quarantine phishing-pattern emails

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

Atualizado em 3 de fev. de 2026

Automação Intermediário Gmail

Auto-label and route emails by language

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

Atualizado em 20 de jan. de 2026

Automação Avançado 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.

Atualizado em 13 de jan. de 2026

Automação Avançado Gmail Sheets

Build an email-based approval system

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

Atualizado em 23 de dez. de 2025

Automação Avançado Gmail Sheets

Build a shared team-inbox triage system

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

Atualizado em 16 de dez. de 2025

Automação Iniciante Gmail Sheets

Tag VIP senders and prioritize their threads

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

Atualizado em 9 de dez. de 2025

Automação Intermediário Gmail Sheets

Chase unsigned contracts automatically

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

Atualizado em 18 de nov. de 2025

Automação Intermediário 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.

Atualizado em 11 de nov. de 2025

Automação Intermediário 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.

Atualizado em 4 de nov. de 2025

Automação Intermediário 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.

Atualizado em 21 de out. de 2025

Automação Intermediário 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.

Atualizado em 9 de set. de 2025

Google Sheets automation

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

4 artigos

Google Slides automation

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

1 artigo

Web apps & deployment

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

22 artigos

Automação Intermediário Sheets

Build a branded approval interface

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

Atualizado em 8 de nov. de 2025

Automação Intermediário Sheets

Build an interactive quiz or assessment app

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

Atualizado em 4 de nov. de 2025

Automação Avançado Drive

Build an expiring secure-download generator

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

Atualizado em 23 de out. de 2025

Automação Intermediário Sheets

Build a guided onboarding tour for Sheets

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

Atualizado em 19 de out. de 2025

Automação Avançado Sheets

Serve multiple tenants from one web app

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

Atualizado em 3 de out. de 2025

Automação Avançado Sheets Gmail

Build an end-to-end event-registration app

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

Atualizado em 29 de set. de 2025

Automação Avançado 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.

Atualizado em 25 de set. de 2025

Automação Avançado

Version and roll back a web app safely

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

Atualizado em 17 de set. de 2025

Automação Intermediário Sheets

Build a public form with conditional logic

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

Atualizado em 13 de set. de 2025

Automação Intermediário Sheets

Build a QR-code check-in app

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

Atualizado em 5 de set. de 2025

Automação Avançado Sheets

Build a Sheets-powered mini CRM app

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

Atualizado em 28 de ago. de 2025

Automação Intermediário Sheets

Build an embeddable feedback widget

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

Atualizado em 24 de ago. de 2025

Automação Avançado Sheets

Build a webhook receiver as a web app

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

Atualizado em 16 de ago. de 2025

Automação Intermediário Drive

Build a Drive file-upload web app

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

Atualizado em 12 de ago. de 2025

Automação Avançado

Add login and access control to a web app

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

Atualizado em 8 de ago. de 2025

Automação Intermediário Sheets

Build a row-detail inspector sidebar

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

Atualizado em 4 de ago. de 2025

Automação Avançado Calendar

Build a self-service booking web app

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

Atualizado em 31 de jul. de 2025

Automação Avançado Sheets

Build an internal admin dashboard

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

Atualizado em 27 de jul. de 2025

Automação Intermediário Sheets

Build a multi-step modal dialog wizard

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

Atualizado em 11 de jul. de 2025

Automação Iniciante Sheets

Create a custom menu with grouped actions

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

Atualizado em 7 de jul. de 2025

Automação Intermediário Sheets

Build a custom sidebar data-entry form

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

Atualizado em 3 de jul. de 2025

Automação Intermediário Sheets

Build a web form that writes to Sheets

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

Atualizado em 29 de jun. de 2025