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 articles
Build a recurring file-delivery system
Drop a fresh report file into a Northwind client folder weekly — they don't even ask.
Updated Dec 15, 2025
Build a Drive search index in Sheets
Make Northwind's file metadata searchable in a Sheet — like Spotlight for Drive.
Updated Dec 7, 2025
Build a shared-folder onboarding kit
Auto-grant new Northwind hires the folders they need on day one.
Updated Nov 29, 2025
Route saved email attachments to project folders
File Gmail attachments into the right Northwind client folder based on subject keywords.
Updated Nov 25, 2025
Bundle a folder of images into one PDF
Combine Northwind scans into a single deliverable PDF using a generation service.
Updated Nov 17, 2025
Keep a self-updating contents file per folder
Auto-create a `_contents.md` Doc inside every Northwind folder, refreshed nightly.
Updated Nov 13, 2025
Build a digital-asset request and approval flow
Route Northwind asset requests through Drive — request, review, approve, deliver.
Updated Nov 9, 2025
Auto-publish approved files to a public folder
Promote Northwind files once a status flips — from `drafts/` to `published/` automatically.
Updated Nov 1, 2025
Download and file documents from a link sheet
Pull referenced files from URLs in a Sheet into Northwind's Drive automatically.
Updated Oct 24, 2025
OCR scanned documents into searchable text
Extract text from image-based PDFs in Drive — Drive's free OCR on conversion to Docs.
Updated Oct 4, 2025
Split a multi-page PDF into separate files
Break a scanned Northwind batch into individual docs — one PDF per page.
Updated Sep 30, 2025
Merge many PDFs from a folder into one
Combine PDFs in a Northwind folder into a single deliverable — for client handovers.
Updated Sep 26, 2025
Apply folder-based permission rules to uploads
Auto-share new files in Northwind project folders with the right team.
Updated Sep 18, 2025
Auto-watermark PDFs in a folder
Stamp Northwind documents with a confidentiality watermark before they're shared.
Updated Sep 6, 2025
Sync a folder's contents to a Sheet
Keep a live inventory of Northwind Drive files and their metadata in a Sheet.
Updated Aug 21, 2025
Build an external file-request intake system
Collect uploads from outside people into a Northwind intake folder via a web app.
Updated Aug 17, 2025
Add searchable tags to files via a Sheet
Maintain metadata Drive doesn't support natively — search-friendly tags for every Northwind file.
Updated Aug 13, 2025
Generate thumbnails and a visual asset catalog
Build a browsable gallery Sheet of Northwind's Drive assets with thumbnail previews.
Updated Aug 9, 2025
Build a watched-folder processing pipeline
Act on every new file dropped in a Northwind folder — convert, log, route, notify.
Updated Aug 5, 2025
Auto-convert uploaded Office files to Google formats
Normalise .docx and .xlsx files dropped in Northwind's inbox into Docs and Sheets.
Updated Jul 28, 2025
Bulk-rename files to a naming convention
Apply consistent names across a Northwind folder — e.g., `YYYY-MM-DD ClientName Invoice.pdf`.
Updated Jul 20, 2025
Generate a shareable file-index Doc
List every file in a Northwind folder with links — share one Doc instead of folder access.
Updated Jul 12, 2025
Spin up a client folder structure on intake
Create the standard Northwind folder set for every new client — design, dev, contracts, invoices.
Updated Jun 26, 2025
Auto-organize new files into folders by type
Sort Northwind's Drive uploads into a tidy folder tree by MIME type.
Updated Jun 22, 2025
Audits
Report on storage, sharing, and ownership.
14 articles
Detect and report broken file shortcuts
Find Drive shortcuts in Northwind folders pointing at deleted or inaccessible files.
Updated Dec 3, 2025
Build a Drive cleanup recommendation report
Suggest what Northwind can delete or archive — large, stale, duplicate, or untouched files.
Updated Nov 21, 2025
Generate a folder-level changelog
Track additions and deletions in a Northwind folder over time — a written history.
Updated Nov 5, 2025
Track contract expiry from Drive files
Read expiry dates out of Northwind contract Docs and warn before renewals.
Updated Oct 28, 2025
Build a Drive quota early-warning system
Alert Northwind before storage runs out — email when usage crosses 80%.
Updated Oct 20, 2025
Enforce file naming and tagging governance
Flag Northwind files that don't match required naming or tagging conventions.
Updated Oct 16, 2025
Visualize a deep folder hierarchy
Generate a sitemap-style outline of Northwind's nested folders into a Doc.
Updated Oct 12, 2025
Build a weekly Drive activity report
Summarise who created or edited what in Northwind's Drive this week — into Awadesh's inbox Friday.
Updated Sep 10, 2025
Build a document-retention policy enforcer
Delete Northwind files past their retention date — keep finance, drop drafts.
Updated Aug 29, 2025
Flag oversized media eating your quota
Find large images and videos in Northwind's Drive that are worth compressing.
Updated Aug 25, 2025
Build a Drive permissions auditor
Flag files shared publicly or with external addresses for a Northwind compliance review.
Updated Jul 24, 2025
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.
Updated Jul 16, 2025
Find and stage duplicate files for deletion
Detect identical files across Drive by hash — stage them for review, don't auto-delete.
Updated Jul 4, 2025
Build a Drive storage audit dashboard
Report file counts, sizes, and owners across Northwind's Drive into a single audit Sheet.
Updated Jun 30, 2025
Backups
Mirror or archive Drive content to other locations.
7 articles
Archive a project folder when it's marked done
Zip and shelve completed Northwind work — keep active folders focused on in-flight projects.
Updated Dec 11, 2025
Build a shared-drive migration helper
Move Northwind files between drives with structure intact — from My Drive to a Shared Drive.
Updated Oct 8, 2025
Build a version-snapshot system for key files
Keep dated copies of Northwind's critical Sheets before risky edits.
Updated Sep 22, 2025
Bulk-restore accidentally trashed files
Recover everything trashed in a date range — Northwind's emergency-undo button.
Updated Sep 14, 2025
Pre-create dated archive folders
Generate per-month folders ahead of time so nothing lands in `misc/`.
Updated Sep 2, 2025
Move stale files to cold storage
Archive Northwind Drive files untouched for a year into a `cold storage` folder.
Updated Aug 1, 2025
Build a scheduled backup of key folders
Copy Northwind's critical Drive folders to an archive folder on a weekly cadence.
Updated Jul 8, 2025