← All integrations
Import.io + Google Sheets

Scrape websites into Google Sheets

Paste one IMPORTDATA formula into A1 and the sheet pulls your Import.io extractor’s latest run. Put the extractor on a schedule and the sheet stays current.

Connects via
Endpoint
Setup
1 min
Available on
Every plan; latest-run downloads don’t count as queries
Start free trialTalk to sales
Cell A1
=IMPORTDATA("…Google Sheets link from the extractor’s Integrate tab…")

How it connects.

Source

The web

Any public page, rendered, through managed proxies

Engine

Import.io

Rendering, proxy routing, captcha handling, extraction

Path

Data endpoint

Latest successful run, CSV or JSON

Destination

Google Sheets

One IMPORTDATA formula and the sheet refreshes itself from your extractor.

What teams do with it.

Price trackers people actually open

Competitor prices in a sheet the category team already lives in.

Share without sharing a login

Anyone with the sheet sees the data. Nobody needs an Import.io account.

A free BI layer

Build Looker Studio dashboards on the same sheet.

Set it up.

  1. Open the extractor in app.import.io and go to the Integrate tab.
  2. Copy the Google Sheets formula.
  3. Paste it into cell A1 of your sheet.
  4. Put the extractor on a schedule so the data stays current.

Questions.

How often does the sheet refresh?

Google re-runs IMPORTDATA roughly every one to two hours. Schedule the extractor to match, for example daily at 5am, and the sheet shows that run when you open it.

Do endpoint downloads count as queries?

No. The latest-run CSV, JSON and Google Sheets endpoints return data your extractor already collected, so they don’t count toward your plan. Only the Live Query API runs an extraction per request.

How fresh is the data?

As fresh as your schedule. Run the extractor hourly, daily or weekly and the endpoint always serves the latest successful run.

Related integrations.

All 50 integrations

EndpointManaged

Looker Studio

Free dashboards on Import.io data through Sheets or BigQuery.

Setup 5 minEndpointWebhook

Microsoft Excel

Power Query pulls the latest run into a refreshable table.

Setup 3 minEndpointManaged

Tableau

Web data in Tableau through Google Sheets or your warehouse.

Setup 10 minWebhookEndpoint

Zapier

Start a Zap every time an Import.io run succeeds.

Setup 5 min

Fresh web data
in Google Sheets.

Start free trialTalk to sales