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