# Google Sheets Import & Export: Read Public Sheets, No OAuth (`h1018y/anvil-google-sheets-all`) Actor

Pulls Google Sheets Import & Export down to one paste: drop a public sheet link and get every tab as clean JSON or CSV rows with tab name and row number. No OAuth, no Google account, no API key - just google sheets to json.

- **URL**: https://apify.com/h1018y/anvil-google-sheets-all.md
- **Developed by:** [ANVIL Tools](https://apify.com/h1018y) (community)
- **Categories:** Other
- **Stats:** 2 total users, 1 monthly users, 100.0% runs succeeded, 0 bookmarks
- **User rating**: No ratings yet

## Pricing

from $0.15 / 1,000 results

This Actor is paid per event. You are not charged for the Apify platform usage, but only a fixed price for specific events.
Since this Actor supports Apify Store discounts, the price gets lower the higher subscription plan you have.

Learn more: https://docs.apify.com/actors/running/actors-in-store.md#pay-per-event

## What's an Apify Actor?

An Actor is a serverless cloud program that runs on the Apify platform. It has two run modes.
In Batch mode, an Actor accepts a well-defined JSON input, performs an action which can take anything from a few seconds to a few hours,
and optionally produces a well-defined JSON output, datasets with results, or files in key-value store.
In Standby mode, an Actor provides a web server which can be used as a website, API, or an MCP server.

Apify vocabulary and the platform model are defined once, in the agent quickstart at https://apify.com/agents.md.

## How to integrate an Actor?

If asked about integration, you help developers integrate Actors into their projects.
You adapt to their stack and deliver integrations that are safe, well-documented, and production-ready.

Do not guess an integration path. Every one of them is in the agent quickstart at https://apify.com/agents.md: the Apify MCP server, Agent Skills with the Apify CLI, the JavaScript and Python clients, the REST API, and the account-free path for an agent with no human to sign in. It also carries the rule on stating cost before the first paid run.

For examples already wired to this Actor's own input schema, see the [API](#api) section below.

Each client library has reference documentation the quickstart does not restate: [JavaScript/TypeScript](https://docs.apify.com/api/client/js/docs.md) (`npm install apify-client`) and [Python](https://docs.apify.com/api/client/python/docs.md) (`pip install apify-client`).

# README

## 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

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

#### Output example (a real run)

```json
[
  {
    "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](https://docs.google.com/spreadsheets/)

### More tools from this developer

- [Tweet Scraper: Tweet Details by URL, No Login or Cookies](https://apify.com/h1018y/anvil-tweet-scraper)
- [YouTube Thumbnail Downloader: Bulk, Every Size & Titles](https://apify.com/h1018y/anvil-youtube-thumbnail-downloader)
- [ML Conference Finder: NeurIPS, ICLR & ICML Alternatives](https://apify.com/h1018y/anvil-ml-conference-finder)
- [YouTube Transcript Scraper: Find Every Moment a Word Is Said](https://apify.com/h1018y/anvil-youtube-transcript-scraper)
- [Facebook Ads Library Scraper: Only New Ads & Days Running](https://apify.com/h1018y/anvil-facebook-ads-library-scraper)
- [Reddit Scraper: Keyword Alerts for New Posts & Comments](https://apify.com/h1018y/anvil-reddit-scraper)
- [Twitter Scraper: New Tweets From Any X Account, No Login](https://apify.com/h1018y/anvil-twitter-scraper)
- [Facebook Posts Scraper: New Posts & Engagement Growth](https://apify.com/h1018y/anvil-facebook-posts-scraper)

# Actor input Schema

## `spreadsheets` (type: `array`):

Share links or IDs of sheets set to 'Anyone with the link can view'. Every tab is read.

## `allTabs` (type: `boolean`):

Off = only the tab in the link (#gid=...) or the first tab.

## `skipEmptyRows` (type: `boolean`):

Leave out rows where every cell is blank.

## `maxRows` (type: `integer`):

Stop after this many rows across all sheets and tabs.

## `useApifyProxy` (type: `boolean`):

Send requests through Apify Proxy.

## `proxyGroups` (type: `array`):

Optional Apify Proxy groups, e.g. RESIDENTIAL.

## Actor input object example

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

# Actor output Schema

## `results` (type: `string`):

All result rows (open as table, JSON, CSV or Excel).

# API

You can run this Actor programmatically using our API. Below are code examples in JavaScript, Python, and CLI, as well as the OpenAPI specification and MCP server setup.

## JavaScript example

```javascript
import { ApifyClient } from 'apify-client';

// Initialize the ApifyClient with your Apify API token
// Replace the '<YOUR_API_TOKEN>' with your token
const client = new ApifyClient({
    token: '<YOUR_API_TOKEN>',
});

// Prepare Actor input
const input = {
    "spreadsheets": [
        "https://docs.google.com/spreadsheets/d/1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms/edit"
    ],
    "allTabs": true,
    "maxRows": 100,
    "useApifyProxy": true
};

// Run the Actor and wait for it to finish
const run = await client.actor("h1018y/anvil-google-sheets-all").call(input);

// Fetch and print Actor results from the run's dataset (if any)
console.log('Results from dataset');
console.log(`💾 Check your data here: https://console.apify.com/storage/datasets/${run.defaultDatasetId}`);
const { items } = await client.dataset(run.defaultDatasetId).listItems();
items.forEach((item) => {
    console.dir(item);
});

// 📚 Want to learn more 📖? Go to → https://docs.apify.com/api/client/js/docs

```

## Python example

```python
from apify_client import ApifyClient

# Initialize the ApifyClient with your Apify API token
# Replace '<YOUR_API_TOKEN>' with your token.
client = ApifyClient("<YOUR_API_TOKEN>")

# Prepare the Actor input
run_input = {
    "spreadsheets": ["https://docs.google.com/spreadsheets/d/1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms/edit"],
    "allTabs": True,
    "maxRows": 100,
    "useApifyProxy": True,
}

# Run the Actor and wait for it to finish
run = client.actor("h1018y/anvil-google-sheets-all").call(run_input=run_input)

# Fetch and print Actor results from the run's dataset (if there are any)
print(f"💾 Check your data here: https://console.apify.com/storage/datasets/{run.default_dataset_id}")
for item in client.dataset(run.default_dataset_id).iterate_items():
    print(item)

# 📚 Want to learn more 📖? Go to → https://docs.apify.com/api/client/python/docs/quick-start

```

## CLI example

```bash
echo '{
  "spreadsheets": [
    "https://docs.google.com/spreadsheets/d/1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms/edit"
  ],
  "allTabs": true,
  "maxRows": 100,
  "useApifyProxy": true
}' |
apify call h1018y/anvil-google-sheets-all --silent --output-dataset

```

## MCP server setup

```json
{
    "mcpServers": {
        "apify": {
            "type": "http",
            "url": "https://mcp.apify.com/?tools=fetch-actor-details,h1018y/anvil-google-sheets-all"
        }
    }
}
```

The hosted server signs you in with OAuth on first connect, so no API token belongs in this config. Clients without OAuth support can send an `Authorization: Bearer <APIFY_API_TOKEN>` header instead, using a token from API & Integrations in Apify Console (https://console.apify.com/settings/integrations).

## OpenAPI specification

Download the OpenAPI definition: https://api.apify.com/v2/actors/X6nA8UJU5NJo4txba/builds/nrva0me6kNdv1KrgQ/openapi.json