Under maintenance

Pricing

Pay per usage

Try for free

Go to Apify Store

Google Sheets Import & Export

Under maintenance

Try for free

Import a Google Sheet range into a clean dataset, or export data (JSON/dataset) to a sheet. Service-account auth, no OAuth flow. Reliable, flat, AI-ready.

Pricing

Pay per usage

Rating

0.0

(0)

Developer

Radosław Szal

Actor stats

Bookmarked

Total users

Monthly active users

14 hours ago

Last modified

Setup (once, ~2 min) — service account

The actor authenticates with a Google service account (a robot Google account), so it only ever touches sheets you explicitly share with it:

In Google Cloud Console → APIs & Services → enable the Google Sheets API.
IAM & Admin → Service Accounts → create one → Keys → Add key → JSON → download.
Open the JSON, copy its contents into the Google service account key input (stored as a secret).
Share your spreadsheet with the service account's e-mail (the client_email in the JSON) — Viewer for import, Editor for export.

Import

{ "mode": "import", "spreadsheetId": "1AbC…xyz", "range": "Sheet1!A:Z", "firstRowAsHeader": true }

Row 1 becomes the field names; each following row becomes a record (plus _row, the sheet row number). With firstRowAsHeader: false the columns are named A, B, C…

Export

{ "mode": "export", "spreadsheetId": "1AbC…xyz", "range": "Sheet1!A1",
  "data": [ { "name": "Ada", "score": 91 }, { "name": "Alan", "score": 88 } ],
  "includeHeader": true, "append": false }

Objects → keys become the header row (order = first seen, or set columns).
Arrays → written positionally, no header.
append: true adds rows after the existing data instead of overwriting the range.
Or set sourceDatasetId instead of data to export a whole Apify dataset.

Each written row comes back as a dataset record (a receipt of exactly what was sent to the sheet).

Notes

Integration, not scraping — reads/writes only sheets you share with the service account. No public scraping, no personal data harvested from third parties.
Backs off automatically on Google API rate limits (HTTP 429).
Pricing — pay per row (result-item), flat. The first rows of every run are free to test.
Migration-safe imports (a restarted run resumes without duplicating rows) and overwrite-mode exports (idempotent). Append-mode export is best-effort at-least-once — for exactly-once on a platform restart, use overwrite mode (append: false).

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.3K

4.8

(7)

Google Sheets Import & Export — Reliable Bridge

lizaraco/google-sheets-import-export

Read Google Sheets to datasets and write rows back — append or overwrite — with quota-aware batching and retries. Your own credentials (service account or OAuth): your data never touches anyone else's account. Public sheets read with no credentials at all.

Shawn Downs

AUTO.RIA Scraper — Car Listings, Prices, VIN | Ukraine

skipper_lume/autoria-scraper

Scrape AUTO.RIA.com — Ukraine's largest car marketplace. Extract prices in USD/UAH/EUR, VIN codes, mileage, fuel type, gearbox, body type, photos, dealer info and 30+ fields. Filter by brand, model, year, price, region. No login or API key needed. HTTP-only, fast and cheap. The only AUTO.RIA actor.

Maksym Horbachov

Wellness Lead Generation Booking Engine Auditor

cosmic_country/wellness-lead-generation-booking-engine-auditor

Extract high-quality leads from wellness businesses (spas, yoga studios, gyms, and clinics) in any geographic area. This Actor doesn't just scrape contact info—it automatically identifies the booking platform used by the business (e.g., Mindbody, Vagaro, Acuity).

Dunica Robinson

Google Sheets Io

devon_gtme/google-sheets-io

Import Apify datasets into Google Sheets, or read sheets back into a dataset - authenticated with a Google service account, so the connection never expires and scheduled pipelines never break. Append, replace or read. Flattens nested objects, stable headers, auto 429 backoff. Free.

Devon Kellar

OpenStreetMap POI Extractor

automation-lab/openstreetmap-poi-extractor

Extract POIs from OpenStreetMap via Overpass API. Search by location + radius or bounding box. Filter by 20+ categories (restaurants, hotels, hospitals, parks, shops). Outputs name, coords, address, phone, website, opening hours. No API key needed.

Stas Persiianenko

Naver Blog Scraper - Clean Content & Review Intelligence

hanpro/naver-blog-scraper

Scrapes titles of websites using Crawlee and BeautifulSoup.The only Naver Blog scraper that properly extracts clean content from Naver's iframe architecture. Sponsor detection, metadata, engagement stats, and Google Sheets integration.

한프로

Instagram Reels Scraper — Profiles, Hashtags & Keywords

khadinakbar/instagram-reels-scraper

Scrape Instagram Reels from profiles, hashtags, or URLs. Returns video URL, captions, likes, comments, music, tags. MCP-ready. $1.50/1K reels.

Khadin Akbar

181

Company Domain Finder

automation-lab/company-domain-finder

🔎 Find likely official website domains for company names in bulk. Includes confidence scores, source snippets, citations, and alternatives.

Stas Persiianenko

Email Risk Validator, Contact Finder & Lead Cleaner

wearable_monkey/email-risk-validator-lead-cleaner

Validate email lists, extract website emails/phones/socials, generate B2B email candidates, score delivery risk, and export clean CRM-ready leads for outreach and SaaS workflows.

闻涛曾

Facebook Marketplace AI Deal Finder

webdatalabs/facebook-marketplace-deal-finder

Scrape Facebook Marketplace listings worldwide, get AI-powered market price comparison, and discover underpriced items for reselling. Works in any language — German, French, Japanese, Portuguese, and more.