Pricing

from $5.00 / 1,000 sheet updateds

Try for free

Go to Apify Store

Dataset to Google Sheets — No OAuth

Try for free

Append or replace rows in your Google Sheet from any Apify dataset. Share the sheet once with the Actor's e-mail; no Google login, no tokens that expire.

Pricing

from $5.00 / 1,000 sheet updateds

Rating

0.0

(0)

Developer

Duffy Radmilović

Actor stats

Bookmarked

Total users

Monthly active users

17 hours ago

Last modified

Categories

Integrations

Developer tools

You can access the Dataset to Google Sheets — 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    "spreadsheetUrl": "https://docs.google.com/spreadsheets/d/PASTE-YOUR-SHEET-ID/edit",
12    "rows": [
13        {
14            "url": "https://example.com/a",
15            "price": 10
16        },
17        {
18            "url": "https://example.com/b",
19            "price": 12
20        }
21    ]
22};
23
24// Run the Actor and wait for it to finish
25const run = await client.actor("duffy1990/dataset-to-google-sheets").call(input);
26
27// Fetch and print Actor results from the run's dataset (if any)
28console.log('Results from dataset');
29console.log(`💾 Check your data here: https://console.apify.com/storage/datasets/${run.defaultDatasetId}`);
30const { items } = await client.dataset(run.defaultDatasetId).listItems();
31items.forEach((item) => {
32    console.dir(item);
33});
34
35// 📚 Want to learn more 📖? Go to → https://docs.apify.com/api/client/js/docs

Export Apify Dataset to Google Sheets – No OAuth API in JavaScript

The Apify API client for JavaScript is the official library that allows you to use Dataset to Google Sheets — 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:

Dataset to Google Sheets — No OAuth API in Python

Dataset to Google Sheets — No OAuth API through CLI

Dataset to Google Sheets — No OAuth OpenAPI definition

Dataset to Google Sheets — 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

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

Reddit Post & Modqueue Scraper - Community Intel

harvestlab/reddit-scraper

Collect Reddit posts, comments, subreddit feeds, search results, and moderation queues without OAuth for public data. Use it for social listening, community health, and topic analysis.

Nick

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)

Coinbase API Scraper

publicmoney/coinbase-scraper

Extract live Coinbase Exchange prices for any product with no API key or OAuth: last trade, best bid and ask, 24h high, low and base volume, and the exchange timestamp, off the order book. Export data, run via API, schedule and monitor runs, or integrate with other tools.

Public Money

5.0

(1)

Reliable Google Sheets Bridge

groundedvisionmedia/reliable-sheets-bridge

Two-way Apify dataset ↔ Google Sheets transfers with your service account. Append, replace, or strict composite-key upsert with Limited Permissions, deterministic nested JSON, safe row limits, and credential-safe errors.

Michael Bennett

Google Sheets Writer — export datasets to Sheets

leonguyen2808/google-sheets-writer

Export any Apify dataset to Google Sheets, or read a tab back. Service account, OAuth refresh token, or a one-minute pasted access token. Every precondition checked before the first cell, and values written RAW so a scraped "=…" never becomes a formula.

Leo Nguyen

Google Sheets Integration

solutionssmart/google-sheets-integration

Synchronize Apify datasets and Google Sheets with secure read, append, replace, upsert, delete, and filter operations.

Solutions Smart

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

TikTok Shop Scraper [NO COOKIES] ✅

unseenuser/TikTok-Shop-Scraper

Extract product data, reviews, seller info, creator affiliates, and GMV/sales estimates from TikTok Shop at scale. Filter by category, price range, and country (US, UK). Built for dropshippers, e-commerce sellers, and DTC brands hunting trending products before they go viral.