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

$echo '{
<  "spreadsheet": "https://docs.google.com/spreadsheets/d/1EZLnhDCfmhGUnlubmGE-WIfFie8KrJnJkKE2w9f-4AQ/edit",
<  "sheetName": "Demo",
<  "keyColumns": [
<    "sku"
<  ],
<  "columns": [
<    {
<      "name": "sku",
<      "type": "string",
<      "pattern": "[A-Z]{3}-\\\\d{3}"
<    },
<    {
<      "name": "qty",
<      "type": "integer",
<      "min": 0
<    },
<    {
<      "name": "price",
<      "type": "number",
<      "min": 0
<    },
<    {
<      "name": "active",
<      "type": "boolean"
<    },
<    {
<      "name": "updated",
<      "type": "date"
<    }
<  ],
<  "rows": [
<    {
<      "sku": "ABC-001",
<      "qty": 5,
<      "price": 9.5,
<      "active": true,
<      "updated": "2026-10-21"
<    },
<    {
<      "sku": "ABC-002",
<      "qty": 0,
<      "price": 12,
<      "active": false,
<      "updated": "2026-10-20"
<    }
<  ]
<}' |
<apify call kumo-data-tools/google-sheets-safe-upsert --silent --output-dataset

Google Sheets Upsert API for AI Agents & JSON API through CLI

The Apify CLI is the official tool that allows you to use Google Sheets Safe Upsert (Validated Diff) locally, providing convenience functions and automatic retries on errors.

Install Apify CLI

Using installation script (macOS/Linux):

$curl -fsSL https://apify.com/install-cli.sh | bash

Using installation script (Windows):

$irm https://apify.com/install-cli.ps1 | iex

Using Homebrew:

$brew install apify-cli

Using npm:

$npm install -g apify-cli

Other API clients include:

Google Sheets Safe Upsert (Validated Diff) API in Python

Google Sheets Safe Upsert (Validated Diff) API in JavaScript

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.