Pricing

from $0.10 / 1,000 row writtens

Try for free

Go to Apify Store

Google Sheets Export & Import

Try for free

Send any Apify dataset or JSON to a Google Sheet (append, append only new rows with dedupe, or replace with backup), or import a sheet tab into a dataset. Public sheets import with no credentials. Works as an integration after any scraper.

Pricing

from $0.10 / 1,000 row writtens

Rating

0.0

(0)

Developer

Brandon Ob

Actor stats

Bookmarked

Total users

Monthly active users

2 days ago

Last modified

Categories

You can access the Google Sheets Export & Import 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    "spreadsheet": "https://docs.google.com/spreadsheets/d/1AbCdEfGhIjKlMnOpQrStUvWxYz0123456789abcdEFG/edit",
12    "rawData": [
13        {
14            "company": "Acme Inc",
15            "website": "acme.com",
16            "city": "Austin",
17            "tags": [
18                "saas",
19                "b2b"
20            ]
21        },
22        {
23            "company": "Globex",
24            "website": "globex.com",
25            "city": "Denver",
26            "tags": [
27                "manufacturing"
28            ]
29        }
30    ]
31};
32
33// Run the Actor and wait for it to finish
34const run = await client.actor("adhistory/google-sheets-export-actor").call(input);
35
36// Fetch and print Actor results from the run's dataset (if any)
37console.log('Results from dataset');
38console.log(`💾 Check your data here: https://console.apify.com/storage/datasets/${run.defaultDatasetId}`);
39const { items } = await client.dataset(run.defaultDatasetId).listItems();
40items.forEach((item) => {
41    console.dir(item);
42});
43
44// 📚 Want to learn more 📖? Go to → https://docs.apify.com/api/client/js/docs

Google Sheets Export & Import API in JavaScript

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

Google Sheets Export & Import API through CLI

Google Sheets Export & Import OpenAPI definition

Google Sheets Export & Import API

Google Sheet Exporter

jupri/google-sheet-exporter

💫 Export Dataset to GoogleSheet

cat

849

4.9

(4)

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

Public Google Sheet scraper

advantageous_subcontra/public-google-sheet-scraper

Download data from a publicly available Google Sheet.

Fabian Maume

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

Airtable Exporter

jupri/airtable

💫 Export Dataset to Airtable

cat

209

1.0

(2)

📗 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

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

Firebase Firestore Import

danielwebr/firebase-firestore-import

This actor is designed to simplify the process of transferring data from an Apify dataset into a Firebase Firestore collection. Simply configure the actor with your Firebase credentials, Firestore collection ID, and dataset ID, and it will handle the rest, including optional data transformations.

Daniel Wébr

Google Sheets Import & Export: Sync Datasets, Update Rows

s_actors/google-sheets-import-export

Send any Apify dataset or JSON to Google Sheets: append, replace, or update rows by a unique key (price and stock monitoring). No OAuth: share the sheet once. Auto-retries on Google limits, one tab per day, dedupe, column picking. Also reads sheets back to JSON.