Pricing

from $5.00 / 1,000 sheet rows

Try for free

Go to Apify Store

Google Sheets to JSON API - Sheet as a JSON Endpoint

Try for free

Your spreadsheet as a JSON dataset, on demand or on a schedule. Rows come back keyed by column header with real types - numbers as numbers, dates as ISO-8601 - so they drop into a pipeline, a database load or an LLM prompt with no cleaning step. No Google login for link-shared sheets.

Pricing

from $5.00 / 1,000 sheet rows

Rating

0.0

(0)

Developer

Blackcube

Actor stats

Bookmarked

Total users

Monthly active users

14 hours ago

Last modified

Categories

Automation

Integrations

Developer tools

Sheet URL

url

Optional

The sheet's share link — copy it from Share → Copy link while the sheet is shared as 'Anyone with the link → Viewer'. Also accepted: the export/gviz/published-to-web CSV URL, the htmlview link, or the bare spreadsheet ID. No Google sign-in, no OAuth screen and no Drive permission prompt.

Type:string

Default:https://docs.google.com/spreadsheets/d/1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms/edit?usp=sharing

Example:

https://docs.google.com/spreadsheets/d/1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms/edit?usp=sharing

More sheet URLs

urls

Optional

Optional. Extra sheets to read in the SAME run — paste one share link per line. Every row is stamped with the spreadsheet it came from, so twelve client sheets come back in one dataset and one schema. The row budget is split across the sheets so the first one cannot eat it.

Type:array

Default:

[]

Spreadsheet ID (advanced)

spreadsheetId

Optional

Optional. The long ID from the sheet URL, used directly instead of parsing the URL. It replaces the Sheet URL above when both are set; any entries in More sheet URLs are still read as well.

Type:string

Tabs

tabs

Optional

Optional. Sheet tab names or gid numbers to read, e.g. Leads or 0. Leave empty to read every tab — all tabs come back in one run and one schema, with the tab name on every row.

Type:array

Default:

[]

Query (SQL-like)

query

Optional

Optional. Google's visualization query language, executed by Google before any rows are returned: select A, B where C > 100 order by B desc limit 50. Column letters refer to the sheet's columns. Link mode only — the Sheets API ignores it.

Type:string

Example:

select A,C where C contains 'Senior' order by A limit 20

Header row

headersRow

Optional

The row the column names live on. 1 is the sheet's first row. Set 0 when the sheet has no header row and columns will be named A, B, C… like the sheet's own column letters.

Type:integer

Minimum:0

Maximum:100

Default:1

Rows to skip after the header

skipRows

Optional

Optional. How many rows to drop between the header and the data — for sheets that carry a title or a blank line under the header. Rows skipped here are never billed.

Type:integer

Minimum:0

Maximum:1000

Default:0

Typed values

typed

Optional

On: numbers come back as numbers, booleans as booleans, dates as ISO-8601 strings — ready for JSON pipelines, spreadsheets and LLM prompts. Off: every value is the exact text the sheet displays.

Type:boolean

Default:true

Drop empty columns and rows

trimEmpty

Optional

Sheets carry invisible trailing columns and blank rows from edits long deleted. On drops columns that have no header and no data in any row, and rows that are completely empty.

Type:boolean

Default:true

Emit a sheet metadata row

includeMetadata

Optional

Adds one free row describing what was read: the spreadsheet title, every tab with its gid, and the per-tab row counts.

Type:boolean

Default:false

Maximum rows

maxItems

Optional

Hard ceiling on billable rows for the whole run, split evenly across the sheets you gave. Free rows — errors, coverage, removed-row notices, the summary — never count against it.

Type:integer

Minimum:1

Maximum:1000000

Default:1000

Cost ceiling (USD)

maxCostUsd

Optional

A backstop, not an estimate: the run stops delivering and reports budgetReached once billed rows would cost more than this. The default sits well above a full 1,000-row run at every rate, so the row cap is what normally stops a run — lower it if you want a tighter guard.

Type:number

Minimum:0.01

Maximum:1000

Default:25

Monitor for changes

monitor

Optional

Remembers what each sheet looked like last run (key-value store, scoped to this Actor) and stamps every row: added, updated, unchanged, or removed. Pair with a schedule to watch a living sheet — unchanged rows are never billed, so a quiet sheet on an hourly cron costs only its per-sheet sync fee.

Type:boolean

Default:false

Return only changes

monitorChangesOnly

Optional

When monitoring, emit only added, updated and removed rows — unchanged rows are counted in the free coverage row but not delivered, and are never billed.

Type:boolean

Default:true

Access mode (advanced)

mode

Optional

Auto picks by what you supplied: a service-account key if present, else an API key, else plain link access. Force one only when Google's endpoints misbehave.

Type:string

Default:auto

Options:

autolinkapiKeyserviceAccount

Google API key (optional)

googleApiKey

Optional

Optional. A Google Cloud API key with the Sheets API enabled. Gives exact tab names and gids from the official API instead of the public HTML page. The sheet must still be link-shared; a key alone cannot read a Restricted sheet.

Type:string

Service account JSON (private sheets)

serviceAccountKey

Optional

Optional. The full JSON key of a Google Cloud service account. Share the sheet with the account's email (Share → add editor-less viewer) and this Actor reads PRIVATE sheets through the official Sheets API — the only way to reach a sheet that is not link-shared. Billed at the private-sheet rate.

Type:string

Slack App Directory Scraper

maximedupre/slack-app-directory-scraper

Scrape Slack App Directory apps, categories, pricing, languages, vendor links, policy URLs, and public emails. Search by keyword, browse categories, fetch known apps, or export public Slack marketplace data.

Maxime Dupré

Retail Chain Locations & Openings Tracker

monteva/retail-chain-locations-tracker

Get every store location for any retail, restaurant or service chain — straight from its own public store locator. Run on a schedule to track store openings & closings. Pay-per-result, no enterprise contract.

monteva

⚡ Vinted Turbo Scraper

kazkn/vinted-turbo-scraper

Scrape Vinted listings from one or multiple Vinted search URLs. Paste a filtered URL, run the actor, and export structured listing data to JSON, CSV, Excel, Sheets, or your automation workflows.

KazKN

269

5.0

(1)

OpenStreetMap POI Extractor

fetch_cat/openstreetmap-poi-extractor

Extract public OpenStreetMap POIs by area and category for lead generation, market mapping, and site research.

Hanna Nosova

Bluesky Social Search — Posts, Profiles & Feeds via AT Protocol

ryanclinton/bluesky-social-search

Search and extract posts, profiles, and author feeds from the Bluesky decentralized social network using the public AT Protocol API.

Ryan Clinton

Google Sheets Export & Scraper

sourabhbgp/google-sheets-export

Export any public Google Sheet to flat JSON rows, a full xlsx workbook, or both. Typed values, multi-tab, hyperlinks and formulas optional. No Google Cloud project, no OAuth, no API key — just paste a sharing URL.

Sourabh Kumar

Greenhouse, Lever, Ashby, Workable Jobs Scraper + Job Monitor

wickfeed/ats-job-aggregator

Greenhouse, Lever, Ashby, Workable & Recruitee jobs scraper + monitor — open roles from each company's live feed in one normalized schema. $1 per 1,000 jobs, $0 start. Optional diff mode, off by default: the first run bills the jobs delivered; later runs bill new + watched-field changes.

WickFeed

Discourse Forum Scraper

automation-lab/discourse-scraper

Extract topics, posts, and discussions from any public Discourse forum. Supports latest topics, category filtering, and keyword search. No login required.

Stas Persiianenko

Myer Australia Products, Prices, Brands & Offers Scraper

dromb/myer-wave1

Extract Myer Australia products, prices, availability, variants, barcodes, categories, brands, filters, and sale offers for price monitoring, market research, catalog enrichment, and ecommerce automation.

Dmitriy Gyrbu

Wildberries Products & Reviews Scraper | Парсер WB

columnar_auditorium/wildberries-products-reviews-scraper

Scrape Wildberries (wildberries.ru) products and customer reviews: search results, prices, ratings, sellers, up to 1,000 reviews per product. No login. Парсер товаров и отзывов Wildberries.