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