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

Monthly users

211

Runs succeeded

54%

Issues response

59 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": {
        "apify": {
            "command": "npx",
            "args": [
                "mcp-remote",
                "https://mcp.apify.com/sse?actors=lukaskrivka/google-sheets",
                "--header",
                "Authorization: Bearer <YOUR_API_TOKEN>"
            ]
        }
    }
}

Configure MCP server with Fast Google Sheets import and export tool

You have a few options for interacting with the MCP server:

Use mcp.apify.com via mcp-remote from your local machine to connect and authenticate using OAuth or an API token (as shown in the JSON configuration above).
Set up the connection directly in your MCP client UI by providing the URL https://mcp.apify.com/sse?actors=lukaskrivka/google-sheets along with an API token (or use OAuth).
Connect to mcp.apify.com via Server-Sent Events (SSE), as shown below:

{
    "mcpServers": {
        "apify": {
            "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 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 Sheet Exporter

jupri/google-sheet-exporter

💫 Export Dataset to GoogleSheet

cat

361

3.8

Google Drive

onidivo/google-drive

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

Onidivo Technologies

Forward dataset as POST data

anchor/forward-dataset-webhook

This actor forwards the results of an Actor to an endpoint, instead of having to fetch the results manually. It will download the dataset and attach it to the body of a POST request you will specify. It acts as a new webhook. Simplify your Actor process !!!

Anchor

Zapier

canadesk/zapier

Get a list of all Integrations and App Templates available on Zapier. It's fast and costs little.

Canadesk Support

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

GTM Alpha Consultant - Shashwat Ghosh Digital Twin

shashghosh/gtm-alpha-consultant

Get expert GTM strategy analysis using Shashwat Ghosh's proven GTM Alpha methodology and EPIC framework. Perfect for CXOs of B2B Start-ups, ITeS and growth companies needing professional GTM insights. Receive an HTML report with actionable recommendations in minutes!

Shashwat Ghosh

Power Webhook Integration

pocesar/run-webhook-digest

Allows you to provide multiple HTTP endpoints, that receive a more complete JSON from the run, and allow you to hit those endpoints using a proxy, and enable you to do conditional webhook calls with some lines of Javascript code and you can link/chain one actor to another