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

4.6

(6)

Developer

Lukáš Křivka

Actor stats

Bookmarked

3.5K

Total users

458

Monthly active users

0.27 hours

Issues response

12 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

1from apify_client import ApifyClient
2
3# Initialize the ApifyClient with your Apify API token
4# Replace '<YOUR_API_TOKEN>' with your token.
5client = ApifyClient("<YOUR_API_TOKEN>")
6
7# Prepare the Actor input
8run_input = { "transformFunction": """// Uncomment this code only if you don't use \"Deduplicate by field\" or \"Deduplicate by equality\"
9// This code behaves as if there was no transform function
10/*({ spreadsheetData, datasetData }) => {
11    return spreadsheetData.concat(datasetData);
12}*/""" }
13
14# Run the Actor and wait for it to finish
15run = client.actor("lukaskrivka/google-sheets").call(run_input=run_input)
16
17# Fetch and print Actor results from the run's dataset (if there are any)
18print("💾 Check your data here: https://console.apify.com/storage/datasets/" + run["defaultDatasetId"])
19for item in client.dataset(run["defaultDatasetId"]).iterate_items():
20    print(item)
21
22# 📚 Want to learn more 📖? Go to → https://docs.apify.com/api/client/python/docs/quick-start

Fast Google Sheets import and export tool API in Python

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

Install the apify-client

$pip install apify-client

Other API clients include:

Google Sheets Import & Export API in JavaScript

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

827

4.9

Xvideos Scraper

hello.datawizards/Xvideos-Scraper1

Extract video data from Xvideos using keywords. Get titles, URLs, durations, thumbnails, uploaders, and views in JSON. Ideal for trend analysis and research. Use Apify Proxy for reliability. Simple input: keyword and item limit. Perfect for data aggregation and automation.

datawizards

XVideos Downloader 🎥

easyapi/xvideos-downloader

A powerful and efficient Actor for extracting video content and metadata from XVideos. Get direct download links, video information, and thumbnails in HD quality. Perfect for content archiving and media management with batch processing support.

EasyApi

189

Google Sheets MCP Server

powerai/google-sheets-mcp-server

Google Sheets MCP Server provides seamless access to Google Sheets API, enabling AI assistants to create, read, update, and manage Google Spreadsheets programmatically.

PowerAI

Xvideos Scraper Bulk Scraper Pro

hello.datawizards/Xvideos-Scraper

datawizards

Social Insight Scraper

insiteco/social-insight-scraper

Social Media Insights Scraper is an Apify Actor that extracts insights from YouTube, Instagram, and TikTok, gathering likes, comments, and engagement data to help track performance and refine content strategies. 🚀

Insiteco

176

3.5

XVideos Video Downloader | How to Download XVideos Videos

serpxxx/xvideos-video-downloader

Professional XVideos downloader with support for premium content, high-quality downloads, and batch processing. Download XVideos videos efficiently with no tracking.

SERP XXX

256

Pornhub scraper

saswave/pornhub-scraper

Pornhub scraper is a toolbox to extract any sort of data from the website pornhub.com . Perfect tool for monitoring trends and crawl multiple sources at scale. New features can be added on demand, It suits +18 adult content creators or analysts

SASWAVE

141

Google Sheets Monitoring

dtrungtin/google-sheets-monitoring

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

Tin

Google Maps Lead Generator - Emails, Phones & Socials

jurassic_jove/google-maps-lead-generator

Extract verified business emails, phones & social links from Google Maps at $0.02/lead. Visits each business's real website with Playwright for higher accuracy. Perfect for B2B lead generation, sales prospecting, and local marketing campaigns.