Pricing

from $0.35 / 1,000 results

Try for free

Go to Apify Store

Google Sheets Import Export

Try for free

Read rows from a Google Sheets tab or A1 range into an Apify dataset, or export any Actor's dataset to a sheet as an integration step: append, replace or append-only-new-rows (dedupe on key columns). Public sheets read without credentials; private sheets and writes need a service-account key.

Pricing

from $0.35 / 1,000 results

Rating

0.0

(0)

Developer

Axiom Works

Actor stats

Bookmarked

Total users

Monthly active users

8 days ago

Last modified

Categories

Integrations

Agents

Automation

You can access the Google Sheets Import Export 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    "spreadsheetUrl": "https://docs.google.com/spreadsheets/d/1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms/edit#gid=0",
12    "mode": "read",
13    "maxItems": 20
14};
15
16// Run the Actor and wait for it to finish
17const run = await client.actor("axiomworks/google-sheets-import-export").call(input);
18
19// Fetch and print Actor results from the run's dataset (if any)
20console.log('Results from dataset');
21console.log(`💾 Check your data here: https://console.apify.com/storage/datasets/${run.defaultDatasetId}`);
22const { items } = await client.dataset(run.defaultDatasetId).listItems();
23items.forEach((item) => {
24    console.dir(item);
25});
26
27// 📚 Want to learn more 📖? Go to → https://docs.apify.com/api/client/js/docs

Google Sheets Import Export: Read, Append, Dedupe API in JavaScript

The Apify API client for JavaScript is the official library that allows you to use Google Sheets Import Export 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 API in Python

Google Sheets Import Export API through CLI

Google Sheets Import Export OpenAPI definition

Google Sheets Import Export API

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

(7)

Save To S3

drinksight/save-to-s3

Designed to be run from an ACTOR.RUN.SUCCEEDED webhook, this actor downloads a task run's default dataset and saves it to an S3 bucket.

Richard Weaver

101

Public Google Sheet scraper

advantageous_subcontra/public-google-sheet-scraper

Download data from a publicly available Google Sheet.

Fabian Maume

Firestore Import

drobnikj/firestore-import

Imports dataset items to Firestone DB.

Jakub Drobník

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

(1)

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

Firestore Import

apify/firestore-import

Seamlessly import data from Apify datasets into Firebase Firestore database. This integration allows full control over document IDs, conflict resolution (overwrite, merge, skip), and data transformation using a custom JavaScript function.

Apify

5.0

(5)

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