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.What it returns
9 fields from the published dataset schema. Export as JSON, CSV or Excel, or read the dataset through the Apify API.
recordTypetitlenamesheetTitlerowNumberquestionTextstartfolderPathStringerrorType
Input
| Setting | Type | Required | Default | What 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
| Setting | Type | Required | Default | What 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.
| Apify plan | Per 1,000 | 10,000 results | 100,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
Similar Actors
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,…
Google Workspace Marketplace Category Tracker
Track ranked apps in any Google Workspace Marketplace category. Returns app name, developer, rating, review count, pricing model, categories,…
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…
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…
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,…
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,…
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
- Public Google Workspace Exporter: Sheets, Docs, Forms & Drive on Apify Store
- Published build with input and output schema (JSON)
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.