Google Sheets Export — Fast Public Sheet to JSON

Export any public Google Sheet to structured JSON — with typed data and column headers. No login or API key required.

What It Does

Paste a Google Sheets URL and get back one dataset item per spreadsheet row. Column headers become JSON keys. Numbers stay as numbers, dates as dates — not everything-is-a-string.

Works with any Google Sheet shared as "Anyone with the link can view" — no Google account, no API credentials, no OAuth setup needed.

Features

• Flat output — one dataset item per row, perfect for CSV/Excel export
• Multi-tab support — automatically discovers and exports all sheet tabs
• Typed data — numbers stay as numbers, dates as dates
• Sheet filtering — export specific tabs by name
• Row limits — cap rows per sheet for quick previews
• Fast — pure HTTP, no browser rendering

Input Parameters

Example Input

{
  "spreadsheetUrl": "https://docs.google.com/spreadsheets/d/1wZhPLMCHKJvwOkP4juclhjFgqIY8fQFMemwKL2c64vk/edit",
  "sheetNames": ["Items"],
  "maxRows": 5
}

Output Example

Each spreadsheet row becomes one dataset item. The sheetName field identifies which tab the row came from:

{
  "sheetName": "Items",
  "edition": "2019.10.23",
  "position": 1,
  "headline": "U.S. exposed nuclear sites",
  "text": "The Department of Energy has released a dataset...",
  "links": "https://example.com",
  "hattips": "@journalist"
}

A workbook with 3 tabs of 100 rows each = 300 dataset items.

Use Cases

• Data pipelines — feed Google Sheets data into ETL workflows
• Automation — sync spreadsheet data to databases, CRMs, or APIs
• Research — bulk-export public datasets shared as Google Sheets
• Monitoring — periodically snapshot spreadsheet data for change tracking
• Integration — connect Google Sheets to Zapier, Make, or any tool that accepts JSON

Pricing

$2.00 per 1,000 sheet tabs exported. Each sheet tab = 1 charged event, regardless of row count.

Requirements

• The Google Sheet must be shared as "Anyone with the link can view"
• Go to Share → General access → "Anyone with the link" → Viewer
• Private or restricted sheets will return an error

How to Find the URL

1. Open your Google Sheet in a browser
2. Copy the URL from the address bar — it looks like: https://docs.google.com/spreadsheets/d/ABC123.../edit
3. Paste it into the spreadsheetUrl input field

That's it — the actor extracts the spreadsheet ID automatically.

Notes

• Empty sheets are skipped automatically
• Date columns use the formatted display value (not raw serial numbers)
• If a column has no header, it gets a fallback name like "Column A", "Column B"
• Duplicate column headers are automatically suffixed (e.g., "Name", "Name_2")
• Output is flat — download as CSV, Excel, or JSON directly from the Apify dataset