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.
Mis à jour le 3 janv. 2026
Cache API responses to cut quota usage
Store and reuse Northwind API responses intelligently — sub-second hits, fewer bills.
Mis à jour le 26 déc. 2025
Build an API-key vault and rotation system
Manage Northwind credentials securely at scale — centralised storage, scheduled rotation.
Mis à jour le 22 déc. 2025
Build a rate-limit-aware API client
Back off and retry gracefully on 429s — Northwind's robust outbound HTTP pattern.
Mis à jour le 14 déc. 2025
Build a generic paginated-API fetcher
Handle cursors and pages for any large dataset — Northwind's standard pull pattern.
Mis à jour le 6 déc. 2025
Add carrier rate and shipping cost lookups
Quote Northwind shipping inline from a carrier API — DHL or UPS rates per order.
Mis à jour le 2 déc. 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
Fetch link previews and metadata
Pull titles, descriptions, and og:images for a column of Northwind links.
Mis à jour le 4 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
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 website uptime and response time
Ping Northwind URLs every 10 minutes and alert on failures — DIY uptime monitor.
Mis à jour le 1 sept. 2025
Handle OAuth 2.0 in Apps Script
Connect Northwind to APIs that require user authorisation — using the OAuth2 library.
Mis à jour le 29 juin 2025
Master UrlFetchApp for any REST API
A practical pattern for GET, POST, headers, and payloads — the foundation under every Northwind integration.
Mis à jour le 25 juin 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.
Mis à jour le 7 janv. 2026
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
Track real-estate listings for new matches
Monitor property feeds for Northwind office hunts — alert when a match appears.
Mis à jour le 28 nov. 2025
Translate columns with a translation API
Localise Northwind text in bulk without manual work — via Google Translate or DeepL.
Mis à jour le 24 nov. 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
Sync tasks with Trello or Asana
Keep Northwind work aligned across Sheets and your client's tool of choice.
Mis à jour le 23 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 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
Build a Jira issue importer and exporter
Move Northwind tasks between Jira and Sheets — useful for client teams on Jira.
Mis à jour le 25 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
Schedule posts to social media APIs
Publish Northwind content from a Sheet automatically — drafts queued, posted on date.
Mis à jour le 17 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
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
Build a weather-driven alert system
Trigger Northwind actions on forecast conditions — e.g., snow-day email to remote workers.
Mis à jour le 20 août 2025
Sync contacts to Mailchimp or Kit
Push Northwind subscribers from a Sheet to your email platform — one source of truth.
Mis à jour le 16 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
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.
Mis à jour le 18 déc. 2025
Bridge Sheets to Zapier or Make
Trigger external automations from Northwind Sheets via webhooks — no Apps Script logic needed downstream.
Mis à jour le 8 nov. 2025
Send rich notifications to Discord
Push Northwind deploy alerts and KPI updates to a Discord channel — embeds, not plain text.
Mis à jour le 15 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 WhatsApp notification sender
Push Northwind updates via the WhatsApp Business API — for client billing milestones.
Mis à jour le 23 juil. 2025
Send SMS notifications with Twilio
Text Northwind alerts straight from your scripts — for production outages or VIP events.
Mis à jour le 19 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
Post Sheets alerts to a Slack channel
Bridge Northwind spreadsheet events to Slack — every threshold breach lands in #alerts.
Mis à jour le 11 juil. 2025