Google Sheets Import Export Tool
Pricing
Try for freeGoogle Sheets Import Export Tool
odin-kael/google-sheets-import-and-export
A powerful Google Sheets data import export tool designed for data synchronization, backup, and integration between Google Sheets and external systems. Supports three operation modes, two authentication methods, batch processing, data deduplication, and automatic backup.
Try for Free
2,000 Free Results
Spreadsheet IDs | 电子表格 ID 列表Required
Google Spreadsheet IDs to process. Each ID will be processed in parallel. Get ID from URL (e.g., docs.google.com/spreadsheets/d/[ID]/edit). | 要处理的 Google 电子表格 ID 列表。每个 ID 将并行处理。从 URL 中提取 ID。
Type: array
Mode | 模式Optional
What should the worker do. | Worker 执行的操作模式。
Type: select
Default: read
Options:
Read (Export) | 读取/导出Append (Add rows) | 追加行Replace (Overwrite) | 替换
Authentication Method | 认证方式Optional
• Service Account: 私有表格 + 写入操作 | Private sheets + Write operations • API Key: 仅公开表格只读 | Public sheets read-only How to get credentials: https://console.cloud.google.com/apis/credentials
Type: select
Default: apiKey
Options:
🔐 Service Account (私有表格/写入)🔑 API Key (公开表格只读)
Service Account JSON | 服务账号 JSONOptional
Google Service Account JSON key. Required for write operations (append/replace). | Google 服务账号 JSON 密钥。写入操作（追加/替换）必需。
Type: string
API Key | API 密钥Optional
Google API Key for reading public spreadsheets. Get it from Google Cloud Console > APIs & Services > Credentials. | 用于读取公开表格的 Google API 密钥。在 Google Cloud Console > API和服务 > 凭据 中创建。
Type: string
Raw Data (JSON Array) | 原始数据Optional
Data to import. Array of objects where each object is a row. Only used in append/replace mode. | 要导入的数据。对象数组，每个对象为一行。仅在追加/替换模式中使用。
Type: array
Range (Sheet Name) | 范围/工作表名Optional
Sheet name or A1 notation range (e.g., 'Sheet1' or 'Sheet1!A1:D10'). Default is first sheet. | 工作表名称或 A1 表示法范围。默认为第一个工作表。
Type: string
Deduplicate By Field | 按字段去重Optional
Field name to deduplicate rows. Rows with same value in this field will be merged. | 用于去重的字段名。该字段值相同的行将被合并。
Type: string
Columns Order | 列顺序Optional
Array of column keys to specify column order. Remaining columns sorted alphabetically. | 列键数组，用于指定列顺序。其余列按字母顺序排列。
Type: array
Limit Rows | 限制行数Optional
Maximum number of rows to read (read mode) or import (append/replace mode). | 读取或导入的最大行数。
Type: integer
Default: 10000
Create Backup | 创建备份Optional
Save existing sheet data as JSON in output before overwriting. | 在覆盖前将现有工作表数据保存为 JSON 输出。
Type: boolean
Default: false
Debug Mode | 调试模式Optional
Enable detailed logging. | 启用详细日志。
Type: boolean
Default: false
Pricing
Failed results don't count
Rating
5.0
Developer
Kael Odin
Worker Stats
2 Total runs
Success rate: 100.00%
Last updated: Apr 15, 2026
Categories
Share
You might also like
Explore more popular scrapers from our marketplace
Google Search Results (SERP) Scraper API
by CoreClaw
It queries the Google search engine by keyword and returns a structured SERP summary, including the final search parameters, organic results, related queries, and people-also-ask data.
4.8
588 runs
From $1.2/1,000 results
Dataset Deduplication & Merge Tool
by Kael Odin
Dedup Datasets Worker is a powerful tool for merging and deduplicating datasets from multiple JSON/JSONL files. Fully optimized for the CafeScraper platform with enhanced features and robust error handling.
5.0
15 runs
From $1.2/1,000 results
Cheerio Web Scraping
by Kael Odin
A high-speed static page scraper based on Cheerio, designed specifically for static HTML pages. Uses Cheerio for HTML parsing, delivering speeds 10-50 times faster than full browser rendering.
5.0
3 runs
From $1.2/1,000 results
Playwright Web Scraping
by Kael Odin
A powerful cross-browser web scraping tool using Playwright for complete browser rendering. Supports Chromium, Firefox, and WebKit browser engines. Perfect for dynamic pages, single-page applications (SPAs), infinite scroll pages, and cross-browser testing scenarios.
5.0
4 runs
From $1.2/1,000 results