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