Apify Dataset to Google Sheets Sync

Send bounded Apify dataset rows to a buyer-controlled Google Sheets webhook endpoint.

What this Actor does

Read rows from a supplied dataset or input array, map and batch them, then return an auditable delivery summary.

• Copy bounded Actor output into Google Sheets.
• Map selected fields before delivery.
• Review delivered and rejected row counts.

Who this is for

Operations teams, Analysts, Automation builders.

Input

• Demo mode is the safe default and emits one deterministic fixture.
• Live mode processes at most maxItems configured inputs.
• sourceDatasetId or items: bounded source rows.
• destinationWebhookUrl: buyer-controlled HTTPS endpoint, treated as secret.
• fieldMap and batchSize: optional delivery controls.

Output

The default dataset uses the Actor-specific schema in .actor/DATASET_SCHEMA.json. Key fields include sourceDatasetId, attemptedRows, deliveredRows, rejectedRows, batchCount, destinationType, fieldMapApplied, plus exact source, status, delta, confidence, warning, and fixture/live labels.

Data sources

• APIFY-DATASETS
• GOOGLE-SHEETS

These are the registered catalog source IDs. Live inputs may also include buyer-provided inline rows and a buyer-controlled HTTPS delivery endpoint; buyer inputs and credentials are not registered source IDs.

Demo run

Run examples/first-run.json. The row in examples/sample-output.json is labeled sourceStatus: fixture, isDemo: true, and is not live evidence.

Live-run behavior

Live mode processes only the configured Actor-specific inputs. Failures are returned as diagnostics or explicit errors; the runtime does not silently substitute unrelated source families.

Pricing

The runtime reads the effective Apify pay-per-event map after Actor.init() and adapts between the verified export-delivery and result-delivery events. It stops with an explicit configuration-drift error instead of emitting unmetered output. This package never defines or changes provider pricing.

Identity and visibility safety

This package targets only zentrafoundry/apify-dataset-to-google-sheets-sync with Actor ID t5CY8JU1efkV8k5cN. Any future release must find exactly one authenticated inventory match and abort on identity or visibility drift. Creating, cloning, upserting, duplicating, drafting, or privatizing the Actor is forbidden.

Limitations

• Live delivery requires a buyer-controlled HTTPS endpoint configured for the target Sheet.
• The Actor does not create Google credentials or log the destination URL.
• Local tests and fixtures do not prove an Apify build, live run, Store content update, or Store readback.

Responsible use

Use only data you are authorized to process. Respect source terms, robots policies, privacy rules, and applicable law. Never place credentials, cookies, tokens, or private account data in URLs or logs.

Support

When reporting a problem, include the run ID, sanitized input shape, expected result, and observed result. Do not include secrets or private data.