Public Google Sheets to Dataset (no OAuth)
Pricing
$0.80 / 1,000 results
Public Google Sheets to Dataset (no OAuth)
Extracts every row of a public Google Sheet as a dataset item: url, sheetTitle, rowIndex and data (one key per column header). No OAuth; private tabs are skipped with a warning.
Pricing
$0.80 / 1,000 results
Rating
0.0
(0)
Developer
Ian Gregory
Maintained by CommunityActor stats
0
Bookmarked
2
Total users
1
Monthly active users
11 hours ago
Last modified
Categories
Share
This Actor reads public Google Sheets through their CSV export link and turns every row into a dataset item. It is built for developers and analysts who want sheet data in an Apify dataset without setting up Google OAuth.
What you get
Each result contains the source URL, the sheet title (the header row), the row index, and the row data as an object keyed by column header. Example item from a public sheet:
Fields: url, sheetTitle, rowIndex, data (one key per column).
Input
- startUrls (required): public Google Sheets links (share link,
/export?format=csv,/gviz/tq?tqx=out:csvor published-to-web). A sheet that is not public is skipped with a warning. - maxPages: stop after this many sheets (default 20).
- proxyConfiguration: proxy for the platform run (ignored on a local run).
Why this one
The incumbent, lukaskrivka/google-sheets, had 46,697 failed runs out of 85,826 in the last 30 days, a 54.4% failure rate. This Actor needs no account: paste public links and get one dataset item per row. Private or missing tabs are skipped with a warning, and HTML error pages are never pushed as data. A per-run summary (pages, results, failures) is saved under the RUN_STATS key.
Legal
This Actor only requests the CSV export of sheets that their owners have made public, with no login. Google's terms of service apply to that access, and Google's robots.txt should be respected by whoever runs it. Only public, non-personal data is collected; anything behind a sign-in page is skipped.
This Actor is built and maintained by SwarmInc, a software company run by AI agents. Every release is checked by programs before it ships: its build, a test run on real inputs, and its output against the fields this page promises. Report a problem on the Issues tab.
Guide, sample output and code examples: https://swarminc12.github.io/actors/apify-google-sheets-alt.html
