Pricing

from $0.01 / 1,000 row writtens

Try for free

Go to Apify Store

Google Sheets Export: Apify Dataset to Sheets

Try for free

Write an Apify dataset, JSON URL or JSON array to a Google Sheets tab. Append, replace, upsert by key or append only new rows. New fields become new columns instead of breaking the run. Uses your own service account key; no Google sign-in prompt.

Pricing

from $0.01 / 1,000 row writtens

Rating

0.0

(0)

Developer

Plainsource

Actor stats

Bookmarked

Total users

Monthly active users

4 days ago

Last modified

Categories

You can access the Google Sheets Export: Apify Dataset to Sheets 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    "dryRun": true,
12    "rawData": [
13        {
14            "title": "Blue mug",
15            "price": {
16                "value": 12.5,
17                "currency": "EUR"
18            },
19            "tags": [
20                "kitchen",
21                "ceramic"
22            ],
23            "url": "https://example.com/p/1"
24        },
25        {
26            "title": "Green mug",
27            "price": {
28                "value": 13,
29                "currency": "EUR"
30            },
31            "tags": [
32                "kitchen"
33            ],
34            "url": "https://example.com/p/2",
35            "inStock": true
36        }
37    ]
38};
39
40// Run the Actor and wait for it to finish
41const run = await client.actor("plainsource/google-sheets-export").call(input);
42
43// Fetch and print Actor results from the run's dataset (if any)
44console.log('Results from dataset');
45console.log(`💾 Check your data here: https://console.apify.com/storage/datasets/${run.defaultDatasetId}`);
46const { items } = await client.dataset(run.defaultDatasetId).listItems();
47items.forEach((item) => {
48    console.dir(item);
49});
50
51// 📚 Want to learn more 📖? Go to → https://docs.apify.com/api/client/js/docs

Export Apify Data to Google Sheets: Append, Upsert API in JavaScript

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

Google Sheets Export: Apify Dataset to Sheets API through CLI

Google Sheets Export: Apify Dataset to Sheets OpenAPI definition

Google Sheets Export: Apify Dataset to Sheets 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)

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

Lighthouse Batch Audits & Regression Alerts

peerless_columbine/lighthouse-batch-audit-monitor

Audit public pages with Lighthouse13.5.0, export raw and HTML reports, and compare persistent category baselines.

tingyou333 zhuang

Google Sheets Import & Export – Read, Append & Dedupe Rows

openharvest/google-sheets-import-export

Google Sheets import and export for Apify: read any sheet into a dataset, or append, replace and dedupe-append dataset or JSON rows into Google Sheets. Service-account key (no OAuth pop-ups) or keyless read of public sheets. Connect any Actor via datasetId.

Enes Bulanık

Fillable PDF Form Data Extractor: Batch Forms to CSV & Excel

naricky/pdf-form-data-extractor

Merge hundreds of filled PDF forms (AcroForm and XFA) into one spreadsheet: one row per PDF, one column per field. Checkbox and radio values, stable column mapping, per-file status so one bad file never stops the batch, and a template-drift report that flags old form versions.

Ricky Lee

SiteVerdict — robots.txt & Sitemap Monitor

siteverdict/siteverdict-robots-sitemap-monitor

Catch SEO disasters before Google does: watches robots.txt, XML sitemaps and key pages for Disallow: /, noindex, canonical and status changes, sitemap URL drops and errors. Diffs vs last run, Slack/webhook alerts, HTML report.

Aman Thakran

SEO Audit API — On-Page Checks, Meta Tags, Headings & Schema

highbrow_fame/seo-audit-api

On-page SEO audit of any URL over plain HTTP: title, meta, canonical, robots, hreflang, headings, images alt, links, JSON-LD, redirects, a 0-100 score with issues. SEO Audit API.

yestrue

Google Sheets Export & Import

adhistory/google-sheets-export-actor

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.

Brandon Ob

Export Datasets to SFTP, FTP, Dropbox & Google Drive

charlesmarkette/dataset-delivery-export-to-sftp-ftp-dropbox-google-drive

Deliver any scraper's dataset as a CSV, JSON, JSONL or Excel file (optionally gzipped) to your own SFTP or FTPS server, Dropbox or Google Drive after every run. Atomic uploads, SFTP host-key pinning, retries, and one destination failing never blocks the others. $0.0045 per file delivered.

Charles Markette

US Walkability, Transit & Bike Score Extractor

dataspryva/us-walkability-transit-and-bike-score-extractor

Looks up Walk Score, Transit Score, and Bike Score for any US city or street address, returning each 0-100 score with its rating label and nearby amenity categories.