Export public Google Sheet to JSON rows
Created by
Stas Persiianenko
Export a public Google Sheet to structured JSON rows with normalized columns, raw cells, row numbers, and sheet metadata.
Google Sheet Exporterautomation-lab/google-sheet-exporter
Row #
Source URL
Sheet ID
GID
+3 fieldsTextNumberBooleanListObject
Input
Sheet URLs or IDs(required)
url:https://docs.google.com/spreadsheets/d/1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms/edit#gid=0
Maximum rows per sheet:20
Include raw row arrays:true
Output fields
Row #
Source URL
Sheet ID
GID
Normalized columns
Raw row
Fetched at
Sign up on Apify01
Create your Apify account to access the Google Sheet Exporter.
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.
