Google Sheets Import & Export

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

Maintained by Apify

Actor stats

Bookmarked

2.3K

Total users

215

Monthly active users

1.6 days

Issues response

6 days 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

576

3.8

Amazon Deal Steal

davan_strategic/Amazon-Deal-Steal

Track competitor sales to learn their pricing strategy. Drop in a list of ASINs and the Amazon Deal Steal grabs the latest product snapshot, pulls reviews and brand info, captures both list and sale prices, checks for strikethroughs/limited-time badges and tags which offers are currently discounted.

DAVAN Strategic

5.0

Google Sheets Monitoring

dtrungtin/google-sheets-monitoring

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

Tin

Chroma Integration

apify/chroma-integration

This integration transfers data from Apify Actors to a Chroma and is a good starting point for a question-answering, search, or RAG use case.

Apify

4.5

Rutificador

datacach/rutificador

Find people fast with the Rutificador – Chile’s trusted search engine for RUT (ID) verification. Access verified info like names, addresses, and more. Perfect for safe transactions and fraud prevention. Try the Rutificador today!

DataCach

Upcheck

apikit/upcheck

Monitor websites and APIs with this simple yet powerful availability checker. This Apify Actor checks the status of your specified endpoints, tracks their response times, and alerts you when they become unavailable

API-KIT

5.0

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

RAG Web Browser

apify/rag-web-browser

Web browser for OpenAI Assistants, RAG pipelines, or AI agents, similar to a web browser in ChatGPT. It queries Google Search, scrapes the top N pages, and returns their content as Markdown for further processing by an LLM. It can also scrape individual URLs.

Apify

7.2K

4.9

Scrape And Bypass Any Url Using Scrappey

dormic/apify-scrappey

A template for scraping data from web pages using the Scrappey.com API service integrated with an Apify Actor. This actor provides a robust solution for handling complex web scraping scenarios, including sites with anti-bot protection such as Cloudflare, Datadome, PerimeterX and all other forms.

Pim

120

5.0

Rutificador Empresas Chilenas (Chilean Business scraper)

datacach/rutificador-empresas-chilenas

Extract Chilean entity data from boletaofactura.com. Scrape companies, foundations, unions & more. Get RUT, business name (razón social), activities (actividades), and type/subtype. Ideal for market analysis and data enrichment. Export to JSON, CSV, or Excel.

DataCach