Public Google Workspace Exporter: Sheets, Docs, Forms & Drive

Export public Google Sheets, Docs, Slides, Forms, Drive folders and Calendars without connecting a Google account. Reads typed sheet rows, document text and Markdown, slide notes, form questions, recursive folder metadata and calendar events from links shared with anyone.

Open in Apify Store$0.99 / 1K on Free

Short answer

Public Google Workspace Exporter: Sheets, Docs, Forms & Drive is an Apify Store Actor that returns 9 published output fields, including title, name, sheetTitle, rowNumber. It lists $0.99 per 1,000 results on the Free plan (pay per event), $0.49 on the Business plan. It takes 19 input settings; one is required (startUrls). Last updated Nov 21, 2026.

From the public Store listing and published build schema, synced 2026-11-21.
AutomationDeveloper toolsIntegrations

What it returns

9 fields from the published dataset schema. Export as JSON, CSV or Excel, or read the dataset through the Apify API.

  • recordType
  • title
  • name
  • sheetTitle
  • rowNumber
  • questionText
  • start
  • folderPathString
  • errorType

Input

Input settings for Public Google Workspace Exporter: Sheets, Docs, Forms & Drive
SettingTypeRequiredDefaultWhat it does
startUrls array Yes ["https://docs.google.com/spreadsheets/d/1Bxi… Links shared with 'Anyone with the link'. Sheets, Docs, Slides, Forms, Drive folders and public Calendar ICS feeds can be mixed.
mode string No auto Export every detected source, or restrict the run to one Google product.
sheetTabs array No [] Leave empty to export every tab. Add tab names such as 'Orders' or numeric gids such as '0'. Only applies to Sheets URLs.
sheetRange string No – Optional cell range such as A1:F200, A1:F, or A:F applied to each selected sheet tab.
detectHeaders boolean No true When on, the chosen row becomes the field names. When off, columns are named columnA, columnB, and so on.
headerRow integer No 1 1-based row used as the header when header detection is on.
sheetQuery string No – Optional filter such as select A,B where C > 10 order by A. Uses the public Google Visualization query language for Sheets.
includeFormulas boolean No false Add a formulas object to sheet rows with the original formula for cells that contain one. XLSX path only.
includeHyperlinks boolean No false Add a hyperlinks object to sheet rows with the link target for cells that contain one. XLSX path only.
includeSlideNotes boolean No true Add the speaker notes text to each slide record.
Show the other 9 settings
More input settings for Public Google Workspace Exporter: Sheets, Docs, Forms & Drive
SettingTypeRequiredDefaultWhat it does
folderMaxDepth integer No 3 How many subfolder levels to descend. 0 lists the root folder only; 3 lists root, children, grandchildren and great-grandchildren entries.
calendarFrom string No – Optional inclusive lower bound as YYYY-MM-DD or an ISO date-time. Events that end before this bound are skipped.
calendarTo string No – Optional inclusive upper bound as YYYY-MM-DD or an ISO date-time. Events that start after this bound are skipped.
calendarExpandRecurrences boolean No false When on, daily, weekly, monthly and yearly RRULE events become one record per occurrence inside the date window.
calendarMaxOccurrences integer No 100 Safety cap when recurrence expansion is on.
calendarIncludeCancelled boolean No false Keep events whose ICS status is CANCELLED.
maxItems integer No 1000 Stop after this many records. One sheet row, one slide, one question, one file and one event each count as one record.
emitErrorRecords boolean No true Push a clear error record for links that are private, deleted, unsupported or temporarily unreachable.
requestTimeoutSecs integer No 30 Per-request timeout for Google endpoints.

Example input

Built from the input form's published example values and defaults.

{
  "mode": "auto",
  "startUrls": [
    "https://docs.google.com/spreadsheets/d/1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms/edit"
  ],
  "sheetTabs": [],
  "detectHeaders": true,
  "headerRow": 1,
  "includeFormulas": false,
  "includeHyperlinks": false,
  "includeSlideNotes": true,
  "folderMaxDepth": 3,
  "calendarExpandRecurrences": false,
  "calendarMaxOccurrences": 100,
  "calendarIncludeCancelled": false,
  "maxItems": 5,
  "emitErrorRecords": true,
  "requestTimeoutSecs": 30
}

Run it from code or an AI agent

The same run through the Apify API, with the example input. You need an Apify API token; the run is billed to your account at the Store price.

Python

from apify_client import ApifyClient

client = ApifyClient("<YOUR_APIFY_TOKEN>")
run_input = {
    "mode": "auto",
    "startUrls": [
        "https://docs.google.com/spreadsheets/d/1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms/edit"
    ],
    "sheetTabs": [],
    "detectHeaders": True,
    "headerRow": 1,
    "includeFormulas": False,
    "includeHyperlinks": False,
    "includeSlideNotes": True,
    "folderMaxDepth": 3,
    "calendarExpandRecurrences": False,
    "calendarMaxOccurrences": 100,
    "calendarIncludeCancelled": False,
    "maxItems": 5,
    "emitErrorRecords": True,
    "requestTimeoutSecs": 30
}

run = client.actor("xyrelith-data/google-workspace-public-exporter").call(run_input=run_input)
if run is None:
    raise RuntimeError("The Actor run was not found.")
for item in client.dataset(run.default_dataset_id).iterate_items():
    print(item)

pip install apify-client

JavaScript

import { ApifyClient } from "apify-client";

const client = new ApifyClient({ token: "<YOUR_APIFY_TOKEN>" });
const input = {
    "mode": "auto",
    "startUrls": [
        "https://docs.google.com/spreadsheets/d/1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms/edit"
    ],
    "sheetTabs": [],
    "detectHeaders": true,
    "headerRow": 1,
    "includeFormulas": false,
    "includeHyperlinks": false,
    "includeSlideNotes": true,
    "folderMaxDepth": 3,
    "calendarExpandRecurrences": false,
    "calendarMaxOccurrences": 100,
    "calendarIncludeCancelled": false,
    "maxItems": 5,
    "emitErrorRecords": true,
    "requestTimeoutSecs": 30
};

const run = await client.actor("xyrelith-data/google-workspace-public-exporter").call(input);
const { items } = await client.dataset(run.defaultDatasetId).listItems();
console.log(items);

npm install apify-client

cURL

curl -X POST "https://api.apify.com/v2/actors/xyrelith-data~google-workspace-public-exporter/run-sync-get-dataset-items"   -H "Authorization: Bearer $APIFY_TOKEN"   -H "Content-Type: application/json"   -d '{"mode":"auto","startUrls":["https://docs.google.com/spreadsheets/d/1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms/edit"],"sheetTabs":[],"detectHeaders":true,"headerRow":1,"includeFormulas":false,"includeHyperlinks":false,"includeSlideNotes":true,"folderMaxDepth":3,"calendarExpandRecurrences":false,"calendarMaxOccurrences":100,"calendarIncludeCancelled":false,"maxItems":5,"emitErrorRecords":true,"requestTimeoutSecs":30}'

Waits for the run and returns the dataset items (runs over 300 seconds return HTTP 408; start an async run instead).

MCP (AI agents)

{
  "mcpServers": {
    "apify": {
      "url": "https://mcp.apify.com?tools=xyrelith-data/google-workspace-public-exporter",
      "headers": {
        "Authorization": "Bearer <YOUR_APIFY_TOKEN>"
      }
    }
  }
}

Adds this Actor as a tool in an MCP client that takes a remote server URL (Cursor, VS Code, Claude Code) through Apify's hosted MCP server. OAuth sign-in also works without the header. Clients that only start local servers can wrap the URL with npx mcp-remote.

What a run costs

The result rate falls on higher Apify plans. Each figure is the published per-result rate times the number of results.

Cost of Public Google Workspace Exporter: Sheets, Docs, Forms & Drive results by Apify plan
Apify planPer 1,00010,000 results100,000 results
Free plan$0.99$9.90$99
Starter plan$0.82$8.20$82
Scale plan$0.66$6.60$66
Business plan$0.49$4.90$49
  • Every run also has a start event, charged per GB of memory (minimum one): $0.10 on Free, $0.03 on Business. At its default memory of 4 GB a run starts at $0.40 on Free. Fewer, larger runs keep this small.
  • The Free plan includes $5 of monthly usage (Apify pricing, checked 2026-11-11); at the Free rate that covers at most about 5,050 results, less start events and platform usage.
  • Worked example: 10,000 results in one run on the Free plan cost $10.30 ($9.90 for results + $0.40 start), plus Apify platform usage (compute), billed separately by Apify.
  • Pay per event. Platform usage (compute) is billed by Apify on top of the event prices. Compare other tools in the cost estimator.

What people use it for

  • Export public workspace content
  • Collect calendar events

Google Workspace Marketplace App Search & Category Browser

Search Google Workspace Marketplace apps by keyword, browse a category, or fetch specific app IDs. Returns developer, rating, review count,…

10 output fields $0.99 per 1K

Google Workspace Marketplace Category Tracker

Track ranked apps in any Google Workspace Marketplace category. Returns app name, developer, rating, review count, pricing model, categories,…

15 output fields $0.99 per 1K

Google Workspace Marketplace Review Tracker

Track and monitor reviews for any Google Workspace Marketplace app. Filter by date, rating, and sort order - ideal for daily sentiment monitoring…

9 output fields $0.99 per 1K

Google Workspace Marketplace App Review Extractor by App ID

Pull public reviews for a specific Google Workspace Marketplace app by its App ID, with reviewer name, star rating, review text, posting date and…

11 output fields $0.99 per 1K

Google Events Finder: Concerts, Shows & Venues

Search Google's Events results by query, place, country, language and date window. Export one row per event with venue, address, ISO dates,…

16 output fields $0.99 per 1K

Google Maps Owner Updates, Offers & Events Monitor

Collect the updates, offers and events a business publishes on Google Maps. Search a market or paste place links, read post text, dates, photos,…

62 output fields $0.99 per 1K

Questions people ask

How much does Public Google Workspace Exporter: Sheets, Docs, Forms & Drive cost?

The published result rate depends on your Apify plan: $0.99 per 1,000 on Free, $0.82 per 1,000 on Starter, $0.66 per 1,000 on Scale, $0.49 per 1,000 on Business. So 10,000 results cost about $9.90 on the Free plan and $4.90 on Business, plus a start fee of $0.10 per run per GB of memory on Free. Platform usage is billed separately.

What data does Public Google Workspace Exporter: Sheets, Docs, Forms & Drive return?

Its published output schema lists 9 fields: recordType, title, name, sheetTitle, rowNumber, questionText, start, folderPathString, errorType. A listed field is not guaranteed to be filled in every row.

What input does Public Google Workspace Exporter: Sheets, Docs, Forms & Drive need?

Required: startUrls. Optional settings include mode, sheetTabs, sheetRange, detectHeaders, headerRow, sheetQuery.

How do I run Public Google Workspace Exporter: Sheets, Docs, Forms & Drive from Python or the API?

Use the Apify API client: in Python, ApifyClient(token).actor("xyrelith-data/google-workspace-public-exporter").call(run_input=...), then read the run's default dataset (run.default_dataset_id); in JavaScript the same call is client.actor("xyrelith-data/google-workspace-public-exporter").call(input). Without a client, POST the input JSON to https://api.apify.com/v2/actors/xyrelith-data~google-workspace-public-exporter/run-sync-get-dataset-items with your API token. Ready-to-paste code with the example input is on this page.

Sources

Actor updated 2026-11-21 Data synced 2026-11-21
Cite this page

Scraper Finder. "Public Google Workspace Exporter: Sheets, Docs, Forms & Drive." https://scraperfinder.com/catalogue/google-workspace-public-exporter/ (data checked 2026-11-21).

Run Public Google Workspace Exporter: Sheets, Docs, Forms & Drive

$0.99 per 1,000 results. Paste the example input above, set your target query, then export the dataset.

Open in Apify Store