Pricing

from $0.02 / verified write

Try for free

Go to Apify Store

Google Sheets Safe Upsert (Validated Diff)

Try for free

Upsert JSON rows into a Google Sheets tab safely: typed schema validation, a cell-by-cell diff preview, and only the approved diff is written. Same operationId sent 10 times = written once. Made for AI agents, MCP clients and automations.

Pricing

from $0.02 / verified write

Rating

0.0

(0)

Developer

Kumo Data Tools

Actor stats

Bookmarked

Total users

Monthly active users

4 days ago

Last modified

Categories

You can access the Google Sheets Safe Upsert (Validated Diff) 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    "spreadsheet": "https://docs.google.com/spreadsheets/d/1EZLnhDCfmhGUnlubmGE-WIfFie8KrJnJkKE2w9f-4AQ/edit",
10    "sheetName": "Demo",
11    "keyColumns": ["sku"],
12    "columns": [
13        {
14            "name": "sku",
15            "type": "string",
16            "pattern": "[A-Z]{3}-\\d{3}",
17        },
18        {
19            "name": "qty",
20            "type": "integer",
21            "min": 0,
22        },
23        {
24            "name": "price",
25            "type": "number",
26            "min": 0,
27        },
28        {
29            "name": "active",
30            "type": "boolean",
31        },
32        {
33            "name": "updated",
34            "type": "date",
35        },
36    ],
37    "rows": [
38        {
39            "sku": "ABC-001",
40            "qty": 5,
41            "price": 9.5,
42            "active": True,
43            "updated": "2026-10-21",
44        },
45        {
46            "sku": "ABC-002",
47            "qty": 0,
48            "price": 12,
49            "active": False,
50            "updated": "2026-10-20",
51        },
52    ],
53}
54
55# Run the Actor and wait for it to finish
56run = client.actor("kumo-data-tools/google-sheets-safe-upsert").call(run_input=run_input)
57
58# Fetch and print Actor results from the run's dataset (if there are any)
59print(f"💾 Check your data here: https://console.apify.com/storage/datasets/{run.default_dataset_id}")
60for item in client.dataset(run.default_dataset_id).iterate_items():
61    print(item)
62
63# 📚 Want to learn more 📖? Go to → https://docs.apify.com/api/client/python/docs/quick-start

Google Sheets Upsert API for AI Agents & JSON API in Python

The Apify API client for Python is the official library that allows you to use Google Sheets Safe Upsert (Validated Diff) 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 Safe Upsert (Validated Diff) API in JavaScript

Google Sheets Safe Upsert (Validated Diff) API through CLI

Google Sheets Safe Upsert (Validated Diff) OpenAPI definition

Google Sheets Safe Upsert (Validated Diff) 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 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 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

Public Google Sheets to JSON Data Scraper

zinin/public-google-sheets-to-json

Convert public Google Sheets CSV tabs into JSON with preserved text, headers, row numbers, optional types and content hashes. Empty and partial tabs are free.

Tim Zinin

TikTok Trending Hashtags, Sounds & Creators — Creative Center

johnveds15/tiktok-trending-scraper

Scrapes TikTok Creative Center public data: trending hashtags, sounds, and creators by country and time window. No login required.

John Vedovino II

Google Sheets Export: Append, Upsert & Dedupe

codemagnet/google-sheets-export

Export Apify datasets or JSON to Google Sheets. Append, append only new rows, upsert by key, or replace with backup. Read tabs back into datasets.

Kirby Bookhart-Tsai

Google Jobs Scraper (Cheap, No Browser)

subimpact/google-jobs-scraper

Scrape Google Jobs listings by query and country: title, company, location, source (LinkedIn, Indeed...), posted date, salary, job type, description and apply links. No browser. $1.00 per 1,000 jobs plus Google SERP proxy usage.

subimpact

Google Sheets Import: Read Sheet Rows to JSON/CSV

ucchiii/google-sheets-import

Read rows from a Google Sheet into an Apify dataset (JSON/CSV): public link or your service account, tab/range, headers, number/boolean/date types. Empty input = free demo. $0.05 per 1,000 rows.

Actor Factory

Shopify & WooCommerce Product CSV Validator and Auto-Fixer

naricky/product-csv-import-validator

Pre-flight check for Shopify and WooCommerce product import CSV/XLSX files. Replays ~40 importer rules (Default Title trap, variation linking, duplicate SKUs, prices, image links, Excel mangling, mojibake), auto-fixes safe issues with a change log and splits importer-safe chunks.

Ricky Lee

AI Image Upscaler x4 – Anime & Photo (Real-ESRGAN)

kumo-data-tools/ai-image-upscaler-anime-photo

Upscale images 4x (or 2x) with Real-ESRGAN: a dedicated anime/illustration model for clean line art and a photo model for real-world pictures. PNG, JPG or WebP out, transparency kept. Pay per 512x512 input tile; failed images are free.