Pricing

$1.00 / 1,000 row writtens

Try for free

Go to Apify Store

📗 Google Sheets Import & Export — Free Reads, No OAuth

Try for free

Reading is FREE: pull any link-shared Google Sheet into a dataset with zero setup — no API key, no OAuth, no Google Cloud project, no card. Add a service account key to write: append, replace or upsert with deduplication, straight from any Apify dataset. You only pay for rows written — $1 per 1,000.

Pricing

$1.00 / 1,000 row writtens

Rating

0.0

(0)

Developer

David González

Actor stats

Bookmarked

Total users

Monthly active users

a month ago

Last modified

Categories

Integrations

Automation

Developer tools

You can access the 📗 Google Sheets Import & Export — Free Reads, No OAuth programmatically from your own applications by using the Apify API. You can also choose the language preference from below. To use the Apify API, you’ll need an Apify account and your API token, found in API & Integrations in Apify Console.

Python

JavaScript

CLI

OpenAPI

HTTP

MCP

1import { ApifyClient } from 'apify-client';
2
3// Initialize the ApifyClient with your Apify API token
4// Replace the '<YOUR_API_TOKEN>' with your token
5const client = new ApifyClient({
6    token: '<YOUR_API_TOKEN>',
7});
8
9// Prepare Actor input
10const input = {
11    "spreadsheetId": "https://docs.google.com/spreadsheets/d/1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms/edit",
12    "mode": "read"
13};
14
15// Run the Actor and wait for it to finish
16const run = await client.actor("srd836/google-sheets-import-export").call(input);
17
18// Fetch and print Actor results from the run's dataset (if any)
19console.log('Results from dataset');
20console.log(`💾 Check your data here: https://console.apify.com/storage/datasets/${run.defaultDatasetId}`);
21const { items } = await client.dataset(run.defaultDatasetId).listItems();
22items.forEach((item) => {
23    console.dir(item);
24});
25
26// 📚 Want to learn more 📖? Go to → https://docs.apify.com/api/client/js/docs

Google Sheets Import & Export API - No OAuth API in JavaScript

The Apify API client for JavaScript is the official library that allows you to use 📗 Google Sheets Import & Export — Free Reads, No OAuth API in JavaScript or TypeScript, providing convenience functions and automatic retries on errors.

Install the apify-client

$npm install apify-client

Other API clients include:

📗 Google Sheets Import & Export — Free Reads, No OAuth API in Python

📗 Google Sheets Import & Export — Free Reads, No OAuth API through CLI

📗 Google Sheets Import & Export — Free Reads, No OAuth OpenAPI definition

📗 Google Sheets Import & Export — Free Reads, No OAuth API

Google Sheets Import & Export: No OAuth, 1,000 Rows Free

bridgeworks/sheets-bridge

Export any Apify dataset to Google Sheets, or import a sheet into a dataset, using your own service account: no OAuth screen, no expiring tokens. The first 1,000 rows of every run are free. Append, replace, or upsert rows. Works as a run integration on any scraper.

Bridgeworks

Google Sheets Import & Export

cypherstone/google-sheets-import-export

Read a Google Sheet into a dataset (public sheets need no key) and write datasets or JSON back - append, replace, or upsert - using a service account, with no interactive OAuth and automatic rate-limit retries.

Jeff Ralston

Google Sheets Scraper API - Sheet to JSON, No OAuth

vonsensey/google-sheets-scraper-api

Used by ops teams and no-code pipelines that need a Google Sheet as an API. Google Sheets scraper returning typed JSON rows with no Google sign-in, no OAuth and no Drive prompt. Link-shared sheets work from the URL alone. On a schedule it bills only the rows that actually changed.

Blackcube

Sheets Writer - No Google Verification Needed

kasimba/sheets-writer

Write any Apify dataset or JSON array to a Google Sheet using a service account - no OAuth consent screen, no Google app verification, no token that expires after a few days. Share your sheet with the service account email once; every write after that just works.

John J. K. Omolo

Google Sheets Reader & Writer

accurate_pouch/google-sheets-rw

Read any Google Sheet to JSON or write rows to a sheet — via Service Account auth. No OAuth blocking, no failed logins. Supports read, append, replace, modify, and backup modes. Includes safe replace, dry run, auto-create tab, and rate limit retry.

Manchitt Sanan

Google Sheets Export & Scraper

sourabhbgp/google-sheets-export

Export any public Google Sheet to flat JSON rows, a full xlsx workbook, or both. Typed values, multi-tab, hyperlinks and formulas optional. No Google Cloud project, no OAuth, no API key — just paste a sharing URL.

Sourabh Kumar

Google Sheets Import & Export — Fast, Reliable Sync

surefetch/google-sheets

Import Apify datasets, JSON or CSV into Google Sheets and export sheets back to JSON. Append, replace and read modes. Built for reliability: automatic retries, exponential backoff, no OAuth tokens that expire.

Jonas Eckl

1.0

Dataset → Google Sheets Incremental Sync

starshaped_bullsnake/dataset-google-sheets-incremental-sync

Sync Apify Dataset rows to Google Sheets and automatically remember the last synced Dataset offset. Also supports append, replace, and upsert.

Starshape Tools

Catalog Export Dry-Run (no Google login)

zentrafoundry/apify-dataset-to-google-sheets-sync

Formats a public catalog as export rows (Try is Allbirds). Does not write Google Sheets — no OAuth. $0.002 / row.

Zentra

Google Sheets Import & Export — Reliable Bridge

lizaraco/google-sheets-import-export

Read Google Sheets to datasets and write rows back — append or overwrite — with quota-aware batching and retries. Your own credentials (service account or OAuth): your data never touches anyone else's account. Public sheets read with no credentials at all.