External APIs
Call REST APIs, import third-party data, and send messages from Google Apps Script using UrlFetchApp.
UrlFetchApp
The fundamentals of calling APIs from Apps Script.
14 articles
Handle streaming responses from an LLM API
Manage long Northwind AI outputs reliably — note: Apps Script UrlFetch is synchronous.
Updated Jan 3, 2026
Cache API responses to cut quota usage
Store and reuse Northwind API responses intelligently — sub-second hits, fewer bills.
Updated Dec 26, 2025
Build an API-key vault and rotation system
Manage Northwind credentials securely at scale — centralised storage, scheduled rotation.
Updated Dec 22, 2025
Build a rate-limit-aware API client
Back off and retry gracefully on 429s — Northwind's robust outbound HTTP pattern.
Updated Dec 14, 2025
Build a generic paginated-API fetcher
Handle cursors and pages for any large dataset — Northwind's standard pull pattern.
Updated Dec 6, 2025
Add carrier rate and shipping cost lookups
Quote Northwind shipping inline from a carrier API — DHL or UPS rates per order.
Updated Dec 2, 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
Fetch link previews and metadata
Pull titles, descriptions, and og:images for a column of Northwind links.
Updated Nov 4, 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
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 website uptime and response time
Ping Northwind URLs every 10 minutes and alert on failures — DIY uptime monitor.
Updated Sep 1, 2025
Handle OAuth 2.0 in Apps Script
Connect Northwind to APIs that require user authorisation — using the OAuth2 library.
Updated Jun 29, 2025
Master UrlFetchApp for any REST API
A practical pattern for GET, POST, headers, and payloads — the foundation under every Northwind integration.
Updated Jun 25, 2025
Data import
Pull data from Stripe, Notion, Airtable, and more.
28 articles
Sync calendar bookings with Calendly
Bridge Google Calendar and Calendly — Northwind bookings on either side appear on both.
Updated Jan 7, 2026
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
Track real-estate listings for new matches
Monitor property feeds for Northwind office hunts — alert when a match appears.
Updated Nov 28, 2025
Translate columns with a translation API
Localise Northwind text in bulk without manual work — via Google Translate or DeepL.
Updated Nov 24, 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
Sync tasks with Trello or Asana
Keep Northwind work aligned across Sheets and your client's tool of choice.
Updated Oct 23, 2025
Sync Shopify orders into Sheets
Mirror Northwind's e-commerce orders for analysis and reconciliation.
Updated Oct 19, 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
Build a Jira issue importer and exporter
Move Northwind tasks between Jira and Sheets — useful for client teams on Jira.
Updated Sep 25, 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
Schedule posts to social media APIs
Publish Northwind content from a Sheet automatically — drafts queued, posted on date.
Updated Sep 17, 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
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
Build a weather-driven alert system
Trigger Northwind actions on forecast conditions — e.g., snow-day email to remote workers.
Updated Aug 20, 2025
Sync contacts to Mailchimp or Kit
Push Northwind subscribers from a Sheet to your email platform — one source of truth.
Updated Aug 16, 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
Messaging
Send Slack, Telegram, Discord, and SMS messages.
8 articles
Build a two-factor SMS verification step
Add phone verification to a Northwind workflow — code via Twilio, validated by web app.
Updated Dec 18, 2025
Bridge Sheets to Zapier or Make
Trigger external automations from Northwind Sheets via webhooks — no Apps Script logic needed downstream.
Updated Nov 8, 2025
Send rich notifications to Discord
Push Northwind deploy alerts and KPI updates to a Discord channel — embeds, not plain text.
Updated Oct 15, 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 WhatsApp notification sender
Push Northwind updates via the WhatsApp Business API — for client billing milestones.
Updated Jul 23, 2025
Send SMS notifications with Twilio
Text Northwind alerts straight from your scripts — for production outages or VIP events.
Updated Jul 19, 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
Post Sheets alerts to a Slack channel
Bridge Northwind spreadsheet events to Slack — every threshold breach lands in #alerts.
Updated Jul 11, 2025