Google Sheets Import & Export: Sync Datasets, Update Rows
Pricing
Pay per event
Google Sheets Import & Export: Sync Datasets, Update Rows
Send any Apify dataset or JSON to Google Sheets: append, replace, or update rows by a unique key (price and stock monitoring). No OAuth: share the sheet once. Auto-retries on Google limits, one tab per day, dedupe, column picking. Also reads sheets back to JSON.
Pricing
Pay per event
Rating
5.0
(1)
Developer
Superior Actors
Maintained by CommunityActor stats
1
Bookmarked
2
Total users
1
Monthly active users
13 hours ago
Last modified
Categories
Share
Google Sheets Import & Export
Send any Apify dataset or JSON to Google Sheets, and read sheets back to JSON. Append new rows, update existing rows by a unique key, or replace the whole tab. Made for scrapers that run on a schedule: connect it once as an integration and every run lands in your sheet.
No Google login, no OAuth tokens that expire. Share your sheet once with the Actor's e-mail and it keeps working.
Setup (1 minute, once per sheet)
- Open your Google Sheet โ Share
- Add this e-mail as Editor:
- Paste the sheet link into Google Sheet and pick a dataset. Done.
If Google says the address has no Google account, share anyway: it is a service account, that's normal. If you forget to share, the run tells you exactly that.
Why this Actor
| ๐ Update rows by key | update mode changes rows in place (same url or id) and adds new ones. Your own columns (notes, formulas) stay untouched |
| ๐ Nothing expires | Access is a normal share, not an OAuth token. Scheduled runs don't die after a few weeks |
| ๐ก Retries Google limits | Rate limits (429) and Google outages are retried with backoff instead of failing the run |
| ๐งฎ Values stay correct | Numbers stay numbers, IDs keep leading zeros, big IDs don't get rounded, text starting with = is never run as a formula |
| ๐ Tab per day | Tab name Prices {date} creates a new tab every day |
| ๐งน Duplicates skipped | Rows whose key is already in the sheet are not added again (and not charged) |
| ๐งฉ Clean columns | Columns in the scraper's order, your column order kept, lists as wifi, pool in one cell, pick or drop columns |
| ๐ Big data | Written in chunks; the sheet is never half-empty during replace; clear error before writing if Google's 10M-cell limit would be hit |
Modes
| Mode | What it does | Typical use |
|---|---|---|
append | Adds rows at the end. New fields become new columns at the right | Leads, new listings, a log of every run |
update | Rows with the same unique key are overwritten, new keys added at the end | Price and stock monitoring, CRM-style lists |
replace | Overwrites the tab with the new data | "Current state" dashboards |
read | Sheet rows โ dataset items (header row = field names) | Feed a sheet into another Actor or an AI agent |
Use it after a scraper (integration)
- Open your scraper or task โ Integrations โ Connect Actor or Task โ choose this Actor
- Set the input:
Every successful scraper run now adds only new rows to the sheet.
Examples
| Goal | Input |
|---|---|
| Daily price monitor, one row per product, always up to date | "mode": "update", "deduplicateByField": "url" |
| Price history, one tab per day | "mode": "append", "sheetName": "Prices {date}" |
| Price history in one tab | "mode": "append", "addTimestamp": true |
| Hotel rates by date | "mode": "update", "deduplicateByField": "entityId,checkInDate" |
| Only some columns, in your order | "columnsOrder": ["name", "price", "url"], "onlyListedColumns": true |
| Drop nested noise | "excludeColumns": ["images", "reviews"] |
| Send rows from code or an AI agent | "rawData": [{"name": "A", "price": 10}] |
Ready-made tasks
Open one, change the inputs, and run or schedule it:
- Price Monitoring in Google Sheets: Update Rows by URL
- Export Apify Dataset to Google Sheets Daily (Tab per Day)
- Google Sheet to JSON API: Read Any Sheet
- Google Maps Leads to Google Sheets Without Duplicates
- Hotel Rate Tracker in Google Sheets: Daily Competitor Prices
- Flight Price Tracker in Google Sheets: Row per Route and Date
- App Store and Google Play Rankings to Google Sheets Daily
- JSON to Google Sheets via API or AI Agent: Upsert Rows
- Amazon Price Tracker in Google Sheets: Update by ASIN
- Google Rank Tracker in Google Sheets: Keyword Positions
Input
| Field | Description |
|---|---|
spreadsheetId | Sheet link or ID. A link with #gid= selects that tab |
mode | append, update, replace or read |
sheetName | Tab name, created if missing. {date}, {month}, {datetime} are replaced (UTC) |
datasetId | Source dataset. In integrations: {{resource.defaultDatasetId}} |
rawData | JSON array of objects, or array of arrays with a header row first |
limit, offset | Part of the dataset only |
deduplicateByField | Unique key column(s), comma-separated |
columnsOrder, onlyListedColumns, excludeColumns | Column selection and order. Nested fields use /: address/city |
arrayMode | join (default), columns (tags/0, tags/1), or json |
addTimestamp | Adds an exportedAt column with the run time |
parseValues | Let Google interpret values like typed by hand (dates, formulas). Off by default |
serviceAccountKey | Optional: your own service account JSON key instead of the shared e-mail |
Field names spreadsheetId, mode, datasetId, rawData, deduplicateByField, columnsOrder match the popular free Google Sheets actor, so switching usually means changing the Actor and sharing the sheet.
Output
Write modes save one summary item:
read mode saves one item per sheet row.
Pricing
| Event | Price |
|---|---|
| Run start | $0.005 |
| Row written (added or updated) or read | $0.01 per 1,000 rows |
| Skipped duplicates, empty runs | free |
A typical scraper-to-sheet sync of 500 rows costs about $0.01.
Limits
| Limit | Value |
|---|---|
| Cells per spreadsheet (Google) | 10,000,000. The run stops with a clear message before writing |
| Characters per cell (Google) | 50,000. Longer text is cut |
rawData size | 9 MB (Apify input limit). For more, use a dataset |
FAQ
Is my data safe? The Actor can open only the sheets you share with it, and only while they are shared. Remove the e-mail from Share to revoke access. Data is not stored anywhere except your sheet and your Apify run.
Can I use my own Google account instead? Yes: create a service account in Google Cloud, paste its JSON key into serviceAccountKey (stored encrypted), and share the sheet with that account's e-mail.
Does it work with Excel files in Drive? Only native Google Sheets. Open the .xlsx and use File โ Save as Google Sheets.
Can an AI agent use it? Yes, through the Apify MCP server: the agent passes rows in rawData. No OAuth screen to click through.
