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