Pricing

from $0.50 / 1,000 row written (zero setup)s

Google Sheets Import & Export — No OAuth, No Token Expiry

Export any Apify dataset to Google Sheets, or read a sheet into a dataset. Authenticates with a Google service account — a 2-minute one-time setup that never expires, never needs re-consent, and never breaks mid-schedule. Built for scheduled scraper-to-sheet pipelines.

Pricing

from $0.50 / 1,000 row written (zero setup)s

Rating

0.0

(0)

Developer

Heim AI

Actor stats

Bookmarked

Total users

Monthly active users

2 days ago

Last modified

Google Sheets Import & Export — Service Account, No OAuth API through CLI

The Apify CLI is the official tool that allows you to use Google Sheets Import & Export — No OAuth, No Token Expiry locally, providing convenience functions and automatic retries on errors.

Install Apify CLI

Using installation script (macOS/Linux):

$curl -fsSL https://apify.com/install-cli.sh | bash

Using installation script (Windows):

$irm https://apify.com/install-cli.ps1 | iex

Using Homebrew:

$brew install apify-cli

Using npm:

$npm install -g apify-cli

Other API clients include:

Google Sheets Import & Export — No OAuth, No Token Expiry API in Python

Google Sheets Import & Export — No OAuth, No Token Expiry API in JavaScript

Google Sheets Import & Export — No OAuth, No Token Expiry OpenAPI definition

Google Sheets Import & Export — No OAuth, No Token Expiry API

Public Google Sheet scraper

advantageous_subcontra/public-google-sheet-scraper

Download data from a publicly available Google Sheet.

Fabian Maume

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.

Shawn Downs

Google Sheet Exporter

automation-lab/google-sheet-exporter

Export public Google Sheets to clean dataset rows with normalized headers, raw cells, sheet IDs, gids, and CSV/JSON automation outputs.

Stas Persiianenko

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 Sheet MCP SERVER

bhansalisoft/google-sheet-mcp-server

Google Sheet MCP SERVER for unique tool for Google Sheet integration with all functionality on Any AI Tool

bhansalisoft

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 Import & Export

lukaskrivka/google-sheets

Import data from datasets or JSON files to Google Sheets. Programmatically process data in Sheets. Easier and faster than the official Google Sheets API and perfect for importing data from scraping.

Lukáš Křivka

4.1K

4.8

Google Sheet Exporter

jupri/google-sheet-exporter

💫 Export Dataset to GoogleSheet

cat

838

4.9

Google Sheets MCP Server

constant_quadruped/google-sheets-mcp-server

MCP server for Google Sheets. AI agents can read, write, and manage spreadsheets. 14 tools: cell/range CRUD, formulas, batch operations, JSON export, and sheet tab management. Service account or API key auth.

Google Sheets MCP Server

powerai/google-sheets-mcp-server

Google Sheets MCP Server provides seamless access to Google Sheets API, enabling AI assistants to create, read, update, and manage Google Spreadsheets programmatically.