Google Sheets Import: Read Rows from a Sheet avatar

Google Sheets Import: Read Rows from a Sheet

Pricing

from $0.03 / 1,000 read rows

Go to Apify Store
Google Sheets Import: Read Rows from a Sheet

Google Sheets Import: Read Rows from a Sheet

Returns the rows of a Google Sheet tab as an Apify dataset (JSON/CSV/Excel), one item per row with real numbers, booleans and dates: public link or your service account, tab/range, headers. Empty input = free demo.

Pricing

from $0.03 / 1,000 read rows

Rating

0.0

(0)

Developer

Actor Factory

Actor Factory

Maintained by Community

Actor stats

0

Bookmarked

2

Total users

1

Monthly active users

a day ago

Last modified

Features

Limited permissions

Share

Read Google Sheet rows into JSON/CSV, reliably

Returns the rows of any Google Sheet tab as an Apify dataset (export as JSON, CSV, Excel or via API) with real numbers, booleans and dates. Built to just work: retries on Google rate limits (429) and server errors, and when something is wrong it stops with a plain message ("sheet is not shared", "tab 'X' not found, tabs are: ...") instead of failing silently or returning nothing.

For developers, analysts and ops teams who keep input lists, keywords, URLs, prices or leads in a Google Sheet and want to feed them to scrapers, automations or AI pipelines.

  • No setup for public sheets: share as "Anyone with the link" and paste the URL, no credentials
  • Private sheets: use your own Google service account (the key is used only in memory and never logged or stored)
  • Clean data: header row to column names (duplicates and blanks fixed), numbers / booleans / dates converted, empty rows skipped, tab and range selectable

Example output (one dataset item per sheet row):

{ "Student Name": "Alexandra", "Gender": "Female", "Class Level": "4. Senior", "Home State": "CA",
"Major": "English", "Extracurricular Activity": "Drama Club" }

Price: $0.05 per 1,000 rows saved, charged per row ($0.00005 a row). Example: a 2,500-row sheet costs $0.125; a 300-row sheet costs $0.015. The $5 monthly free credit covers about 100,000 rows. Header rows, skipped empty rows and failed runs are not charged. Set a max charge per run to cap spend.

Free demo: leave the input empty and the Actor reads Google's public "Class Data" sample sheet (10 rows, not charged).

Input

FieldWhat it does
spreadsheetSheet URL or ID. A #gid= in the URL selects that tab.
serviceAccountKeyOptional. JSON key of your service account, for private sheets.
sheetName / sheetGidTab by name or by numeric gid. Default: the URL's gid, else the first tab.
rangeA1 range such as A1:F500, A:F, 2:100. Default: whole tab.
headerMode, skipTopRowsFirst row is the header (default) or no header (column_1, ...); skip title rows above it.
coerceTypes, coerceNumbers, coerceBooleans, coerceDates, dateFormatValue conversion. Empty cells are null. ZIP-style values with leading zeros and numbers over 15 digits stay text. 03/31/2026-style dates are converted only if you pick mdy or dmy.
skipEmptyRows, maxRowsDrop fully blank rows; stop after N data rows (default 10,000).
{ "spreadsheet": "https://docs.google.com/spreadsheets/d/1AbC.../edit#gid=0", "headerMode": "first", "maxRows": 5000 }

Public sheet in 30 seconds

In Google Sheets click Share > General access > Anyone with the link > Viewer, copy the URL into spreadsheet, run.

Private sheet (service account, about 5 minutes)

  1. In Google Cloud Console create or pick a project and enable the Google Sheets API.
  2. IAM & Admin > Service Accounts > Create service account (no roles needed), then Keys > Add key > JSON.
  3. Share your sheet with the account's client_email as Viewer.
  4. Paste the whole JSON file into Service account key.

Output

The default dataset has one item per sheet row. Run details are in the key-value store record RESULT: source, mode (public-csv or api), tab, columns, rows in sheet, rows saved, skipped empty rows, truncatedAtMaxRows and a warning if the tab was empty.

Common problems

  • "the spreadsheet is not shared publicly": set sharing to "Anyone with the link" (Viewer), or use a service account key.
  • "Tab 'X' not found. Tabs in this spreadsheet: ..." (service account): fix the name or use sheetGid.
  • Public sheet and tab by name: Google's name-based CSV endpoint can drop cells in columns that mix numbers and text. Use sheetGid (or the #gid= in the URL) for exact values, or use a service account key.
  • 403 with a service account: share the sheet with the client_email and check the Sheets API is enabled.
  • "Key creation is disabled": many Google Workspace organizations block service account keys (iam.disableServiceAccountKeyCreation). Ask your admin, or create the project with a personal Google account.
  • Dates read as text: only year-first dates (2026-03-31) are converted by default; choose mdy or dmy for slash dates.

Billing and privacy

You are charged only for rows saved to the dataset. Your key stays in memory for the run and is never written to logs, the dataset or the key-value store. Use a dedicated service account with access only to the sheets you need. The Actor only reads; it never writes to your sheet.

Pricing

Pay per event: $0.00005 per row ($0.05 per 1,000 rows), charged per row. The demo is free. On the Apify Free plan, the $5 of monthly platform credit covers about 100,000 rows a month — enough to try it on real data.

If this Actor saved you time, a rating on the Store helps others find it.

More tools from the same developer