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