Pricing

from $2.00 / 1,000 sheet rows

Try for free

Go to Apify Store

Google Sheets Scraper API - Sheet to JSON, No OAuth

Try for free

Read any Google Sheet as typed JSON rows - no Google sign-in, no OAuth, no Drive prompt. Link-shared sheets work from the URL alone, private ones via your service account. Every tab and many sheets in one run, SQL-like filtering, dates ISO-normalised. On a schedule it bills only rows that changed.

Pricing

from $2.00 / 1,000 sheet rows

Rating

0.0

(0)

Developer

Blackcube

Actor stats

Bookmarked

Total users

Monthly active users

7 hours ago

Last modified

Categories

Automation

Integrations

Developer tools

You can access the Google Sheets Scraper API - Sheet to JSON, No OAuth programmatically from your own applications by using the Apify API. You can also choose the language preference from below. To use the Apify API, you’ll need an Apify account and your API token, found in API & Integrations in Apify Console.

Python

JavaScript

CLI

OpenAPI

HTTP

MCP

1from apify_client import ApifyClient
2
3# Initialize the ApifyClient with your Apify API token
4# Replace '<YOUR_API_TOKEN>' with your token.
5client = ApifyClient("<YOUR_API_TOKEN>")
6
7# Prepare the Actor input
8run_input = {
9    "url": "https://docs.google.com/spreadsheets/d/1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms/edit?usp=sharing",
10    "urls": [],
11    "tabs": [],
12    "headersRow": 1,
13    "skipRows": 0,
14    "typed": True,
15    "trimEmpty": True,
16    "includeMetadata": False,
17    "maxItems": 1000,
18    "maxCostUsd": 25,
19    "monitor": False,
20    "monitorChangesOnly": True,
21    "mode": "auto",
22}
23
24# Run the Actor and wait for it to finish
25run = client.actor("vonsensey/google-sheets-scraper-api").call(run_input=run_input)
26
27# Fetch and print Actor results from the run's dataset (if there are any)
28print(f"💾 Check your data here: https://console.apify.com/storage/datasets/{run.default_dataset_id}")
29for item in client.dataset(run.default_dataset_id).iterate_items():
30    print(item)
31
32# 📚 Want to learn more 📖? Go to → https://docs.apify.com/api/client/python/docs/quick-start

Google Sheets Scraper API - Read Any Google Sheet as JSON API in Python

The Apify API client for Python is the official library that allows you to use Google Sheets Scraper API - Sheet to JSON, No OAuth API in Python, providing convenience functions and automatic retries on errors.

Install the apify-client

$pip install apify-client

Other API clients include:

Google Sheets Scraper API - Sheet to JSON, No OAuth API in JavaScript

Google Sheets Scraper API - Sheet to JSON, No OAuth API through CLI

Google Sheets Scraper API - Sheet to JSON, No OAuth OpenAPI definition

Google Sheets Scraper API - Sheet to JSON, No OAuth API

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

Contact Scraper BR — Email, WhatsApp + Receita Federal (CNPJ)

joaosbp/website-contact-finder-br

Bulk website contact scraper for Brazilian B2B lead enrichment. Finds emails, phones, WhatsApp links, contact pages, forms, and social profiles — then exports a CRM-ready CSV (one row per company, 26 columns) that imports directly into Google Sheets, Excel, Pipedrive, HubSpot, or RD Station.

João Victor

Google Shopping Scraper — Product Prices & Merchants

automation-lab/google-shopping-scraper

Compare product prices across merchants on Google Shopping: titles, prices, numeric price, merchants, ratings, delivery info, product URLs, country/language targeting, and exports.

Stas Persiianenko

364

Google Play Reviews Scraper

fabrikit/google-play-reviews-scraper

Scrape Google Play reviews for any app: rating, text, version, helpful votes and developer replies. Any country and language, no API key, no proxies. US$0.40 per 1,000 reviews.

Fabrikit

Google Sheets Reader & Writer

accurate_pouch/google-sheets-rw

Read any Google Sheet to JSON or write rows to a sheet — via Service Account auth. No OAuth blocking, no failed logins. Supports read, append, replace, modify, and backup modes. Includes safe replace, dry run, auto-create tab, and rate limit retry.

Manchitt Sanan

OpenStreetMap POI Extractor

automation-lab/openstreetmap-poi-extractor

Extract POIs from OpenStreetMap via Overpass API. Search by location + radius or bounding box. Filter by 20+ categories (restaurants, hotels, hospitals, parks, shops). Outputs name, coords, address, phone, website, opening hours. No API key needed.

Stas Persiianenko

Meta Instagram Scraper API — Profiles, Posts, Reels, Comments

pro100chok/instagram-scraper-all-in-one

Instagram scraper and unofficial Instagram API: profiles, posts, reels, comments, likes, followers, tagged, stories, highlights, hashtags, locations, search and bio emails — 15 modes. Posts add carousel slides, media sizes, reel audio and alt text. No login for 8 modes. JSON/CSV/Excel from $0.90/1k.

Raven

5.0

(1)

SoundCloud Scraper

automation-lab/soundcloud-scraper

Extract SoundCloud tracks, playlists, and artist profiles. Get play counts, likes, reposts, genre, tags, ISRC, and full creator details. No API key needed.

Stas Persiianenko

246

YouTube Scraper API — Videos, Shorts, Comments, Emails, Leads

pro100chok/youtube-scraper-all-in-one

YouTube scraper and unofficial YouTube Data API — no key, no quotas: video details with exact views/likes, chapters, caption tracks, media formats, channel profiles, search filters, Shorts, Emails, live streams, comments with replies, transcripts and playlists. JSON/CSV/Excel. From $2/1k videos.

Raven

5.0

(1)