Google Sheets Import & Export: Read Public Sheets, No OAuth

Google Sheets Import & Export - Paste a public Google Sheets link and get every tab back as clean rows - no Google account to connect.

What does Google Sheets Import & Export do?

Reads every tab of any 'anyone with the link' sheet from just the share link, with no OAuth or Google credentials, and tags each row with its tab name, row number and column list.

• Paste share links or sheet IDs - no OAuth, no API key
• Reads every tab, or just the one in the #gid link
• Each row keeps its tab name, row number and column headers
• Blank or duplicate headers get safe names (column_3, Price_2)
• Clear error when a sheet is not public, instead of an empty run

Why this Google Sheets Import & Export?

The low cases fail because Google auth setup breaks or confuses users, so half the runs end with errors and nothing in the sheet. This Google Sheets Import & Export checks every run and tells you plainly when a page could not be read, instead of returning empty or wrong rows.

Data you get from Google Sheets Import & Export

Every result is one flat row with these fields (values from a real run):

Field	Example
spreadsheetId	1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms
spreadsheetTitle	Example Spreadsheet
sheetName	Class Data
gid	0
rowNumber	2
row	{"Student Name": "Alexandra", "Gender": "Female", "Class Lev...
columns	["Student Name", "Gender", "Class Level", "Home State", "Maj...
sheetUrl	https://docs.google.com/spreadsheets/d/1BxiMVs0XRA5nFMdKvBdB...

How to use Google Sheets Import & Export

1. Press Start - the form already holds an example that works.
2. Put in your own input (see the fields on the Input tab).
3. Run it once, or put it on an Apify Schedule to get fresh rows every day.
4. Download the results as JSON, CSV or Excel, or send them to Google Sheets, Zapier, Make, the Apify API or an AI agent (Apify MCP server).

Input example

{
  "spreadsheets": [
    "https://docs.google.com/spreadsheets/d/1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms/edit"
  ],
  "allTabs": true,
  "skipEmptyRows": true,
  "maxRows": 100,
  "useApifyProxy": true
}

Output example (a real run)

[
  {
    "spreadsheetId": "1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms",
    "spreadsheetTitle": "Example Spreadsheet",
    "sheetName": "Class Data",
    "gid": "0",
    "rowNumber": 2,
    "row": {
      "Student Name": "Alexandra",
      "Gender": "Female",
      "Class Level": "4. Senior",
      "Home State": "CA",
      "Major": "English",
      "Extracurricular Activity": "Drama Club"
    },
    "columns": [
      "Student Name",
      "Gender",
      "Class Level",
      "Home State",
      "Major",
      "Extracurricular Activity"
    ],
    "sheetUrl": "https://docs.google.com/spreadsheets/d/1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms/edit#gid=0"
  },
  {
    "spreadsheetId": "1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms",
    "spreadsheetTitle": "Example Spreadsheet",
    "sheetName": "Class Data",
    "gid": "0",
    "rowNumber": 3,
    "row": {
      "Student Name": "Andrew",
      "Gender": "Male",
      "Class Level": "1. Freshman",
      "Home State": "SD",
      "Major": "Math",
      "Extracurricular Activity": "Lacrosse"
    },
    "columns": [
      "Student Name",
      "Gender",
      "Class Level",
      "Home State",
      "Major",
      "Extracurricular Activity"
    ],
    "sheetUrl": "https://docs.google.com/spreadsheets/d/1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms/edit#gid=0"
  }
]

One flat row per result.

How much does Google Sheets Import & Export cost?

You pay only per result (pay per event) - no monthly fee, no minimum, and the price per result is lower on Apify's Bronze, Silver and Gold plans. The exact price is on the Pricing tab. Apify's free plan credit is enough to try it on real input.

You want	What you pay for
A quick test with the example	a few results
A daily scheduled run	only the rows that run returns
A big one-off export	the results delivered - set a maximum in the input

Also searched as

• google sheets import
• google sheets to json
• public google sheet scraper
• google sheets export csv
• read google sheet without api
• google sheets all tabs

FAQ

Does Google Sheets Import & Export need a login, cookies or an API key? No. It reads public pages only.

Can I run Google Sheets Import & Export on a schedule? Yes - with Apify Schedules; each run returns fresh rows.

Can I call it from Python, JavaScript or an AI agent? Yes - through the Apify API, the Apify client libraries or the Apify MCP server.

Is it legal? It collects only data anyone can see without logging in. You are responsible for using it within the source site's terms and data protection law (GDPR, CCPA).

What if the site blocks a request? The run retries from a fresh connection and, if it still cannot read the page, stops with a clear message - never with made-up rows.

Do I need proxies? No setup needed - Google Sheets Import & Export uses Apify Proxy by default where the site needs it.

Troubleshooting

• No results: check the input (a public URL or a search term that returns results in a normal browser), then try the example input once.
• Fewer results than expected: raise the maximum in the input; some sites show only a part of their data without logging in, and Google Sheets Import & Export never logs in.
• The run stopped with a message: the message says what the site answered; run it again later or with fewer items.

Your feedback

Missing a field, found a bug, or need another site? Open an issue on the Issues tab - issues are answered and fixed. If Google Sheets Import & Export saved you time, a short review on this page helps others find it.

Data source: docs.google.com/spreadsheets

More tools from this developer

• Tweet Scraper: Tweet Details by URL, No Login or Cookies
• YouTube Thumbnail Downloader: Bulk, Every Size & Titles
• ML Conference Finder: NeurIPS, ICLR & ICML Alternatives
• YouTube Transcript Scraper: Find Every Moment a Word Is Said
• Facebook Ads Library Scraper: Only New Ads & Days Running
• Reddit Scraper: Keyword Alerts for New Posts & Comments
• Twitter Scraper: New Tweets From Any X Account, No Login
• Facebook Posts Scraper: New Posts & Engagement Growth