Pricing

from $0.01 / 1,000 rows

Try for free

Go to Apify Store

Google Sheets Import & Export: Sync Datasets, Update Rows

Try for free

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.

Pricing

from $0.01 / 1,000 rows

Rating

5.0

(1)

Developer

Superior Actors

Actor stats

Bookmarked

Total users

Monthly active users

6 days ago

Last modified

Categories

Integrations

Automation

Developer tools

You can access the Google Sheets Import & Export: Sync Datasets, Update Rows 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

1from apify_client import ApifyClient
2
3# Initialize the ApifyClient with your Apify API token
4# Replace '<YOUR_API_TOKEN>' with your token.
5client = ApifyClient("<YOUR_API_TOKEN>")
6
7# Prepare the Actor input
8run_input = {
9    "spreadsheetId": "https://docs.google.com/spreadsheets/d/1XEl1x1BNcQrfP1ZdDyBtvshMn7Pa50-I6eWy6etH9wk/edit",
10    "rawData": [
11        {
12            "product": "Wireless Mouse",
13            "price": 24.99,
14            "currency": "USD",
15            "inStock": True,
16            "url": "https://example.com/mouse",
17        },
18        {
19            "product": "USB-C Hub",
20            "price": 39.5,
21            "currency": "USD",
22            "inStock": False,
23            "url": "https://example.com/hub",
24        },
25        {
26            "product": "Laptop Stand",
27            "price": 29,
28            "currency": "USD",
29            "inStock": True,
30            "url": "https://example.com/stand",
31        },
32    ],
33}
34
35# Run the Actor and wait for it to finish
36run = client.actor("s_actors/google-sheets-import-export").call(run_input=run_input)
37
38# Fetch and print Actor results from the run's dataset (if there are any)
39print(f"💾 Check your data here: https://console.apify.com/storage/datasets/{run.default_dataset_id}")
40for item in client.dataset(run.default_dataset_id).iterate_items():
41    print(item)
42
43# 📚 Want to learn more 📖? Go to → https://docs.apify.com/api/client/python/docs/quick-start

Google Sheets Import & Export | Apify Dataset to Sheets API in Python

The Apify API client for Python is the official library that allows you to use Google Sheets Import & Export: Sync Datasets, Update Rows API in Python, providing convenience functions and automatic retries on errors.

Install the apify-client

$pip install apify-client

Other API clients include:

Google Sheets Import & Export: Sync Datasets, Update Rows API in JavaScript

Google Sheets Import & Export: Sync Datasets, Update Rows API through CLI

Google Sheets Import & Export: Sync Datasets, Update Rows OpenAPI definition

Google Sheets Import & Export: Sync Datasets, Update Rows API

Google Maps Scraper

compass/crawler-google-places

Extract data from thousands of Google Maps locations and businesses, including reviews, reviewer details, images, contact info, including full name, email, and job title, opening hours, prices & more. Export data, run via API, schedule and monitor runs, or integrate with other tools.

Compass

654K

4.7

(1,818)

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)

Home Depot Scraper: Inventory, Clearance & Price Tracker

s_actors/home-depot-scraper

Scrape Home Depot products with the price, clearance price and units on the shelf in each store near a ZIP code. Check stock of any item in nearby stores (a BrickSeek alternative) and get only-changes alerts: price drops, new clearance, back in stock.

Superior Actors

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

Telegram Channel Analytics: Stats, Growth & Fake Check

s_actors/telegram-channel-analytics

Telegram channel stats without login: exact subscribers, reach per post, ERR, growth history, ads and advertisers, fake-subscriber signals, best posting time. Compare channels, map a niche, check groups (members, online), export posts. A TGStat alternative with an API.

Superior Actors

Firestore Import

drobnikj/firestore-import

Imports dataset items to Firestone DB.

Jakub Drobník

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

Bulk Image Downloader & Google Images Scraper

s_actors/bulk-image-downloader

Download images in bulk: search Google Images with every filter (size, color, license, date), or paste image URLs, or take the image fields of any dataset. Full-size files in a ZIP with metadata, no duplicates, resize and convert for AI datasets. Scheduled runs fetch only new images.

Superior Actors