# Google Sheets Import & Export via Apify (stableapify.dev)

> Google Sheets Import & Export via Apify (stableapify.dev) is a paid API for AI agents from stableapify.dev, paid per call via x402, $0.01/call, status unknown (last checked 2026-09-14).

Starts the lukaskrivka/google-sheets Apify actor to import data from datasets or JSON files into Google Sheets, or export and programmatically process spreadsheet data.

## Facts

- Endpoint: POST https://stableapify.dev/api/actors/lukaskrivka/google-sheets/call
- Price: $0.01/call
- Payment: x402
- Status: unknown
- Last checked: 2026-09-14
- Activations on Zero: 0
- Tags: x402
- Canonical page: https://www.zero.xyz/c/google-sheets-import-export-via-apify-stableapify-dev-fda10e49
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_7MefVxIvilCL7QT_VCK_0

Status and success rate cover calls made through Zero and Zero's own probes. Third-party monitors may report differently.

## How to call it through Zero

Zero handles the 402 payment challenge and records the run. With the Zero CLI installed (`npm i -g @zeroxyz/cli`):

```sh
zero fetch --capability google-sheets-import-export-via-apify-stableapify-dev-fda10e49 -d '<json body>'
```

Example prompt: Take the results from my Apify dataset (ID: Huj7s5180scFRjlrg) and import them into my Google Sheet at https://docs.google.com/spreadsheets/d/my-sheet-id, using 256MB memory and capping at 100 items.

## When to prefer this

Choose this endpoint when you need a simple, pay-per-call way to move Apify dataset or JSON data into Google Sheets without setting up OAuth credentials or wrestling with the official Google Sheets API quota limits. It is especially useful for agents that already run Apify actors and want to pipe results directly into a spreadsheet for human review or downstream processing.

## Known failure modes

- Invalid or inaccessible Google Sheets URL — actor fails to write, returns error status
- Dataset ID not found or empty — actor starts but produces no rows
- Insufficient memory allocation causes actor to crash mid-run
- Google Sheets permissions not granted to the actor's service account — write fails
- Payment failure (x402) if wallet has insufficient USDC balance
- Actor run times out for very large datasets exceeding memory limits

## How this service works

Start the "Google Sheets Import & Export" Apify actor (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 pe…

## Output

Returns an actor run object containing the run ID, status (e.g. READY), actor ID, start timestamp, estimated usage cost in USD, default dataset ID, and a JWT token used to poll results from the run's dataset via a sibling endpoint.

## Example request

```json
{
 "input": {
  "username": "neal-mohan",
  "includeEmail": false
 },
 "options": {
  "memory": 256,
  "maxItems": 100
 }
}
```

## Request schema (JSON Schema)

```json
{
 "type": "object",
 "properties": {
  "input": {
   "type": "object",
   "required": [
    "mode",
    "limit",
    "offset",
    "publicSpreadsheet",
    "tokensStore"
   ],
   "properties": {
    "mode": {
     "enum": [
      "append",
      "replace",
      "modify",
      "read",
      "load backup"
     ],
     "type": "string",
     "default": "append",
     "description": "What should the actor do"
    },
    "limit": {
     "type": "integer",
     "default": 250000,
     "maximum": 9007199254740991,
     "minimum": 0,
     "description": "Number of items to take from the dataset. The default is 250000."
    },
    "range": {
     "type": "string",
     "description": "Range of the spreadsheet in A1 notation where the actor should operate. Default is the first sheet."
    },
    "offset": {
     "type": "integer",
     "default": 0,
     "maximum": 9007199254740991,
     "minimum": 0,
     "description": "Number of items to skip from the dataset. Default is 0."
    },
    "rawData": {
     "type": "object",
     "description": "Raw data JSON array. Can be array of arrays for direct row import or arrays of objects.",
     "propertyNames": {
      "type": "string"
     },
     "additionalProperties": {}
    },
    "datasetId": {
     "type": "string",
     "description": "Dataset ID where the new data will be loaded from"
    },
    "backupStore": {
     "type": "string",
     "description": "Id of the key-value store where the backup you want to load is located. Can only be used if mode is 'load-backup'"
    },
    "tokensStore": {
     "type": "string",
     "default": "google-oauth-tokens",
     "description": "Key-value store where your Google OAuth tokens will be stored so you don't have to authorize every time again. By default it is google-oauth-tokens"
    },
    "columnsOrder": {
     "type": "array",
     "items": {
      "type": "string"
     },
     "description": "Array of keys. First sorts the columns by provided keys. The rest is sorted alphabetically."
    },
    "createBackup": {
     "type": "boolean",
     "description": "Old rows from your spreadsheet will be saved to the default key-value store before importing new rows."
    },
    "spreadsheetId": {
     "type": "string",
     "description": "Id of the spreadsheet from where the old data will be loaded"
    },
    "googleCredentials": {
     "type": "object",
     "description": "If you want to use this actor locally or with your own version, you have to provide your own cred
… (truncated)
```

## More

- Live health (JSON, refreshed every minute): https://www.zero.xyz/c/google-sheets-import-export-via-apify-stableapify-dev-fda10e49/health.json
- [Zero catalog index](https://www.zero.xyz/llms.txt)
- [Other services from stableapify.dev](https://www.zero.xyz/host/stableapify.dev/llms.txt)