Pricing

Pay per usage

Go to Store

Google Sheets Import & Export

Try for free

Developed by

Lukáš Křivka

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.

5.0 (1)

Pricing

Pay per usage

Total users

1.5K

Monthly users

193

Runs succeeded

68%

Issues response

43 days

Last modified

9 days ago

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

{
    "mcpServers": {
        "local-actors-mcp-server": {
            "command": "npx",
            "args": [
                "-y",
                "@apify/actors-mcp-server",
                "--actors",
                "lukaskrivka/google-sheets"
            ],
            "env": {
                "APIFY_TOKEN": "<YOUR_API_TOKEN>"
            }
        }
    }
}

Configure MCP server with Fast Google Sheets import and export tool

You can interact with the MCP server via standard input/output - stdio (as shown above), which is ideal for local integrations and command-line tools such as the Claude desktop client, or you can interact with the server through Server-Sent Events (SSE) to send messages and receive responses, which looks as follows:

{
    "mcpServers": {
        "remote-actors-mcp-server": {
            "type": "sse",
            "url": "https://mcp.apify.com/sse?actors=lukaskrivka/google-sheets",
            "headers": {
                "Authorization": "Bearer <YOUR_API_TOKEN>"
            }
        }
    }
}

You can connect to the Apify MCP Server using clients like Tester MCP Client, or any other supported MCP client of your choice.

If you want to learn more about our Apify MCP implementation, check out our MCP documentation. To learn more about the Model Context Protocol in general, refer to the official MCP documentation or read our blog post.

Google Sheets Monitoring

dtrungtin/google-sheets-monitoring

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

Tin

Google Drive

onidivo/google-drive

Transfer files between Apify's key-value stores and Google Drive.

Onidivo Technologies

Google Sheet Exporter

jupri/google-sheet-exporter

💫 Export Dataset to GoogleSheet

cat

310

2.2

Duplications Checker

lukaskrivka/duplications-checker

Check your dataset for duplications. Accept only the highest quality data!

Lukáš Křivka

226

Merge, Dedup & Transform Datasets

lukaskrivka/dedup-datasets

The ultimate dataset processor. Extremely fast merging, deduplications & transformations all in a single run.

Lukáš Křivka

4.2K

Airtable Exporter

jupri/airtable

💫 Export Dataset to Airtable

cat

134

3.5

Airtable Scraper

spencers/airtable-scraper

Scrape data from any embedded Airtable page

Spencer Smith

Tester MCP Client

jiri.spilka/tester-mcp-client

A model context protocol (MCP) client that connects to any MCP server using Server-Sent Events (SSE) and displays the conversation in a chat-like UI. It is a standalone Actor server designed for testing MCP servers over SSE.

Jiří Spilka

431

4.8

Netflix Top 10 Finder

alien_force/netflix-top-10-finder

Discover what's trending on Netflix with ease! This powerful actor fetches the Top 10 movies or series worldwide or by country, complete with detailed stats like views, duration, and hours watched. Perfect for market research, content creation, or staying updated on global entertainment trends!