File management
Organise, audit, and back up Drive content. Generate, route, and clean up documents at scale.
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.
7 articles
Auto-categorize a photo library
Tag Northwind Drive images by visual content — product, team, event, behind-the-scenes.
Mis à jour le 3 févr. 2026
Build a document-classification system
Sort Northwind Drive files into types by their content — contracts, briefs, invoices.
Mis à jour le 6 janv. 2026
Auto-generate alt text for images
Describe a folder of Northwind images for accessibility — one prompt per image.
Mis à jour le 14 oct. 2025
Summarize YouTube videos into notes
Turn transcripts into Northwind study summaries — one Doc per video.
Mis à jour le 6 oct. 2025
Auto-tag a content library to a taxonomy
Apply consistent tags to Northwind's untagged articles from a controlled vocabulary.
Mis à jour le 8 sept. 2025
Build an AI data-cleaning assistant
Standardise messy Northwind names, addresses, and categories into clean canonical values.
Mis à jour le 4 sept. 2025
Categorize expenses and transactions with AI
Auto-assign accounting categories to Northwind's Expenses sheet.
Mis à jour le 3 août 2025
External APIs
Call REST APIs, import third-party data, and send messages from Google Apps Script using UrlFetchApp.
4 articles
Build an API-key vault and rotation system
Manage Northwind credentials securely at scale — centralised storage, scheduled rotation.
Mis à jour le 22 déc. 2025
Build a shipment and package tracker
Pull carrier tracking statuses into a Northwind Sheet — for outbound deliverables.
Mis à jour le 3 oct. 2025
Sync contacts to Mailchimp or Kit
Push Northwind subscribers from a Sheet to your email platform — one source of truth.
Mis à jour le 16 août 2025
Build a two-way Sheets-Airtable sync
Keep Northwind's project tracker in step between Sheets and Airtable — bi-directional.
Mis à jour le 4 août 2025
Google Calendar automation
Create events from Sheets, sync calendars, and email weekly meeting summaries with Apps Script.
1 article
Google Docs automation
Generate documents from templates, batch-create invoices and contracts, and export Docs to PDF with Apps Script.
4 articles
Auto-archive finalized Docs to dated folders
File completed Northwind Docs by month so the active folder stays focused on in-flight work.
Mis à jour le 18 janv. 2026
Auto-redact sensitive terms in a Doc
Black out names, numbers, or any pattern from a Doc — a redaction pass over a list of terms.
Mis à jour le 28 sept. 2025
Index every heading across a folder of Docs
Build a searchable outline of all documents in a folder — find any section by name.
Mis à jour le 21 sept. 2025
Batch-replace placeholders across many Docs
Run find-and-replace over an entire Drive folder of Docs in one pass.
Mis à jour le 6 juil. 2025
Google Drive automation
Organise, audit, and back up Google Drive files and folders at scale with Apps Script.
39 articles
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
Build a Drive search index in Sheets
Make Northwind's file metadata searchable in a Sheet — like Spotlight for Drive.
Mis à jour le 7 déc. 2025
Detect and report broken file shortcuts
Find Drive shortcuts in Northwind folders pointing at deleted or inaccessible files.
Mis à jour le 3 déc. 2025
Build a shared-folder onboarding kit
Auto-grant new Northwind hires the folders they need on day one.
Mis à jour le 29 nov. 2025
Route saved email attachments to project folders
File Gmail attachments into the right Northwind client folder based on subject keywords.
Mis à jour le 25 nov. 2025
Build a Drive cleanup recommendation report
Suggest what Northwind can delete or archive — large, stale, duplicate, or untouched files.
Mis à jour le 21 nov. 2025
Bundle a folder of images into one PDF
Combine Northwind scans into a single deliverable PDF using a generation service.
Mis à jour le 17 nov. 2025
Keep a self-updating contents file per folder
Auto-create a `_contents.md` Doc inside every Northwind folder, refreshed nightly.
Mis à jour le 13 nov. 2025
Build a digital-asset request and approval flow
Route Northwind asset requests through Drive — request, review, approve, deliver.
Mis à jour le 9 nov. 2025
Generate a folder-level changelog
Track additions and deletions in a Northwind folder over time — a written history.
Mis à jour le 5 nov. 2025
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
Download and file documents from a link sheet
Pull referenced files from URLs in a Sheet into Northwind's Drive automatically.
Mis à jour le 24 oct. 2025
Enforce file naming and tagging governance
Flag Northwind files that don't match required naming or tagging conventions.
Mis à jour le 16 oct. 2025
Visualize a deep folder hierarchy
Generate a sitemap-style outline of Northwind's nested folders into a Doc.
Mis à jour le 12 oct. 2025
Build a shared-drive migration helper
Move Northwind files between drives with structure intact — from My Drive to a Shared Drive.
Mis à jour le 8 oct. 2025
OCR scanned documents into searchable text
Extract text from image-based PDFs in Drive — Drive's free OCR on conversion to Docs.
Mis à jour le 4 oct. 2025
Split a multi-page PDF into separate files
Break a scanned Northwind batch into individual docs — one PDF per page.
Mis à jour le 30 sept. 2025
Merge many PDFs from a folder into one
Combine PDFs in a Northwind folder into a single deliverable — for client handovers.
Mis à jour le 26 sept. 2025
Build a version-snapshot system for key files
Keep dated copies of Northwind's critical Sheets before risky edits.
Mis à jour le 22 sept. 2025
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
Bulk-restore accidentally trashed files
Recover everything trashed in a date range — Northwind's emergency-undo button.
Mis à jour le 14 sept. 2025
Auto-watermark PDFs in a folder
Stamp Northwind documents with a confidentiality watermark before they're shared.
Mis à jour le 6 sept. 2025
Pre-create dated archive folders
Generate per-month folders ahead of time so nothing lands in `misc/`.
Mis à jour le 2 sept. 2025
Build a document-retention policy enforcer
Delete Northwind files past their retention date — keep finance, drop drafts.
Mis à jour le 29 août 2025
Google Forms automation
Notify, route, and post-process Google Forms responses automatically with Apps Script.
2 articles
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
Generate a PDF from each form response
Turn Northwind submissions into formatted documents stored under the right client folder.
Mis à jour le 5 juil. 2025
Email & Gmail automation
Automate inbox triage, mail merges, scheduled reports, and attachment handling with Gmail and Google Apps Script.
12 articles
Auto-forward receipts to your accountant
Route anything that looks like a receipt to a fixed address on a monthly schedule.
Mis à jour le 16 juin 2026
Auto-file quotes and proposals you receive
Detect inbound proposal PDFs and store them in Drive by client.
Mis à jour le 13 juin 2026
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.
Mis à jour le 9 juin 2026
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.
Mis à jour le 6 juin 2026
Generate a printable address book from contacts
Export Northwind's Google Contacts to a formatted Doc you can actually print.
Mis à jour le 21 avr. 2026
De-duplicate and merge your Gmail contacts
Find near-duplicate contacts in Google Contacts and consolidate them into one canonical record.
Mis à jour le 10 févr. 2026
Bulk-unsubscribe from senders you never open
Score senders by open rate over 90 days and stage unsubscribe actions for the worst offenders.
Mis à jour le 2 déc. 2025
Detect bounced emails and clean your list
Read delivery-failure notices in your inbox and mark dead addresses on the Subscribers sheet.
Mis à jour le 25 nov. 2025
Auto-archive threads once you've replied
Keep only conversations awaiting a response visible in the inbox by archiving threads where you spoke last.
Mis à jour le 28 oct. 2025
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.
Mis à jour le 14 oct. 2025
Archive newsletters automatically after seven days
Sweep read promotional mail on a daily schedule to keep the inbox clean.
Mis à jour le 23 sept. 2025
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.
10 articles
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.
Mis à jour le 7 janv. 2026
Auto-import every CSV dropped in a folder
Append new vendor CSV exports into a master sheet automatically — drop the file, walk away.
Mis à jour le 10 déc. 2025
Build a two-way sync between two spreadsheets
Keep a shared client-facing sheet and a private internal sheet in step — both directions.
Mis à jour le 1 nov. 2025
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.
Mis à jour le 25 oct. 2025
Split a master sheet into per-owner sheets
Generate a filtered copy for each team member from the master Tasks sheet.
Mis à jour le 15 oct. 2025
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.
Mis à jour le 11 oct. 2025
Auto-generate a clickable workbook index
Build a Contents tab linking to every sheet in a workbook — refreshed when tabs are added.
Mis à jour le 1 oct. 2025
Auto-snapshot a sheet to a dated archive tab
Freeze month-end values before formulas recalculate — keep a permanent record of what they were.
Mis à jour le 27 sept. 2025
Build a self-cleaning data import pipeline
Pull, dedupe, and normalise external data on every refresh — no manual cleanup required.
Mis à jour le 20 sept. 2025
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.
Mis à jour le 26 juil. 2025
Google Slides automation
Generate decks from spreadsheets, batch-export slide content, and personalise presentations with Apps Script.
3 articles
Archive a dated status-snapshot deck weekly
Keep a visual history of Northwind progress — one snapshot deck per week, all in a folder.
Mis à jour le 16 nov. 2025
Swap logos and branding across decks
Replace logo assets across every Northwind deck when branding changes — old logo out, new logo in.
Mis à jour le 2 nov. 2025
Build a Slides-to-images exporter
Convert each slide to a PNG for the web — for Northwind's social posts and blog embeds.
Mis à jour le 20 juil. 2025
Web apps & deployment
Build webhooks, internal tools, and tiny web services with Apps Script deployed as a web app.
2 articles
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
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