Google Sheets Reader & Writer

Pricing

Rating

Developer

Actor stats

Categories

Share

Read any Google Sheet to structured JSON, or append rows from JSON to a sheet. No OAuth. No "This App Is Blocked" errors. Uses Google Service Account authentication — set up once, works forever.

Why this exists

The most popular Google Sheets actor on Apify fails ~52% of the time because Google blocks its unverified OAuth login screen. The developer has confirmed this is unsolvable with OAuth.

This actor uses Service Account authentication — the approach Google recommends for server-to-server access. No consent screens, no token expiry, no blocked apps.

Quick start

Reading a public sheet (no auth needed)

Set your sheet to File → Share → Anyone with the link → Viewer, then:

{
"spreadsheetId":"YOUR_SHEET_ID",
"mode":"read"
}

Reading a private sheet

{
"spreadsheetId":"YOUR_SHEET_ID",
"mode":"read",
"serviceAccountKey":"{ ... paste your service account JSON here ... }"
}

Appending rows

{
"spreadsheetId":"YOUR_SHEET_ID",
"mode":"append",
"serviceAccountKey":"{ ... paste your service account JSON here ... }",
"rows":[
{"name":"John Smith","email":"john@example.com","status":"active"},
{"name":"Jane Doe","email":"jane@example.com","status":"pending"}
]
}

How to find your Spreadsheet ID

From your Google Sheet URL:

https://docs.google.com/spreadsheets/d/1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgVE2upms/edit
 ↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑
 This is your spreadsheetId

Service Account setup (one-time, ~5 minutes)

Only needed for private sheets and append operations.

Step 1 — Create a Google Cloud project

1. Go to console.cloud.google.com
2. Click New Project, give it any name, click Create

Step 2 — Enable the Sheets API

1. In your project, go to APIs & Services → Library
2. Search for Google Sheets API, click it, click Enable

Step 3 — Create a Service Account

1. Go to APIs & Services → Credentials
2. Click Create Credentials → Service Account
3. Give it any name (e.g. apify-sheets), click Create and Continue
4. Skip the optional steps, click Done

Step 4 — Download the key

1. Click the service account you just created
2. Go to the Keys tab
3. Click Add Key → Create new key → JSON
4. A .json file downloads — open it and copy the entire contents

Step 5 — Share your sheet with the service account

1. Open your Google Sheet
2. Click Share
3. Paste the service account email (formatted as {sa-name}@{project-id}.iam.gserviceaccount.com)
4. Set role to Editor (for append) or Viewer (for read-only)
5. Click Send

Step 6 — Paste the JSON key into the actor input

Paste the full contents of the downloaded .json file into the serviceAccountKey field.

Input

Output

Read mode

{
"spreadsheetId":"1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgVE2upms",
"mode":"read",
"rowCount":150,
"columns":["name","email","status"],
"data":[
{"name":"John Smith","email":"john@example.com","status":"active"},
{"name":"Jane Doe","email":"jane@example.com","status":"pending"}
],
"status":"success",
"error":null
}

Append mode

{
"spreadsheetId":"1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgVE2upms",
"mode":"append",
"rowsAppended":2,
"updatedRange":"Sheet1!A152:C153",
"status":"success",
"error":null
}

Pricing

$0.003 per successful operation (pay-per-event pricing).

• Failed operations (auth errors, invalid IDs, inaccessible sheets) are not charged.
• 1,000 operations = $3.00
• 10,000 operations = $30.00

Limitations

• Append mode requires at least one existing row in the sheet to read column headers from. If the sheet is empty, column headers are taken from the keys of the first row in your input.
• Maximum sheet size is limited by Google Sheets' own 5 million cell limit.
• Service Account must be shared on the specific sheet — sharing at the Drive folder level is also supported.
• This actor does NOT use OAuth. It cannot access sheets you haven't explicitly shared with the service account email.

Related actors in this suite

Other tools by accurate_pouch that pair with Sheets for end-to-end workflows:

• Email Validator Pro — SMTP, disposable, catch-all, typo detection, deliverability score, Sheets export. $0.005/email.
• Broken Link Checker — Recursive crawl, sitemap, robots.txt parsing, webhook, Sheets export. $0.005/page.
• Lighthouse Auditor — PageSpeed Insights API, Core Web Vitals, deltas, competitor comparison, Sheets export. $0.005/audit.
• TheCrawler — Web scraper + LLM-powered structured extraction. AGPL-3.0, also on npm (thecrawler@0.1.1). $0.005/page.

Run on Apify

👁 Run on Apify

No setup needed. Click above to run in the cloud. $0.003 per operation.