Google Sheets Import: Public Sheet to Dataset
Pricing
$0.80 / 1,000 results
Google Sheets Import: Public Sheet to Dataset
Imports every row of a public Google Sheet into a dataset (url, sheetTitle, rowIndex, data with one key per column header), with 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
17 days ago
Last modified
Categories
Features
Share
This Actor imports public Google Sheets into an Apify dataset. It reads each sheet through its CSV export link, with no Google OAuth, and turns every row into a dataset item. It is for developers, analysts and ops teams who want live sheet data in a dataset they can pipe into other Actors, APIs or reports.
Use cases
- A growth marketer pulls a shared lead-list sheet into a dataset every morning, so the outreach workflow starts from the latest rows.
- A data analyst imports a public research or statistics sheet weekly, to track changes in the numbers before updating a report.
- A developer feeds a team-maintained "config" sheet into a pipeline on every deploy, without managing Google credentials.
- An operations manager snapshots a published price or inventory sheet daily, to keep a history of changes.
- A founder checks a batch of public sheet links in one run, to see which are still shared and which have gone private.
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:
{"url": "https://docs.google.com/spreadsheets/d/1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms/export?format=csv&gid=0","sheetTitle": "Student Name, Gender, Class Level, Home State, Major, Extracurricular Activity","rowIndex": 1,"data": {"Student Name": "Andrew","Gender": "Male","Class Level": "1. Freshman","Home State": "SD","Major": "Math","Extracurricular Activity": "Lacrosse"}}
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. It reads sheets only; it does not write to them. 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
Questions: https://api.gregswarm.duckdns.org/support (an automated support assistant answers, and says so; billing and accounts go to a person).