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.
Mis à jour le 15 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
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
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
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
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
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
Auto-watermark PDFs in a folder
Stamp Northwind documents with a confidentiality watermark before they're shared.
Mis à jour le 6 sept. 2025
Sync a folder's contents to a Sheet
Keep a live inventory of Northwind Drive files and their metadata in a Sheet.
Mis à jour le 21 août 2025
Build an external file-request intake system
Collect uploads from outside people into a Northwind intake folder via a web app.
Mis à jour le 17 août 2025
Add searchable tags to files via a Sheet
Maintain metadata Drive doesn't support natively — search-friendly tags for every Northwind file.
Mis à jour le 13 août 2025
Generate thumbnails and a visual asset catalog
Build a browsable gallery Sheet of Northwind's Drive assets with thumbnail previews.
Mis à jour le 9 août 2025
Build a watched-folder processing pipeline
Act on every new file dropped in a Northwind folder — convert, log, route, notify.
Mis à jour le 5 août 2025
Auto-convert uploaded Office files to Google formats
Normalise .docx and .xlsx files dropped in Northwind's inbox into Docs and Sheets.
Mis à jour le 28 juil. 2025
Bulk-rename files to a naming convention
Apply consistent names across a Northwind folder — e.g., `YYYY-MM-DD ClientName Invoice.pdf`.
Mis à jour le 20 juil. 2025
Generate a shareable file-index Doc
List every file in a Northwind folder with links — share one Doc instead of folder access.
Mis à jour le 12 juil. 2025
Spin up a client folder structure on intake
Create the standard Northwind folder set for every new client — design, dev, contracts, invoices.
Mis à jour le 26 juin 2025
Auto-organize new files into folders by type
Sort Northwind's Drive uploads into a tidy folder tree by MIME type.
Mis à jour le 22 juin 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.
Mis à jour le 3 déc. 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
Generate a folder-level changelog
Track additions and deletions in a Northwind folder over time — a written history.
Mis à jour le 5 nov. 2025
Track contract expiry from Drive files
Read expiry dates out of Northwind contract Docs and warn before renewals.
Mis à jour le 28 oct. 2025
Build a Drive quota early-warning system
Alert Northwind before storage runs out — email when usage crosses 80%.
Mis à jour le 20 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 weekly Drive activity report
Summarise who created or edited what in Northwind's Drive this week — into Awadesh's inbox Friday.
Mis à jour le 10 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
Flag oversized media eating your quota
Find large images and videos in Northwind's Drive that are worth compressing.
Mis à jour le 25 août 2025
Build a Drive permissions auditor
Flag files shared publicly or with external addresses for a Northwind compliance review.
Mis à jour le 24 juil. 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.
Mis à jour le 16 juil. 2025
Find and stage duplicate files for deletion
Detect identical files across Drive by hash — stage them for review, don't auto-delete.
Mis à jour le 4 juil. 2025
Build a Drive storage audit dashboard
Report file counts, sizes, and owners across Northwind's Drive into a single audit Sheet.
Mis à jour le 30 juin 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.
Mis à jour le 11 déc. 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
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
Bulk-restore accidentally trashed files
Recover everything trashed in a date range — Northwind's emergency-undo button.
Mis à jour le 14 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
Move stale files to cold storage
Archive Northwind Drive files untouched for a year into a `cold storage` folder.
Mis à jour le 1 août 2025
Build a scheduled backup of key folders
Copy Northwind's critical Drive folders to an archive folder on a weekly cadence.
Mis à jour le 8 juil. 2025