Google Sheets Import & Export
Under maintenancePricing
Pay per usage
Import a Google Sheet range into a clean dataset, or export data (JSON/dataset) to a sheet. Service-account auth, no OAuth flow. Reliable, flat, AI-ready.
Pricing
Pay per usage
Rating
0.0
(0)
Developer
Radosław Szal
Maintained by CommunityActor stats
0
Bookmarked
1
Total users
0
Monthly active users
15 hours ago
Last modified
Categories
Share
import = read a sheet range into the dataset. export = write rows to a sheet.
The ID from the sheet URL: docs.google.com/spreadsheets/d//edit
e.g. 'Sheet1!A:Z' to import a whole area, or 'Sheet1!A1' as the export anchor.
Paste the full JSON key of a Google Cloud service account. Create it in GCP → IAM → Service Accounts → Keys, enable the Google Sheets API, and SHARE the spreadsheet with the account's email (client_email). Stored as a secret.
Import: use row 1 as field names. Off = columns become A, B, C…
Export: rows to write — array of objects (keys become the header) or array of arrays.
Export alternative to 'data': pull rows from an existing Apify dataset.
Optional explicit column order for object rows. Default = order first seen.
Export: append after existing rows instead of overwriting the range.
Export: write a header row of column names above the data (for object rows).
