Pricing

$5.00 / 1,000 tabs

Try for free

Go to Apify Store

Public Google Sheets to JSON Data Scraper

Try for free

Convert public Google Sheets CSV tabs into JSON with preserved text, headers, row numbers, optional types and content hashes. Empty and partial tabs are free.

Pricing

$5.00 / 1,000 tabs

Rating

0.0

(0)

Developer

Tim Zinin

Actor stats

Bookmarked

Total users

Monthly active users

3 days ago

Last modified

Categories

You can access the Public Google Sheets to JSON Data Scraper 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    "publishedCsvUrls": ["https://docs.google.com/spreadsheets/d/198Kd2vPvpEyCgYAJLmu53jW-uPaf6m6COkmv2stQzrM/export?format=csv"],
10    "headerRow": 1,
11    "maxRows": 10000,
12    "inferTypes": False,
13}
14
15# Run the Actor and wait for it to finish
16run = client.actor("zinin/public-google-sheets-to-json").call(run_input=run_input)
17
18# Fetch and print Actor results from the run's dataset (if there are any)
19print(f"💾 Check your data here: https://console.apify.com/storage/datasets/{run.default_dataset_id}")
20for item in client.dataset(run.default_dataset_id).iterate_items():
21    print(item)
22
23# 📚 Want to learn more 📖? Go to → https://docs.apify.com/api/client/python/docs/quick-start

Public Google Sheets to JSON Converter API in Python

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

Install the apify-client

$pip install apify-client

Other API clients include:

Public Google Sheets to JSON Data Scraper API in JavaScript

Public Google Sheets to JSON Data Scraper API through CLI

Public Google Sheets to JSON Data Scraper OpenAPI definition

Public Google Sheets to JSON Data Scraper API

Google Sheets Import & Export

lukaskrivka/google-sheets

Import data from datasets or JSON files to Google Sheets. Programmatically process data in Sheets. Easier and faster than the official Google Sheets API and perfect for importing data from scraping.

Lukáš Křivka

4.7K

4.8

Google Sheets MCP Server

powerai/google-sheets-mcp-server

Google Sheets MCP Server provides seamless access to Google Sheets API, enabling AI assistants to create, read, update, and manage Google Spreadsheets programmatically.

PowerAI

Google Sheets Io

devon_gtme/google-sheets-io

Import Apify datasets into Google Sheets, or read sheets back into a dataset - authenticated with a Google service account, so the connection never expires and scheduled pipelines never break. Append, replace or read. Flattens nested objects, stable headers, auto 429 backoff. Free.

Devon Kellar

Google Sheets Live Query Actor

scrapeai/google-sheets

Run a live public query against Google Sheets and return up to 100 normalized records without static fixtures.

ScrapeAI

Google Sheets Monitoring

dtrungtin/google-sheets-monitoring

This actor will monitor the google sheets file and do actions correspondingly.

Tin

Google Sheets Import & Export — Fast, Reliable Sync

surefetch/google-sheets

Import Apify datasets, JSON or CSV into Google Sheets and export sheets back to JSON. Append, replace and read modes. Built for reliability: automatic retries, exponential backoff, no OAuth tokens that expire.

Jonas Eckl

1.0

Google Sheets Mcp

salesmart-srl/google-sheets-mcp

MCP server for Google Sheets integration. Read, write and format cells. Create spreadsheets and sheets. Append rows, clear ranges. Works with Claude, Cursor and any MCP-compatible AI assistant. Authenticate with Google Service Account.

Salesmart Srl

Apify Dataset to Google Sheets Sync

zentrafoundry/apify-dataset-to-google-sheets-sync

Send bounded Apify dataset rows to a buyer-controlled Google Sheets webhook endpoint.

Zentra

Google Sheets Scraper API - Sheet to JSON, No OAuth

vonsensey/google-sheets-scraper-api

Used by ops teams and no-code pipelines that need a Google Sheet as an API. Google Sheets scraper returning typed JSON rows with no Google sign-in, no OAuth and no Drive prompt. Link-shared sheets work from the URL alone. On a schedule it bills only the rows that actually changed.

Blackcube

Google Sheets to JSON API - Sheet as a JSON Endpoint

vonsensey/google-sheets-to-json-scraper-api

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.

Blackcube