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

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

Pricing

from $0.49 / 1,000 results

Go to Apify Store
Public Google Workspace Exporter: Sheets, Docs, Forms & Drive

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

Xyrelith Data

Maintained by Community

Actor stats

0

Bookmarked

2

Total users

1

Monthly active users

18 hours ago

Last modified

Features

Limited permissions

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 typeRecordsHighlights
Google SheetssheetRowEvery tab or chosen tabs by name/gid, typed values, header detection, A1 range, GViz query, optional formulas and hyperlinks
Google DocsdocumentPlain text, Markdown, word/character counts, paragraphs, headings, links and image metadata
Google SlidesslideOne record per slide with text, speaker notes, links and slide position
Google Formsform, formSection, formQuestionTitle, description, sections, question type, options, required flag, entry IDs and grid rows (responses are never read)
Drive foldersdriveFolder, driveFileRecursive listing with name, ID, MIME type, size when Google exposes it, modified time, view/download URLs and folder path
Public Calendarscalendar, calendarEventEvent title, start/end, location, description, recurrence, cancelled toggle and optional occurrence expansion
Bad or private linkserrorA 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

  1. Share the Google file or folder with Anyone with the link (Viewer is enough).
  2. Paste the link into Public Google links.
  3. 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

InputDefaultPurpose
modeautoAuto-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
detectHeaderstrueTurn a sheet row into field names
headerRow1Row used as the sheet header
sheetQuery–Google Visualization query such as select A,B where C > 10
includeFormulasfalseAdd per-cell formulas to sheet rows
includeHyperlinksfalseAdd per-cell links to sheet rows
includeSlideNotestrueKeep or drop speaker notes
folderMaxDepth3How many subfolder levels to walk
calendarFrom–Inclusive lower date bound
calendarTo–Inclusive upper date bound
calendarExpandRecurrencesfalseTurn RRULEs into individual occurrences
calendarMaxOccurrences100Occurrence cap per recurring event
calendarIncludeCancelledfalseKeep ICS events marked CANCELLED
maxItems1000Global record cap
emitErrorRecordstrueKeep or suppress error rows
requestTimeoutSecs30Per-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"
}

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.ics feed.

Limitations

  • Only content shared publicly or with "anyone with the link" is readable. A private file returns an error row; 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/…/edit share 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 TZID are returned as the ICS local time plus startTzid; 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 BYSETPOS are returned as the original recurrence string 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.