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