Pricing

Pay per usage

Try for free

Go to Apify Store

Google Sheets Import & Export

Try for free

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.

Pricing

Pay per usage

Rating

5.0

(4)

Developer

Lukáš Křivka

Actor stats

Bookmarked

2.9K

Total users

326

Monthly active users

61 days

Issues response

4 months ago

Last modified

Categories

Automation

Open source

Integrations

You can access the Google Sheets Import & Export programmatically from your own applications by using the Apify API. You can also choose the language preference from below. To use the Apify API, you’ll need an Apify account and your API token, found in Integrations settings in Apify Console.

Python

JavaScript

CLI

OpenAPI

HTTP

MCP

1import { ApifyClient } from 'apify-client';
2
3// Initialize the ApifyClient with your Apify API token
4// Replace the '<YOUR_API_TOKEN>' with your token
5const client = new ApifyClient({
6    token: '<YOUR_API_TOKEN>',
7});
8
9// Prepare Actor input
10const input = {
11    "transformFunction": `// Uncomment this code only if you don't use "Deduplicate by field" or "Deduplicate by equality"
12        // This code behaves as if there was no transform function
13        /*({ spreadsheetData, datasetData }) => {
14            return spreadsheetData.concat(datasetData);
15        }*/`
16};
17
18// Run the Actor and wait for it to finish
19const run = await client.actor("lukaskrivka/google-sheets").call(input);
20
21// Fetch and print Actor results from the run's dataset (if any)
22console.log('Results from dataset');
23console.log(`💾 Check your data here: https://console.apify.com/storage/datasets/${run.defaultDatasetId}`);
24const { items } = await client.dataset(run.defaultDatasetId).listItems();
25items.forEach((item) => {
26    console.dir(item);
27});
28
29// 📚 Want to learn more 📖? Go to → https://docs.apify.com/api/client/js/docs

Fast Google Sheets import and export tool API in JavaScript

The Apify API client for JavaScript is the official library that allows you to use Google Sheets Import & Export API in JavaScript or TypeScript, providing convenience functions and automatic retries on errors.

Install the apify-client

$npm install apify-client

Other API clients include:

Google Sheets Import & Export API in Python

Google Sheets Import & Export API through CLI

Google Sheets Import & Export OpenAPI definition

Google Sheets Import & Export API

Google Sheet Exporter

jupri/google-sheet-exporter

💫 Export Dataset to GoogleSheet

cat

698

4.9

Google Sheets Database Engine

xevri/sheets-engine-read-api-basic

Turn any public Google Sheet into a searchable database. Stop parsing huge CSVs, use simple MongoDB syntax to extract exactly what you need. Featuring smart type handling. Frontend safe and developer-ready. Unlimited Sheets .. Unlimited Queries 🚀 Run your first query now!

Xevri

5.0

Google Sheets Monitoring

dtrungtin/google-sheets-monitoring

This actor will monitor the google sheets file and do actions correspondingly.

Tin

TrueCar Scraper

voyn/truecar-scraper

Scrape TrueCar car listings into structured data: VIN, price, mileage, specs, dealer info, market average price, and estimated profit. A fast and reliable TrueCar API alternative for data analysis, lead generation, and pricing intelligence.

Voyn Software

5.0

Google Sheets Mcp

salesmart-srl/google-sheets-mcp

MCP server for Google Sheets integration. Read, write and format cells. Create spreadsheets and sheets. Append rows, clear ranges. Works with Claude, Cursor and any MCP-compatible AI assistant. Authenticate with Google Service Account.

Salesmart Srl

CEO Finder

mystical_waterbird/ceo-finder

Extract CEOs, founders & decision-makers from EN websites with high accuracy. Input data as text or JSON. Integrates with Clay.com and other tools. Async, fast, validated output, handles /impressum, /team, LinkedIn & email patterns. Perfect for B2B lead enrichment.

Shahrukh Yahh

Google Business Email Scraper – Advanced Cheapest & Reliable 📧

contactminerlabs/google-business-email-scraper---advanced-cheapest-reliable

🔍 Scrape Google Business Emails Enter your search parameters to collect verified contact emails from Google Business profiles, along with profile title, bio, source URL & platform info 📊 Perfect for lead generation, influencer outreach & data enrichment in tools like Google Sheets or CRMs🧩

ContactMinerLabs

5.0

YouTube Hashtag Shorts/Videos Scraper #️⃣📺 (All-in-one)

scrapestorm/youtube-hashtag-shorts-videos-scraper-all-in-one

Get Unlimited YouTube Trends Access with Our Alternative API: 🧑‍💻 Seamlessly crawl and scrape YouTube Trending Videos/Shorts by hashtag, to retrieve and download essential information such as the title 📺, view count 👀, and Short URL 📊, with no restrictions or quotas 🚫.

Storm_Scraper

5.0

CSV File to Dataset

lukaskrivka/csv-file-to-dataset

Upload a local or remote CSV/text file and convert it to Apify Dataset for further use.

Lukáš Křivka

164

YouTube Hashtag Video & Shorts Scraper 🎥

easyapi/youtube-hashtag-video-shorts-scraper

Scrape YouTube videos and Shorts by hashtag - Extract comprehensive video data including titles, views, channel info, and more. Perfect for content analysis and market research.