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