Google Drive automation
Organise, audit, and back up Google Drive files and folders at scale with Apps Script.
File organisation
Sort, rename, and move files into the right folders.
24 件の記事
Build a recurring file-delivery system
Drop a fresh report file into a Northwind client folder weekly — they don't even ask.
更新日 2025年12月15日
Build a Drive search index in Sheets
Make Northwind's file metadata searchable in a Sheet — like Spotlight for Drive.
更新日 2025年12月7日
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日
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日
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日
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日
Apply folder-based permission rules to uploads
Auto-share new files in Northwind project folders with the right team.
更新日 2025年9月18日
Auto-watermark PDFs in a folder
Stamp Northwind documents with a confidentiality watermark before they're shared.
更新日 2025年9月6日
Sync a folder's contents to a Sheet
Keep a live inventory of Northwind Drive files and their metadata in a Sheet.
更新日 2025年8月21日
Build an external file-request intake system
Collect uploads from outside people into a Northwind intake folder via a web app.
更新日 2025年8月17日
Add searchable tags to files via a Sheet
Maintain metadata Drive doesn't support natively — search-friendly tags for every Northwind file.
更新日 2025年8月13日
Generate thumbnails and a visual asset catalog
Build a browsable gallery Sheet of Northwind's Drive assets with thumbnail previews.
更新日 2025年8月9日
Build a watched-folder processing pipeline
Act on every new file dropped in a Northwind folder — convert, log, route, notify.
更新日 2025年8月5日
Auto-convert uploaded Office files to Google formats
Normalise .docx and .xlsx files dropped in Northwind's inbox into Docs and Sheets.
更新日 2025年7月28日
Bulk-rename files to a naming convention
Apply consistent names across a Northwind folder — e.g., `YYYY-MM-DD ClientName Invoice.pdf`.
更新日 2025年7月20日
Generate a shareable file-index Doc
List every file in a Northwind folder with links — share one Doc instead of folder access.
更新日 2025年7月12日
Spin up a client folder structure on intake
Create the standard Northwind folder set for every new client — design, dev, contracts, invoices.
更新日 2025年6月26日
Auto-organize new files into folders by type
Sort Northwind's Drive uploads into a tidy folder tree by MIME type.
更新日 2025年6月22日
Audits
Report on storage, sharing, and ownership.
14 件の記事
Detect and report broken file shortcuts
Find Drive shortcuts in Northwind folders pointing at deleted or inaccessible files.
更新日 2025年12月3日
Build a Drive cleanup recommendation report
Suggest what Northwind can delete or archive — large, stale, duplicate, or untouched files.
更新日 2025年11月21日
Generate a folder-level changelog
Track additions and deletions in a Northwind folder over time — a written history.
更新日 2025年11月5日
Track contract expiry from Drive files
Read expiry dates out of Northwind contract Docs and warn before renewals.
更新日 2025年10月28日
Build a Drive quota early-warning system
Alert Northwind before storage runs out — email when usage crosses 80%.
更新日 2025年10月20日
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 weekly Drive activity report
Summarise who created or edited what in Northwind's Drive this week — into Awadesh's inbox Friday.
更新日 2025年9月10日
Build a document-retention policy enforcer
Delete Northwind files past their retention date — keep finance, drop drafts.
更新日 2025年8月29日
Flag oversized media eating your quota
Find large images and videos in Northwind's Drive that are worth compressing.
更新日 2025年8月25日
Build a Drive permissions auditor
Flag files shared publicly or with external addresses for a Northwind compliance review.
更新日 2025年7月24日
Auto-expire and revoke old sharing links
Tighten access after a set number of days — revoke link sharing on Northwind files older than 90 days.
更新日 2025年7月16日
Find and stage duplicate files for deletion
Detect identical files across Drive by hash — stage them for review, don't auto-delete.
更新日 2025年7月4日
Build a Drive storage audit dashboard
Report file counts, sizes, and owners across Northwind's Drive into a single audit Sheet.
更新日 2025年6月30日
Backups
Mirror or archive Drive content to other locations.
7 件の記事
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 shared-drive migration helper
Move Northwind files between drives with structure intact — from My Drive to a Shared Drive.
更新日 2025年10月8日
Build a version-snapshot system for key files
Keep dated copies of Northwind's critical Sheets before risky edits.
更新日 2025年9月22日
Bulk-restore accidentally trashed files
Recover everything trashed in a date range — Northwind's emergency-undo button.
更新日 2025年9月14日
Pre-create dated archive folders
Generate per-month folders ahead of time so nothing lands in `misc/`.
更新日 2025年9月2日
Move stale files to cold storage
Archive Northwind Drive files untouched for a year into a `cold storage` folder.
更新日 2025年8月1日
Build a scheduled backup of key folders
Copy Northwind's critical Drive folders to an archive folder on a weekly cadence.
更新日 2025年7月8日