📊 Google Sheets Export

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

✨ What It Does

Paste a Google Sheets URL and get back clean, structured JSON for every sheet tab. Each tab becomes one dataset item containing headers, rows (as key-value objects), and metadata.

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

🚀 Features

• 📋 Multi-tab support — automatically discovers and exports all sheet tabs
• 🔢 Typed data — numbers stay as numbers, dates as dates (not everything-is-a-string)
• 🎯 Sheet filtering — export specific tabs by name
• 📏 Row limits — cap rows per sheet for quick previews
• ⚡ Fast — pure HTTP, no browser rendering
• 💰 50 free sheets — lifetime free tier, then $2.00 per 1,000 sheets

📥 Input Parameters

Parameter	Type	Required	Description
spreadsheetUrl	string	Yes	Full URL of a public Google Sheet
sheetNames	string[]	No	Export only these tabs (by name). Leave empty for all tabs
maxRows	integer	No	Max rows per sheet tab. Leave empty for all rows

Example Input

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

📤 Output Example

Each sheet tab produces one dataset item:

{
  "spreadsheetTitle": "Data Is Plural — Structured Archive",
  "spreadsheetUrl": "https://docs.google.com/spreadsheets/d/1wZhPLMCHKJvwOkP4juclhjFgqIY8fQFMemwKL2c64vk/edit",
  "sheetName": "Items",
  "sheetIndex": 0,
  "headers": ["edition", "position", "headline", "text", "links"],
  "rows": [
    {
      "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"
    }
  ],
  "rowCount": 1995,
  "columnCount": 5
}

💡 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 tools that accept JSON input

💰 Pricing

Tier	Price	Details
Free	$0.00	First 50 sheet tabs (lifetime)
Paid	$2.00 / 1,000 sheets	Each sheet tab = 1 charged event

One "sheet" = one tab exported. A workbook with 3 tabs = 3 sheet events.

⚠️ 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"
• The actor uses Google's Visualization API (/gviz/tq) for typed JSON — more reliable than CSV parsing