Google Sheets Import & Export: Sync, Upsert, Dedupe
Pricing
from $0.01 / 1,000 row written or reads
Export any Apify dataset to Google Sheets after every scraper run: append, replace or upsert rows by key, skip duplicates, and add new fields as columns. Or import a sheet into a dataset. Uses your own Google service account, so there's no login to expire. $0.01 per 1,000 rows.
You can access the Google Sheets Import & Export: Sync, Upsert, Dedupe 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.
{ "openapi": "3.0.1", "info": { "version": "0.0", "x-build-id": "XIuuUxgxTcZNlXY9q" }, "servers": [ { "url": "https://api.apify.com/v2" } ], "paths": { "/acts/charlesmarkette~google-sheets-sync/run-sync-get-dataset-items": { "post": { "operationId": "run-sync-get-dataset-items-charlesmarkette-google-sheets-sync", "x-openai-isConsequential": false, "summary": "Executes an Actor, waits for its completion, and returns Actor's dataset items in response.", "tags": [ "Run Actor" ], "requestBody": { "required": true, "content": { "application/json": { "schema": { "$ref": "#/components/schemas/inputSchema" } } } }, "parameters": [ { "name": "token", "in": "query", "required": true, "schema": { "type": "string" }, "description": "Enter your Apify token here" } ], "responses": { "200": { "description": "OK" } } } }, "/acts/charlesmarkette~google-sheets-sync/runs": { "post": { "operationId": "runs-sync-charlesmarkette-google-sheets-sync", "x-openai-isConsequential": false, "summary": "Executes an Actor and returns information about the initiated run in response.", "tags": [ "Run Actor" ], "requestBody": { "required": true, "content": { "application/json": { "schema": { "$ref": "#/components/schemas/inputSchema" } } } }, "parameters": [ { "name": "token", "in": "query", "required": true, "schema": { "type": "string" }, "description": "Enter your Apify token here" } ], "responses": { "200": { "description": "OK", "content": { "application/json": { "schema": { "$ref": "#/components/schemas/runsResponseSchema" } } } } } } }, "/acts/charlesmarkette~google-sheets-sync/run-sync": { "post": { "operationId": "run-sync-charlesmarkette-google-sheets-sync", "x-openai-isConsequential": false, "summary": "Executes an Actor, waits for completion, and returns the OUTPUT from Key-value store in response.", "tags": [ "Run Actor" ], "requestBody": { "required": true, "content": { "application/json": { "schema": { "$ref": "#/components/schemas/inputSchema" } } } }, "parameters": [ { "name": "token", "in": "query", "required": true, "schema": { "type": "string" }, "description": "Enter your Apify token here" } ], "responses": { "200": { "description": "OK" } } } } }, "components": { "schemas": { "inputSchema": { "type": "object", "properties": { "spreadsheet": { "title": "Spreadsheet URL or ID", "type": "string", "description": "The Google Sheets URL (or its ID). Share the spreadsheet with your service account's client_email as an Editor. Required to read or write a sheet." }, "sheetName": { "title": "Sheet (tab) name", "type": "string", "description": "The tab to write to or read from. Created automatically if it doesn't exist.", "default": "Sheet1" }, "mode": { "title": "Mode", "enum": [ "append", "replace", "upsert", "read" ], "type": "string", "description": "What to do with the sheet.", "default": "append" }, "datasetId": { "title": "Dataset", "type": "string", "description": "The Apify dataset to export (e.g. the output of another Actor run). In an integration, use {{resource.defaultDatasetId}}. Not needed for Read mode." }, "serviceAccountKey": { "title": "Google service account key (JSON)", "type": "string", "description": "Paste the whole JSON key of a Google Cloud service account with the Google Sheets API enabled. It is stored encrypted. See the README for the 3-minute setup. Required to read or write a sheet." }, "keyFields": { "title": "Key fields", "type": "array", "description": "Field(s) that identify a row, e.g. 'url' or 'id'. Required for Upsert and for 'Skip rows already in the sheet'.", "items": { "type": "string" } }, "dedupeOnAppend": { "title": "Skip rows already in the sheet (append)", "type": "boolean", "description": "In Append mode, don't add rows whose key fields already exist in the sheet (or appear earlier in this run).", "default": false }, "columns": { "title": "Columns", "type": "array", "description": "Optional. Only these fields, in this order (after any columns already in the sheet). Nested fields are flattened like 'address/city'. Empty = all fields.", "items": { "type": "string" } }, "rawData": { "title": "Raw data (instead of a dataset)", "type": "array", "description": "Optional. An array of objects, or an array of arrays whose first row is the header." }, "valueInputOption": { "title": "How Google should interpret values", "enum": [ "RAW", "USER_ENTERED" ], "type": "string", "description": "RAW stores text exactly as given (numbers and true/false stay numbers and booleans). USER_ENTERED lets Google parse '=SUM(...)' formulas and locale-specific dates and numbers in your data. Either way, cells already in the sheet keep their formulas, dates and text.", "default": "RAW" }, "flattenSeparator": { "title": "Nested field separator", "type": "string", "description": "Separator used when flattening nested objects and arrays into columns.", "default": "/" }, "maxRows": { "title": "Max rows", "minimum": 1, "type": "integer", "description": "Optional cap on rows written (or read). In append mode it counts rows after duplicates are skipped; in upsert mode it counts distinct keys." } } }, "runsResponseSchema": { "type": "object", "properties": { "data": { "type": "object", "properties": { "id": { "type": "string" }, "actId": { "type": "string" }, "userId": { "type": "string" }, "startedAt": { "type": "string", "format": "date-time", "example": "2025-01-08T00:00:00.000Z" }, "finishedAt": { "type": "string", "format": "date-time", "example": "2025-01-08T00:00:00.000Z" }, "status": { "type": "string", "example": "READY" }, "meta": { "type": "object", "properties": { "origin": { "type": "string", "example": "API" }, "userAgent": { "type": "string" } } }, "stats": { "type": "object", "properties": { "inputBodyLen": { "type": "integer", "example": 2000 }, "rebootCount": { "type": "integer", "example": 0 }, "restartCount": { "type": "integer", "example": 0 }, "resurrectCount": { "type": "integer", "example": 0 }, "computeUnits": { "type": "integer", "example": 0 } } }, "options": { "type": "object", "properties": { "build": { "type": "string", "example": "latest" }, "timeoutSecs": { "type": "integer", "example": 300 }, "memoryMbytes": { "type": "integer", "example": 1024 }, "diskMbytes": { "type": "integer", "example": 2048 } } }, "buildId": { "type": "string" }, "defaultKeyValueStoreId": { "type": "string" }, "defaultDatasetId": { "type": "string" }, "defaultRequestQueueId": { "type": "string" }, "buildNumber": { "type": "string", "example": "1.0.0" }, "containerUrl": { "type": "string" }, "usage": { "type": "object", "properties": { "ACTOR_COMPUTE_UNITS": { "type": "integer", "example": 0 }, "DATASET_READS": { "type": "integer", "example": 0 }, "DATASET_WRITES": { "type": "integer", "example": 0 }, "KEY_VALUE_STORE_READS": { "type": "integer", "example": 0 }, "KEY_VALUE_STORE_WRITES": { "type": "integer", "example": 1 }, "KEY_VALUE_STORE_LISTS": { "type": "integer", "example": 0 }, "REQUEST_QUEUE_READS": { "type": "integer", "example": 0 }, "REQUEST_QUEUE_WRITES": { "type": "integer", "example": 0 }, "DATA_TRANSFER_INTERNAL_GBYTES": { "type": "integer", "example": 0 }, "DATA_TRANSFER_EXTERNAL_GBYTES": { "type": "integer", "example": 0 }, "PROXY_RESIDENTIAL_TRANSFER_GBYTES": { "type": "integer", "example": 0 }, "PROXY_SERPS": { "type": "integer", "example": 0 }, "PROXY_UNBLOCKER_UNITS": { "type": "integer", "example": 0 } } }, "usageTotalUsd": { "type": "number", "example": 0.00005 }, "usageUsd": { "type": "object", "properties": { "ACTOR_COMPUTE_UNITS": { "type": "integer", "example": 0 }, "DATASET_READS": { "type": "integer", "example": 0 }, "DATASET_WRITES": { "type": "integer", "example": 0 }, "KEY_VALUE_STORE_READS": { "type": "integer", "example": 0 }, "KEY_VALUE_STORE_WRITES": { "type": "number", "example": 0.00005 }, "KEY_VALUE_STORE_LISTS": { "type": "integer", "example": 0 }, "REQUEST_QUEUE_READS": { "type": "integer", "example": 0 }, "REQUEST_QUEUE_WRITES": { "type": "integer", "example": 0 }, "DATA_TRANSFER_INTERNAL_GBYTES": { "type": "integer", "example": 0 }, "DATA_TRANSFER_EXTERNAL_GBYTES": { "type": "integer", "example": 0 }, "PROXY_RESIDENTIAL_TRANSFER_GBYTES": { "type": "integer", "example": 0 }, "PROXY_SERPS": { "type": "integer", "example": 0 }, "PROXY_UNBLOCKER_UNITS": { "type": "integer", "example": 0 } } } } } } } } }}OpenAPI is a standard for designing and describing RESTful APIs, allowing developers to define API structure, endpoints, and data formats in a machine-readable way. It simplifies API development, integration, and documentation.
OpenAPI is effective when used with AI agents and GPTs by standardizing how these systems interact with various APIs, for reliable integrations and efficient communication.
By defining machine-readable API specifications, OpenAPI allows AI models like GPTs to understand and use varied data sources, improving accuracy. This accelerates development, reduces errors, and provides context-aware responses, making OpenAPI a core component for AI applications.
You can download the OpenAPI definitions for Google Sheets Import & Export: Sync, Upsert, Dedupe from the options below:
If you’d like to learn more about how OpenAPI powers GPTs, read our blog post.
You can also check out our other API clients: