Google Sheets Scraper API - Sheet to JSON, No OAuth

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.

Export any Apify dataset to Google Sheets, or import a sheet into a dataset, using your own service account: no OAuth screen, no expiring tokens. The first 1,000 rows of every run are free. Append, replace, or upsert rows. Works as a run integration on any scraper.

📗 Google Sheets Import & Export — Free Reads, No OAuth

srd836/google-sheets-import-export

Reading is FREE: pull any link-shared Google Sheet into a dataset with zero setup — no API key, no OAuth, no Google Cloud project, no card. Add a service account key to write: append, replace or upsert with deduplication, straight from any Apify dataset. You only pay for rows written — $1 per 1,000.

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.

Read a Google Sheet into a dataset (public sheets need no key) and write datasets or JSON back - append, replace, or upsert - using a service account, with no interactive OAuth and automatic rate-limit retries.

Sheets Writer - No Google Verification Needed

kasimba/sheets-writer

Write any Apify dataset or JSON array to a Google Sheet using a service account - no OAuth consent screen, no Google app verification, no token that expires after a few days. Share your sheet with the service account email once; every write after that just works.

Private Google Sheets Reader API - Service Account Access

vonsensey/private-google-sheets-reader-scraper-api

Read the sheets you cannot share with a link. Share the sheet once with your own Google service account, paste its JSON key, and internal spreadsheets become a typed dataset - same schema, same multi-tab handling, same change monitoring. Link-shared sheets work here with no credentials.

Public Google Sheet scraper

advantageous_subcontra/public-google-sheet-scraper

Download data from a publicly available Google Sheet.

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.

Google Sheets URL Monitor turns a plain spreadsheets into a **no-code web monitoring dashboard**. It reads the URLs listed in your sheet's `URL` column, visits each page in a real browser, extracts the values you care about (prices, titles), and writes the fresh values straight back into the sheet.