Pricing

$0.002 / actor start

Try for free

Go to Apify Store

Google Sheets Database Engine

Try for free

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!

Pricing

$0.002 / actor start

Rating

5.0

(1)

Developer

Xevri

Actor stats

Bookmarked

Total users

Monthly active users

22 days ago

Last modified

Categories

Automation

Developer tools

Integrations

You can access the Google Sheets Database Engine 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 = {
9    "sheetUrl": "https://docs.google.com/spreadsheets/d/1be9JWQ6FXEi63lqqVXi3cjcsautNpFmJD9EXt1e39L0/edit?usp=sharding",
10    "sheetName": "Orders",
11}
12
13# Run the Actor and wait for it to finish
14run = client.actor("xevri/sheets-engine-read-api-basic").call(run_input=run_input)
15
16# Fetch and print Actor results from the run's dataset (if there are any)
17print("💾 Check your data here: https://console.apify.com/storage/datasets/" + run["defaultDatasetId"])
18for item in client.dataset(run["defaultDatasetId"]).iterate_items():
19    print(item)
20
21# 📚 Want to learn more 📖? Go to → https://docs.apify.com/api/client/python/docs/quick-start

Google Sheets Database Engine API in Python

The Apify API client for Python is the official library that allows you to use Google Sheets Database Engine 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 Database Engine API in JavaScript

Google Sheets Database Engine API through CLI

Google Sheets Database Engine OpenAPI definition

Google Sheets Database Engine API

Public Google Sheet scraper

advantageous_subcontra/public-google-sheet-scraper

Download data from a publicly available Google Sheet.

Fabian Maume

Google Sheet Exporter

jupri/google-sheet-exporter

💫 Export Dataset to GoogleSheet

cat

686

4.9

Google Sheets Import & Export

lukaskrivka/google-sheets

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.

Lukáš Křivka

2.9K

5.0

Czech vocative generator

advantageous_subcontra/czech-vocative-generator

Get the vocative for a Czech name. This actor uses a hard-coded list of 35k First Names. This makes it more reliable to ask ChatGPT for vocative.

Fabian Maume

Youtube Comments Scraper

webdatalabs/youtube-comments-harvester

Comprehensive YouTube comments scraper with channel-wide enumeration, incremental scraping, complete reply threading, and de-duplication. No API key required.

WebDataLabs

5.0

SEO Website audit check page sizes

advantageous_subcontra/seo-website-audit-check-page-sizes

Google isn't indexing html files above 2MB. This actor allows you to quickly check if any page of your website is affected.

Fabian Maume

Business Contact Extractor

washed_fun/business-contact-extractor

Extract business emails and phone numbers from company websites. High-accuracy AI-enabled business contact extractor using smart crawling, LLM and AI extraction, heuristics, and PDF extraction. Finds emails/phones even on complex sites. Supports CSV bulk input and outputs clean, CRM-ready data.

Sue

Trustmrr Scraper

actor_builder/trustmrr-scraper

Apify actor for scraping verified startup revenue data from TrustMRR.com - a leaderboard of indie startups with Stripe-verified financial metrics.

Green Salad

TrustMRR Startup scraper

advantageous_subcontra/trustmrr

Get all startups listed in any category on TrustMRR startup database. Get all information about each startup, like revenue, founding year, and location.

Fabian Maume

Instagram Post Super Scraper

muhammad_noman_riaz/instagram-post-super-scraper

Scrape Instagram posts from any public profile or post URL. Extract captions, hashtags, mentions, likes, comments, media URLs, and timestamps. Built for speed, stability, and accuracy with infinite scroll handling and anti-blocking automation.