Getting live data into Sheets and keeping it there

IMPORTDATA and IMPORTXML are fine until the day they are not, which is usually the day the report matters.

The built-in IMPORT functions are unauthenticated, uncached, rate-limited and silently return stale values. They are a prototype tool. Anything a business depends on should be pulled by a script that authenticates properly, handles pagination and rate limits, writes into a raw sheet with a timestamp, and tells somebody when it fails.

We build that layer: OAuth or API-key auth held in script properties rather than in cells, incremental fetching so you are not re-downloading history every hour, and a raw-data sheet that is append-only so a bad fetch cannot destroy last month's numbers.

You probably recognise at least one of these

IMPORTRANGE showing #REF! or a stale copy of yesterday's data
Hitting API rate limits and losing rows without noticing
Credentials pasted into a cell where anyone with view access can read them
A refresh that has to be triggered by a human opening the file
Data arriving in a different shape and overwriting good rows

What you get

Authenticated, scheduled fetch built in Apps Script with credentials stored securely
Append-only raw data sheets with fetch timestamps and row provenance
Rate-limit and pagination handling, with retry and backoff
Schema validation that quarantines unexpected data rather than writing it
Failure alerts by email or Slack

How the engagement runs

Source review

We check the API documentation and auth model before quoting — occasionally the answer is that the source cannot support what you need.

Fixed quote

Scope, price, date.

Build against a sandbox

Where the provider offers one, so your production quota is untouched during development.

Deploy and monitor

Two weeks of monitoring included.

Questions we get asked

Which sources have you worked with?

Common ones include Google Analytics, Search Console, Shopify, Stripe, QuickBooks, HubSpot, Airtable, and any REST or GraphQL API with documentation. If yours is unusual, send the docs and we will tell you honestly.

Where are our API keys stored?

In Apps Script's Properties Service inside your own Google account — never in a cell, never in our systems.

How often can it refresh?

Apps Script triggers go down to every minute, but most business data does not warrant more than hourly. We will design to your quota rather than to the maximum.

Work of this kind

A 50-million-row reporting pipeline from Drive to BigQuery

Tell us what it needs to do

Share the file or describe the outcome. We reply with scope, price and a delivery date.

Get a fixed quote