Go to example tasks
Google Sheets: Public Spreadsheet to JSON
Created by
Tim Zinin
Read the included public spreadsheet export into JSON rows. Replace its URL with your published sheet and choose the header and row limits.
Public Google Sheets to JSON Data Scraperzinin/public-google-sheets-to-json
publishedUrl
tabGid
headers
rows
+15 fieldsTextNumberBooleanListObject
Input
Public CSV URLs(required):https://docs.google.com/spreadsheets/d/198Kd2vPvpEyCgYAJLmu53jW-uPaf6m6COkmv2stQzrM/export?format=csv
Header row:1
Maximum data rows per tab:10000
Infer simple types:false
Output fields
publishedUrl
tabGid
headers
rows
rowNumbers
rowCount
contentHash
types
sourceUrl
found
status
resultCount
partial
error
warnings
checkedAt
schemaVersion
syntheticFixture
redirectChain
Sign up on Apify01
Create your Apify account to access the Public Google Sheets to JSON Data Scraper.
Start the run02
The Actor will start running based on the input automatically.
Receive the output03
Monitor the progress in real-time. You will be notified as soon as your dataset is complete and ready for review.
Integrate into your workflow04
The final output is delivered in JSON, CSV, or Excel format, ready to be plugged into your workflow.
