You can access the Google Sheets Integration 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

1from apify_client import ApifyClient
2
3# Initialize the ApifyClient with your Apify API token
4# Replace '<YOUR_API_TOKEN>' with your token.
5client = ApifyClient("<YOUR_API_TOKEN>")
6
7# Prepare the Actor input
8run_input = {
9    "operation": "READ",
10    "spreadsheetId": "https://docs.google.com/spreadsheets/d/1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms/edit",
11    "sheetName": "Class Data",
12    "range": "A1:E",
13}
14
15# Run the Actor and wait for it to finish
16run = client.actor("solutionssmart/google-sheets-integration").call(run_input=run_input)
17
18# Fetch and print Actor results from the run's dataset (if there are any)
19print(f"💾 Check your data here: https://console.apify.com/storage/datasets/{run.default_dataset_id}")
20for item in client.dataset(run.default_dataset_id).iterate_items():
21    print(item)
22
23# 📚 Want to learn more 📖? Go to → https://docs.apify.com/api/client/python/docs/quick-start

Google Sheets Integration: Import, Export & Sync Apify Data API in Python

The Apify API client for Python is the official library that allows you to use Google Sheets Integration API in Python, providing convenience functions and automatic retries on errors.

Install the apify-client

$pip install apify-client

Other API clients include:

Google Sheets Integration API in JavaScript

Google Sheets Integration API through CLI

Google Sheets Integration OpenAPI definition

Google Sheets Integration API

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

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

Google Sheets Io

devon_gtme/google-sheets-io

Import Apify datasets into Google Sheets, or read sheets back into a dataset - authenticated with a Google service account, so the connection never expires and scheduled pipelines never break. Append, replace or read. Flattens nested objects, stable headers, auto 429 backoff. Free.

Devon Kellar

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

Google Sheets Mcp

salesmart-srl/google-sheets-mcp

MCP server for Google Sheets integration. Read, write and format cells. Create spreadsheets and sheets. Append rows, clear ranges. Works with Claude, Cursor and any MCP-compatible AI assistant. Authenticate with Google Service Account.

Salesmart Srl

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

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.8K

4.8

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.

PowerAI

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 Sheets Import & Export — Free Reads, No OAuth

srd836/google-sheets-import-export

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.

David González