appscript.dev

AI-powered workflows

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

GenAI custom functions

Call LLMs directly from Sheets cells.

2 articles

Classification

Categorise feedback, emails, and rows.

20 articles

Automation Intermediate Sheets

Build an AI keyword-clustering tool

Group Northwind's tracked search terms into topic clusters — for SEO content planning.

Updated Feb 19, 2026

Automation Advanced Sheets Gmail

Build an AI customer-churn predictor

Flag at-risk Northwind accounts from behavioural signals — usage, support tickets, billing.

Updated Feb 15, 2026

Automation Advanced Sheets

Build a context-aware AI data validator

Catch values that look wrong in context — '£10' for a Northwind retainer is suspicious.

Updated Feb 7, 2026

Automation Advanced Drive Sheets

Auto-categorize a photo library

Tag Northwind Drive images by visual content — product, team, event, behind-the-scenes.

Updated Feb 3, 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 Advanced Drive

Build a document-classification system

Sort Northwind Drive files into types by their content — contracts, briefs, invoices.

Updated Jan 6, 2026

Automation Intermediate Sheets

Build a translation QA checker with AI

Verify Northwind translations preserved their meaning — back-translate and compare.

Updated Dec 29, 2025

Automation Intermediate Sheets

Build an AI sentiment trend dashboard

Track Northwind customer feeling over time from incoming feedback — daily series chart.

Updated Dec 1, 2025

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 Sheets

Build an AI proofreading and style checker

Flag grammar and tone issues in a column of Northwind copy — every row gets feedback.

Updated Oct 30, 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 Advanced Sheets

Build an AI survey-response analyzer

Cluster Northwind open survey responses into insights with example quotes.

Updated Sep 20, 2025

Automation Intermediate Sheets

Auto-tag a content library to a taxonomy

Apply consistent tags to Northwind's untagged articles from a controlled vocabulary.

Updated Sep 8, 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 Intermediate Sheets

Quantify tone and sentiment in reviews

Measure how Northwind customers feel at scale — sentiment scores plus tone tags.

Updated Aug 19, 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 Sheets

Categorize expenses and transactions with AI

Auto-assign accounting categories to Northwind's Expenses sheet.

Updated Aug 3, 2025

Automation Advanced Sheets

Build an AI lead-scoring model

Rank Northwind prospects by fit using profile data — Claude scores 0-100 per row.

Updated Jul 30, 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

Automation Intermediate Sheets

Classify customer feedback by theme

Tag thousands of Northwind comments into themes automatically with Claude.

Updated Jul 2, 2025

Summarisation

Compress long threads or documents.

7 articles

Extraction

Pull structured fields out of unstructured text.

8 articles

Generation

Draft replies, content, and ideas at scale.

28 articles

Automation Intermediate Sheets Gmail

Generate and test email subject lines

A/B test AI-written Northwind subject lines for open rate — outputs ranked by past performance.

Updated Mar 3, 2026

Automation Advanced Sheets

Build retrieval-augmented Q&A over your data

Answer Northwind questions grounded in your own Sheet data — pass relevant rows as context.

Updated Feb 27, 2026

Automation Intermediate Sheets Gmail

Build an AI weekly-report narrator

Turn Northwind metrics into a written executive summary — numbers in, prose out.

Updated Feb 23, 2026

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 Sheets

Adapt marketing copy per region

Localise Northwind tone and references by market with AI — same message, regional flavour.

Updated Jan 30, 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 Beginner Sheets

Generate image-prompt variations for design

Brainstorm visual concepts in bulk — Northwind design team feeds these into Midjourney or DALL-E.

Updated Jan 18, 2026

Automation Intermediate Sheets

Write release notes from commit messages

Summarise Northwind's commits into user-facing release notes — group by type, write for humans.

Updated Jan 14, 2026

Automation Intermediate Sheets

Recommend personalized learning paths

Suggest next steps per Northwind learner with AI — pick from a catalogue based on their progress.

Updated Jan 2, 2026

Automation Intermediate Sheets

Compare answers across multiple AI models

A/B test Claude Haiku vs Sonnet on Northwind prompts — see which suits each job.

Updated Dec 25, 2025

Automation Advanced

Build an AI fallback and retry system

Handle errors and switch models gracefully — Northwind's AI calls never hard-fail.

Updated Dec 21, 2025

Automation Advanced

Batch and rate-limit AI calls safely

Stay within quotas on large Northwind jobs — fan-out with a token-bucket throttle.

Updated Dec 17, 2025

Automation Intermediate Sheets

Cut AI costs with response caching

Skip repeat Claude calls by caching results in a sheet — same prompt, never billed twice.

Updated Dec 13, 2025

Automation Beginner Sheets

Build a prompt-template library in Sheets

Manage and reuse Northwind prompts systematically — one source of truth, every AI script reads from it.

Updated Dec 9, 2025

Automation Intermediate Docs Sheets

Generate a quiz bank from source material

Turn a Northwind training Doc into exam questions automatically — multiple choice with answers.

Updated Nov 27, 2025

Automation Beginner Sheets

Build an AI brand and name generator

Brainstorm Northwind project names with built-in scoring — domain available, on-brand, memorable.

Updated Nov 15, 2025

Automation Intermediate Sheets

Expand role bullets into full job descriptions

Generate Northwind job postings from a Sheet of role bullets — outputs polished copy per role.

Updated Nov 11, 2025

Automation Intermediate Sheets

Generate a full content brief from a keyword

Draft an outline, angle, and target audience for a Northwind article from a single keyword.

Updated Oct 26, 2025

Automation Intermediate Docs

Draft meeting agendas from past notes

Generate Northwind meeting agendas from history and stated goals — no blank-page syndrome.

Updated Oct 18, 2025

Automation Intermediate Drive

Auto-generate alt text for images

Describe a folder of Northwind images for accessibility — one prompt per image.

Updated Oct 14, 2025

Automation Intermediate Gmail

Reply to customers in their own language

Build a multilingual Northwind response generator — same support voice, native phrasing.

Updated Oct 10, 2025

Automation Beginner Sheets

Generate realistic test data for your scripts

Create plausible sample records on demand — for testing Northwind's automations end-to-end.

Updated Sep 28, 2025

Automation Intermediate Sheets

Write a custom opening line per prospect

Personalise Northwind's cold outreach at scale — one bespoke first sentence per row.

Updated Sep 16, 2025

Automation Intermediate Docs Sheets

Draft FAQ answers from a knowledge base

Generate consistent Northwind support responses grounded in your KB Docs.

Updated Aug 31, 2025

See all 28 in Generation →