Pricing

from $5.00 / 1,000 sheet updateds

Try for free

Go to Apify Store

Dataset to Google Sheets — No OAuth

Try for free

Export any Apify dataset to Google Sheets: append or replace rows after every run, or straight from an AI agent over MCP. Share the sheet once with the Actor's e-mail; no OAuth, 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

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

Dataset Aggregate, Group By & Pivot

nerolabs/dataset-aggregate-pivot

Returns GROUP BY and pivot tables for any Apify dataset, file or Google Sheet by URL, or JSON array: count, sum, average, min, max, median per group, date buckets, pivot columns. Exports CSV/Excel, appends to a named dataset, posts to a webhook. Agent-ready: pay per event (x402, MCP), per input row.

Adam Pearce

Public Google Sheet scraper

advantageous_subcontra/public-google-sheet-scraper

Download data from a publicly available Google Sheet.

Fabian Maume

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

Dataset Cleaner & Exporter

nerolabs/dataset-cleaner-exporter

Returns a deduplicated, flattened and cleaned copy of any Apify dataset, file or Google Sheet by URL, or JSON array, plus CSV and Excel files, named-dataset append and webhook delivery. Inputs: source, dedup keys, flatten, cleaning options. Agent-ready: pay per event (x402, MCP), per cleaned record.

Adam Pearce

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)

LLM Dataset Processor

dusan.vystrcil/llm-dataset-processor

Allows you to process output of other actors or stored dataset with single LLM prompt. It's useful if you need to enrich data, summarize content, extract specific information, or manipulate data in a structured way using AI.

Dušan Vystrčil

157

Google Calendar Create Event (Tool)

sambehnke/google-calendar-create-event

AI agent using Google Calendar with Apify MCP Server(Model context protocol)- Create Google Calendar events using your own API credentials. Perfect for AI agents via MCP server integration. Schedule meetings, appointments & events automatically. Secure, fast, and works with mainstream LLMs.