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