Reporting & dashboards
Scheduled reports, live KPI dashboards, and recurring data summaries powered by Apps Script.
Articles in this goal come from multiple service and integration hubs.
AI-powered workflows
Use Claude, Gemini, and other LLMs from Apps Script to classify, summarise, extract, and generate content.
27 articles
Parse semi-structured listings into tables
Extract recipes, specs, or ads from Northwind content into clean spreadsheet rows.
Updated Mar 7, 2026
Generate and test email subject lines
A/B test AI-written Northwind subject lines for open rate — outputs ranked by past performance.
Updated Mar 3, 2026
Build retrieval-augmented Q&A over your data
Answer Northwind questions grounded in your own Sheet data — pass relevant rows as context.
Updated Feb 27, 2026
Build an AI weekly-report narrator
Turn Northwind metrics into a written executive summary — numbers in, prose out.
Updated Feb 23, 2026
Build an AI keyword-clustering tool
Group Northwind's tracked search terms into topic clusters — for SEO content planning.
Updated Feb 19, 2026
Build an AI customer-churn predictor
Flag at-risk Northwind accounts from behavioural signals — usage, support tickets, billing.
Updated Feb 15, 2026
Build a context-aware AI data validator
Catch values that look wrong in context — '£10' for a Northwind retainer is suspicious.
Updated Feb 7, 2026
Build a translation QA checker with AI
Verify Northwind translations preserved their meaning — back-translate and compare.
Updated Dec 29, 2025
Compare answers across multiple AI models
A/B test Claude Haiku vs Sonnet on Northwind prompts — see which suits each job.
Updated Dec 25, 2025
Cut AI costs with response caching
Skip repeat Claude calls by caching results in a sheet — same prompt, never billed twice.
Updated Dec 13, 2025
Build an AI sentiment trend dashboard
Track Northwind customer feeling over time from incoming feedback — daily series chart.
Updated Dec 1, 2025
Build an AI data-enrichment pipeline
Fill missing company and contact fields on Northwind's prospect list — Claude infers from the row.
Updated Nov 23, 2025
Digest daily news into a personal briefing
Summarise headlines on a schedule — Northwind morning briefing for Awadesh.
Updated Nov 19, 2025
Build a contract-clause risk analyzer
Flag risky terms in Northwind contract text — auto-renewal, exclusivity, broad IP grants.
Updated Nov 7, 2025
Summarize pros and cons from reviews
Extract what Northwind customers love and hate about each product into a single roll-up.
Updated Nov 3, 2025
Build an AI invoice and receipt parser
Read Northwind documents into structured ledger rows — vendor, amount, line items.
Updated Oct 2, 2025
Extract entities and relationships from text
Build a structured graph from Northwind prose — people, companies, and how they connect.
Updated Sep 24, 2025
Build an AI survey-response analyzer
Cluster Northwind open survey responses into insights with example quotes.
Updated Sep 20, 2025
Build a competitor-mention monitor
Summarise what Northwind's rivals are doing each week — feeds in, summary out.
Updated Sep 12, 2025
Build an AI data-cleaning assistant
Standardise messy Northwind names, addresses, and categories into clean canonical values.
Updated Sep 4, 2025
Summarize a folder of PDFs into a briefing
Digest Northwind's research PDFs into one structured briefing Doc.
Updated Aug 27, 2025
Quantify tone and sentiment in reviews
Measure how Northwind customers feel at scale — sentiment scores plus tone tags.
Updated Aug 19, 2025
Build an AI resume screener
Score and summarise Northwind applicants against a role spec, into a hiring sheet.
Updated Aug 15, 2025
Categorize expenses and transactions with AI
Auto-assign accounting categories to Northwind's Expenses sheet.
Updated Aug 3, 2025
External APIs
Call REST APIs, import third-party data, and send messages from Google Apps Script using UrlFetchApp.
26 articles
Connect to an air-quality and weather feed
Build a Northwind environmental dashboard — current London AQI plus 5-day forecast.
Updated Dec 30, 2025
Build a podcast and media stats tracker
Pull Northwind's podcast download numbers across platforms into a single sheet.
Updated Dec 10, 2025
Build a job-listings aggregator
Collect Northwind-relevant postings via public job-board APIs into a sheet for the team.
Updated Nov 20, 2025
Sync invoices to QuickBooks or Xero
Push Northwind accounting data automatically — invoices created in Sheets flow to your books.
Updated Nov 16, 2025
Build a multi-API health-check monitor
Watch all Northwind's external dependencies from one sheet — third-party APIs, status pages.
Updated Nov 12, 2025
Build a location-intelligence toolkit
Combine Maps, Places, and geocoding APIs into Northwind helpers — distance, places, area lookups.
Updated Oct 31, 2025
Build an IP geolocation enrichment function
Add location data to Northwind visitor logs — country and city per IP, in one formula.
Updated Oct 27, 2025
Sync Shopify orders into Sheets
Mirror Northwind's e-commerce orders for analysis and reconciliation.
Updated Oct 19, 2025
Build a payment-webhook receiver
Catch Stripe payment events into a Northwind sheet — paid invoices flip status instantly.
Updated Oct 11, 2025
Build a live stock-portfolio tracker
Fetch prices and compute Northwind treasury gains/losses across holdings.
Updated Oct 7, 2025
Build a shipment and package tracker
Pull carrier tracking statuses into a Northwind Sheet — for outbound deliverables.
Updated Oct 3, 2025
Query a SQL database via an API layer
Pull external data into Northwind Apps Script via a thin HTTP wrapper around your DB.
Updated Sep 29, 2025
Monitor Reddit or Hacker News for keywords
Watch for Northwind brand and topic mentions across public forums and log to a sheet.
Updated Sep 21, 2025
Build a YouTube analytics tracker
Log Northwind's YouTube channel views and subscribers daily into a Sheet.
Updated Sep 13, 2025
Aggregate RSS feeds into a reading sheet
Pull Northwind reading from many sources into one sheet — dedupe, mark read.
Updated Sep 9, 2025
Track currency and crypto exchange rates
Log Northwind's relevant FX and BTC rates on a schedule — historical record for accounting.
Updated Sep 5, 2025
Monitor website uptime and response time
Ping Northwind URLs every 10 minutes and alert on failures — DIY uptime monitor.
Updated Sep 1, 2025
Build a Search Console ranking tracker
Log Northwind's keyword positions and clicks over time into a Sheet.
Updated Aug 28, 2025
Pull Google Analytics 4 metrics into Sheets
Build a self-updating Northwind traffic report — sessions, top pages, conversions.
Updated Aug 24, 2025
Pull HubSpot deals into a forecast sheet
Build Northwind's pipeline forecast from HubSpot — weighted by stage probability.
Updated Aug 12, 2025
Build a two-way Sheets-Notion sync
Mirror Northwind's Notion database to Sheets — both surfaces stay aligned.
Updated Aug 8, 2025
Build a two-way Sheets-Airtable sync
Keep Northwind's project tracker in step between Sheets and Airtable — bi-directional.
Updated Aug 4, 2025
Sync GitHub issues to a project sheet
Track Northwind's GitHub issues and PRs in Sheets — for non-engineer visibility.
Updated Jul 27, 2025
Build a two-way Slack-to-Sheet logger
Capture Northwind Slack messages into a sheet and post sheet updates back to Slack.
Updated Jul 15, 2025
Google Calendar automation
Create events from Sheets, sync calendars, and email weekly meeting summaries with Apps Script.
12 articles
Build a team-capacity view from calendars
Show how booked the Northwind team is this week — meeting hours per person.
Updated Oct 20, 2025
Flag meetings that could have been emails
Detect short, agendaless, oversized meetings — the smell of bad calendar hygiene.
Updated Oct 12, 2025
Build a contract-renewal calendar
Track Northwind's recurring-revenue renewal dates as calendar events for proactive sales.
Updated Oct 8, 2025
Archive past events to a log sheet
Keep a searchable Northwind meeting history — every event logged with title, attendees, duration.
Updated Sep 26, 2025
Email a clean daily agenda each morning
Send Awadesh a list of today's Northwind events at 7am — no app needed.
Updated Sep 22, 2025
Track meeting attendance and no-shows
Log RSVPs against actual turnout for Northwind events — spot the chronic no-shows.
Updated Sep 2, 2025
Export a printable monthly calendar PDF
Generate a Northwind schedule document each month — for the studio noticeboard.
Updated Aug 21, 2025
Show team PTO on a shared calendar
Sync time-off from the PTO sheet to a shared Northwind calendar — visibility for planning.
Updated Aug 5, 2025
Generate a timesheet from calendar events
Turn each week into billable hours, grouped by client tag in the event title.
Updated Jul 24, 2025
Detect and report double-booked time
Flag overlapping events on Northwind calendars before they cause conflicts.
Updated Jul 16, 2025
Build a meeting-time and cost auditor
Total the hours and dollars Northwind spends in meetings each week.
Updated Jul 8, 2025
Email yourself a weekly calendar summary
Send a Monday week-ahead digest of every Northwind meeting in the next seven days.
Updated Jun 26, 2025
Google Docs automation
Generate documents from templates, batch-create invoices and contracts, and export Docs to PDF with Apps Script.
6 articles
Audit Docs for word count and readability
Report length and reading grade per Northwind Doc, into a single audit Sheet.
Updated Nov 23, 2025
Extract tables from Docs into a Sheet
Pull tabular content out of a Doc into a Sheet for analysis or downstream processing.
Updated Nov 9, 2025
Generate a weekly report Doc from Sheet data
Narrate Northwind metrics into a formatted summary Doc, every Friday.
Updated Oct 5, 2025
Index every heading across a folder of Docs
Build a searchable outline of all documents in a folder — find any section by name.
Updated Sep 21, 2025
Compile many Docs into one master report
Concatenate sections from a folder of Docs into a single combined document.
Updated Sep 7, 2025
Build a Doc version-comparison report
Diff two Doc revisions and summarise what changed — for contract redlines.
Updated Aug 31, 2025
Google Drive automation
Organise, audit, and back up Google Drive files and folders at scale with Apps Script.
11 articles
Build a Drive search index in Sheets
Make Northwind's file metadata searchable in a Sheet — like Spotlight for Drive.
Updated Dec 7, 2025
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
Enforce file naming and tagging governance
Flag Northwind files that don't match required naming or tagging conventions.
Updated Oct 16, 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
Flag oversized media eating your quota
Find large images and videos in Northwind's Drive that are worth compressing.
Updated Aug 25, 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 a Drive permissions auditor
Flag files shared publicly or with external addresses for a Northwind compliance review.
Updated Jul 24, 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
Google Forms automation
Notify, route, and post-process Google Forms responses automatically with Apps Script.
7 articles
Email managers a weekly response summary
Digest the week's Northwind form submissions for managers — counts, hot topics, sample quotes.
Updated Oct 13, 2025
Score sentiment in open-text feedback
Rate Northwind feedback comments without manual review — using the in-Sheet sentiment function.
Updated Oct 5, 2025
Build a peer-nomination and voting system
Collect and tally Northwind nominations for awards or initiatives — one ballot, anonymous.
Updated Oct 1, 2025
Build an RSVP system with live headcounts
Track attendance and dietary needs for Northwind events — running count, live.
Updated Sep 23, 2025
Build a live dashboard of form responses
Visualise Northwind submissions as they arrive — counts, splits, sentiment.
Updated Sep 19, 2025
Auto-grade open responses against a rubric
Score and rank Northwind submissions with AI — keep grading consistent across reviewers.
Updated Sep 3, 2025
Build a 360-degree feedback collector
Gather and aggregate multi-rater reviews for Northwind teammates anonymously.
Updated Aug 14, 2025
Email & Gmail automation
Automate inbox triage, mail merges, scheduled reports, and attachment handling with Gmail and Google Apps Script.
17 articles
Pull event RSVPs from emails into a Sheet
Parse yes/no replies to event invites and tally attendance automatically.
Updated Jun 2, 2026
Embed inline charts in a status email
Render a Sheets chart as an image inside the email body, not as an attachment.
Updated May 12, 2026
Parse bank-alert emails into an expense ledger
Convert transaction alerts from Northwind's bank into categorised spend rows automatically.
Updated Apr 28, 2026
Email a weekly "what changed" report from a Sheet
Diff the Projects sheet week over week and email the team the rows that changed.
Updated Apr 14, 2026
Assemble a quarterly business review by email
Combine multi-tab Northwind reports into one client-ready QBR message and send it.
Updated Apr 7, 2026
Alert when a label hits a backlog threshold
Warn the Northwind team in Slack when a Gmail label has more than N unread threads.
Updated Mar 31, 2026
Rank email templates by reply rate
Log every templated send and compute which subject lines and bodies actually earn replies.
Updated Mar 24, 2026
Build a help-desk SLA timer from Gmail
Track first-response time per support thread and flag breaches against Northwind's 4-hour SLA.
Updated Mar 10, 2026
Detect and flag duplicate customer emails
Spot the same person emailing twice (across different addresses) and group their threads with a shared label.
Updated Nov 4, 2025
Extract order numbers from confirmation emails
Pull structured fields out of receipts and write them to a tracking sheet.
Updated Sep 30, 2025
Build a Gmail-to-Sheet lead inbox
Log every inquiry email landing in support@ as a structured row in a Leads sheet.
Updated Sep 16, 2025
Email yourself a morning briefing
Combine today's calendar, the weather, and your task list into one 7am digest.
Updated Sep 2, 2025
Email yourself a daily inbox-zero scorecard
Count unread, awaiting-reply, and snoozed threads and email yourself a 7am scorecard.
Updated Aug 26, 2025
Email a PDF snapshot of a dashboard daily
Render a Sheets dashboard tab to PDF every morning and deliver it to stakeholders' inboxes.
Updated Aug 19, 2025
Generate and email weekly client status updates
Pull each client's project data and send a tailored progress note from a Doc template.
Updated Aug 5, 2025
Send a weekly digest of unreplied emails
Surface inbox threads you haven't answered in a single Monday-morning summary.
Updated Jul 22, 2025
Build a newsletter sender with open tracking
Send to a Subscribers sheet and log opens with a 1x1 tracking pixel served from a web app.
Updated Jul 15, 2025
Google Sheets automation
Automate data entry, formatting, custom functions, and dashboards in Google Sheets with Apps Script.
26 articles
Build an OKR tracker with progress rollups
Aggregate Northwind's key-result progress into objective-level scores automatically.
Updated Jan 14, 2026
Auto-rebuild grouped summaries on edit
Refresh pivot-style rollups the instant data changes — no manual recompute.
Updated Jan 4, 2026
Build a data-quality scorecard
Grade any sheet on completeness, validity, and freshness — surface gaps as a single score.
Updated Dec 31, 2025
Build a meeting-cost calculator
Multiply attendees, salaries, and duration into a dollar figure — make the cost of meetings visible.
Updated Dec 24, 2025
Build a shared-expense splitter
Compute who owes whom from a group expense log — Northwind off-site dinner, settled.
Updated Dec 17, 2025
Auto-flag stale rows that need review
Highlight records in the Leads sheet that have been untouched for more than 14 days.
Updated Dec 6, 2025
Build a lightweight CRM pipeline board
Track deals through stages with stage-totals rolled up automatically — no CRM subscription required.
Updated Nov 29, 2025
Build a capacity-planning resource grid
Track who's allocated where across weeks — a single matrix view of team load.
Updated Nov 15, 2025
Alert the owner when imported data breaks a rule
Email the data owner whenever a scheduled refresh fails validation — no more silent broken pipelines.
Updated Nov 12, 2025
Build a multi-currency expense consolidator
Normalise Northwind's spend from many currencies to GBP using the live FX function.
Updated Nov 8, 2025
Detect duplicate rows on a composite key
Flag rows in the Invoices sheet that match across (client, invoiceNumber).
Updated Nov 5, 2025
Build a weighted scoring and ranking model
Score options by criteria, weight each criterion, and auto-rank — for vendor selection or feature prioritisation.
Updated Oct 29, 2025
Build an audit log of every edit
Record who changed which cell and when on a hidden Audit tab — accountability without ceremony.
Updated Oct 8, 2025
Consolidate contributor sheets into a master
Merge per-region or per-teammate sheets into one master nightly — single source of truth.
Updated Oct 4, 2025
Auto-snapshot a sheet to a dated archive tab
Freeze month-end values before formulas recalculate — keep a permanent record of what they were.
Updated Sep 27, 2025
Create a daily price-history logger
Snapshot vendor prices into a time-series sheet automatically — never lose a baseline.
Updated Sep 24, 2025
Build a self-cleaning data import pipeline
Pull, dedupe, and normalise external data on every refresh — no manual cleanup required.
Updated Sep 20, 2025
Detect and highlight data-entry anomalies
Flag outliers and impossible values on the Expenses sheet the moment a row is added.
Updated Sep 6, 2025
Build a linear-projection forecasting model
Extend a Northwind revenue trend into the next quarter with a simple linear regression.
Updated Aug 30, 2025
Build a subscription churn dashboard
Track active, churned, and reactivated accounts month over month from a Subscriptions sheet.
Updated Aug 27, 2025
Build a cohort-retention analysis tab
Compute month-over-month retention curves from a signups log — built monthly cohorts, automatic.
Updated Aug 23, 2025
Build a budget-vs-actual variance tracker
Compute and colour-code variances between budgeted and actual spend per project category.
Updated Aug 20, 2025
Generate a project burndown chart
Visualise remaining work against an ideal line, refreshed nightly from the Tasks sheet.
Updated Aug 16, 2025
Build a self-updating Gantt chart
Drive a visual timeline from start and end date columns in the Projects sheet.
Updated Aug 13, 2025
Google Slides automation
Generate decks from spreadsheets, batch-export slide content, and personalise presentations with Apps Script.
6 articles
Extract all deck text into a sheet
Pull text out of every slide for review, translation, or copy-editing.
Updated Jan 4, 2026
Archive a dated status-snapshot deck weekly
Keep a visual history of Northwind progress — one snapshot deck per week, all in a folder.
Updated Nov 16, 2025
Build a slide-based digital signage loop
Create an auto-advancing Slides deck for Northwind's office TV — KPIs and pipeline on rotation.
Updated Sep 14, 2025
Auto-assemble a weekly all-hands deck
Pull Northwind team updates into a standard all-hands deck, ready before the meeting.
Updated Aug 3, 2025
Auto-refresh charts in Slides from a Sheet
Update embedded Sheet charts in a Northwind deck on a schedule — never present stale data.
Updated Jul 6, 2025
Build a quarterly review deck generator
Assemble metric slides from live Northwind data — one deck per quarter, no manual building.
Updated Jun 29, 2025
Web apps & deployment
Build webhooks, internal tools, and tiny web services with Apps Script deployed as a web app.
9 articles
Build a staff inventory-lookup app
Let Northwind staff check stock from any device — type a SKU, see the count.
Updated Oct 15, 2025
Build a web app with interactive charts
Render live graphs from Northwind Sheet data using Chart.js inside a script-served page.
Updated Oct 11, 2025
Build a client-facing progress tracker
Show Northwind project status through a web app — clients self-serve their updates.
Updated Oct 7, 2025
Build a data-validation review panel
Surface and fix bad Northwind rows in a sidebar UI — click a row, see the issue, accept the fix.
Updated Sep 25, 2025
Build a print-optimized report web view
Render clean, printable Northwind pages — A4-ready CSS, page breaks where they belong.
Updated Sep 1, 2025
Build a read-only dashboard for non-editors
Visualise Northwind Sheet data for stakeholders without giving them edit access.
Updated Aug 20, 2025
Build an internal admin dashboard
Manage Northwind data through a custom interface — clients, projects, invoices, all in one place.
Updated Jul 27, 2025
Create a searchable, filterable directory
Serve a Northwind staff or client directory as a web app — search box, type-ahead, filtered list.
Updated Jul 23, 2025
Build a customer-facing status page
Publish Northwind's live system status from a Sheet — visible at status.northwind.studio.
Updated Jul 19, 2025