Public Google Workspace Exporter: Sheets, Docs, Forms & Drive
Pricing
from $0.49 / 1,000 results
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.
Pricing
from $0.49 / 1,000 results
Rating
0.0
(0)
Developer
Xyrelith Data
Maintained by CommunityActor stats
0
Bookmarked
2
Total users
1
Monthly active users
18 hours ago
Last modified
Categories
Features
Share
Public Google Workspace Exporter
Turn links that are already shared with "anyone with the link" into a clean dataset — without OAuth, a service account, an API key or a proxy setup.
Paste a mix of Google Sheets, Docs, Slides, Forms, Drive folder and Calendar links. The actor detects each URL, fetches the public representation Google serves, and pushes one dataset with record families for each product.
What you get
| Link type | Records | Highlights |
|---|---|---|
| Google Sheets | sheetRow | Every tab or chosen tabs by name/gid, typed values, header detection, A1 range, GViz query, optional formulas and hyperlinks |
| Google Docs | document | Plain text, Markdown, word/character counts, paragraphs, headings, links and image metadata |
| Google Slides | slide | One record per slide with text, speaker notes, links and slide position |
| Google Forms | form, formSection, formQuestion | Title, description, sections, question type, options, required flag, entry IDs and grid rows (responses are never read) |
| Drive folders | driveFolder, driveFile | Recursive listing with name, ID, MIME type, size when Google exposes it, modified time, view/download URLs and folder path |
| Public Calendars | calendar, calendarEvent | Event title, start/end, location, description, recurrence, cancelled toggle and optional occurrence expansion |
| Bad or private links | error | A readable row instead of a silent empty run |
Every record carries recordType, sourceUrl and scrapedAt (UTC ISO). Empty fields are omitted,
so the dataset never contains null, "", [] or {}.
Quick start
- Share the Google file or folder with Anyone with the link (Viewer is enough).
- Paste the link into Public Google links.
- Run the actor. Mix as many links as you need.
Example input:
{"mode": "auto","startUrls": ["https://docs.google.com/spreadsheets/d/1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms/edit","https://docs.google.com/document/d/1y5QhCZpn3XcaosbP3wAEtoNGluLHHLzvateNZNAI6Ek/edit","https://drive.google.com/drive/folders/1LNkLh6Z10oFq2XsuKedRQaYjzc-CYj7C","https://calendar.google.com/calendar/ical/en.usa%23holiday%40group.v.calendar.google.com/public/basic.ics"],"maxItems": 500}
Inputs
| Input | Default | Purpose |
|---|---|---|
mode | auto | Auto-detect all links or force one product |
startUrls | ["https://docs.google.com/spreadsheets/d/1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms/edit"] | Required list of public Google links |
sheetTabs | – | Tab names or numeric gids; empty means every tab |
sheetRange | – | A1 range applied to each selected tab |
detectHeaders | true | Turn a sheet row into field names |
headerRow | 1 | Row used as the sheet header |
sheetQuery | – | Google Visualization query such as select A,B where C > 10 |
includeFormulas | false | Add per-cell formulas to sheet rows |
includeHyperlinks | false | Add per-cell links to sheet rows |
includeSlideNotes | true | Keep or drop speaker notes |
folderMaxDepth | 3 | How many subfolder levels to walk |
calendarFrom | – | Inclusive lower date bound |
calendarTo | – | Inclusive upper date bound |
calendarExpandRecurrences | false | Turn RRULEs into individual occurrences |
calendarMaxOccurrences | 100 | Occurrence cap per recurring event |
calendarIncludeCancelled | false | Keep ICS events marked CANCELLED |
maxItems | 1000 | Global record cap |
emitErrorRecords | true | Keep or suppress error rows |
requestTimeoutSecs | 30 | Per-request timeout |
Output examples
A typed sheet row:
{"recordType": "sheetRow","spreadsheetId": "1Bxi…","spreadsheetTitle": "Example Spreadsheet","sheetTitle": "Class Data","rowNumber": 2,"values": {"Student Name": "Alexandra","Gender": "Female","Class Level": "4. Senior","Home State": "CA","Major": "English","Extracurricular Activity": "Drama Club"},"sourceUrl": "https://docs.google.com/spreadsheets/d/…/edit","scrapedAt": "2026-11-17T02:00:00+00:00"}
A folder entry:
{"recordType": "driveFile","driveId": "1ndpRegCxnAXJ8-3kr4DeVZynqUCWm7nT","name": "attackers_prog-1.png","mimeType": "image/png","size": 224859,"modifiedTime": "2021-02-08T13:55:20+00:00","isFolder": false,"parentFolderId": "1LNkLh6Z10oFq2XsuKedRQaYjzc-CYj7C","folderPath": ["Villa Article"],"folderPathString": "Villa Article","depth": 1,"viewUrl": "https://drive.google.com/file/d/1ndpRegCxnAXJ8-3kr4DeVZynqUCWm7nT/view","downloadUrl": "https://drive.google.com/uc?export=download&id=1ndpRegCxnAXJ8-3kr4DeVZynqUCWm7nT"}
Notes on public links
Google serves different public endpoints per product, and this actor uses the widest one it can reach anonymously:
- Sheets: XLSX export for all tabs with typed values; Google Visualization JSON for gid/query/range selections.
- Docs: TXT, Markdown and HTML exports; image payloads stay out of the dataset, but their MIME type, alt text and byte size are listed.
- Slides: PPTX export, with slide text and notes read from the presentation package.
- Forms: the public responder page's
FB_PUBLIC_LOAD_DATA_definition. The actor never submits a response. - Drive: the folder page's rich JSON for the first entries plus the public embedded listing for the full folder, merged by file ID.
- Calendars: the public
basic.icsfeed.
Limitations
- Only content shared publicly or with "anyone with the link" is readable. A private file returns an
errorrow; it is not bypassed. - "Publish to web" links that use the
/d/e/…form are view-only HTML pages and do not expose the export endpoints used here. Use the normal/d/…/editshare link instead. - Google exposes byte sizes for the first entries of a Drive folder; later entries in a very large
folder are listed without
size. - Docs images are embedded as data URIs in Google's export. The actor reports their metadata, not the bytes.
- Forms are read-only. Submitting answers is intentionally out of scope.
- Calendar times with a
TZIDare returned as the ICS local time plusstartTzid; UTC (Z) values are normalised to an ISO timestamp with an offset. - Recurrence expansion covers DAILY, WEEKLY, MONTHLY and YEARLY FREQ with INTERVAL, COUNT, UNTIL,
BYDAY, BYMONTH and BYMONTHDAY. Complex rules such as
BYSETPOSare returned as the originalrecurrencestring without expansion.
FAQ
Do I need a Google account or API key? No. Every request is an anonymous HTTPS GET.
Does it use a proxy? No proxy is needed. Requests go directly from the actor.
Can I export several files at once? Yes. Put every public link in startUrls; one bad link does
not stop the others.
Can I choose only some tabs? Yes. Use tab names (Orders, Summary) or numeric gids (0,
123456789) in sheetTabs.
Does it download Drive files? No. It exports metadata and view/download links. Downloading file bytes is a separate job.
Are my form responses read? No. The actor reads the public question definition only.