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