You can access the Sheets Sync Pro 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 API & Integrations 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    "mode": "import-public",
10    "spreadsheetId": "1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms",
11    "gid": 0,
12}
13
14# Run the Actor and wait for it to finish
15run = client.actor("master_invictus/sheets-sync-pro").call(run_input=run_input)
16
17# Fetch and print Actor results from the run's dataset (if there are any)
18print(f"💾 Check your data here: https://console.apify.com/storage/datasets/{run.default_dataset_id}")
19for item in client.dataset(run.default_dataset_id).iterate_items():
20    print(item)
21
22# 📚 Want to learn more 📖? Go to → https://docs.apify.com/api/client/python/docs/quick-start

Sheets Sync Pro – Google Sheets import & export API in Python

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

Install the apify-client

$pip install apify-client

Other API clients include:

Sheets Sync Pro API in JavaScript

Sheets Sync Pro API through CLI

Sheets Sync Pro OpenAPI definition

Sheets Sync Pro API

Google Sheets Import & Export — Fast, Reliable Sync

surefetch/google-sheets

Import Apify datasets, JSON or CSV into Google Sheets and export sheets back to JSON. Append, replace and read modes. Built for reliability: automatic retries, exponential backoff, no OAuth tokens that expire.

Jonas Eckl

1.0

(1)

Google Sheet MCP SERVER

bhansalisoft/google-sheet-mcp-server

Google Sheet MCP SERVER for unique tool for Google Sheet integration with all functionality on Any AI Tool

bhansalisoft

Google Sheets Export & Scraper

sourabhbgp/google-sheets-export

Export any public Google Sheet to flat JSON rows, a full xlsx workbook, or both. Typed values, multi-tab, hyperlinks and formulas optional. No Google Cloud project, no OAuth, no API key — just paste a sharing URL.

Sourabh Kumar

TikTok Scraper Pro

netdesignr/tiktok-scraper-pro

Scrape TikTok videos from profiles, video URLs, search, hashtags, and sounds with stronger diagnostics, simpler pricing, and cleaner output.

Netdesignr

5.0

(1)

Google Sheets Monitoring

dtrungtin/google-sheets-monitoring

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

Tin

Firestore Import

apify/firestore-import

Seamlessly import data from Apify datasets into Firebase Firestore database. This integration allows full control over document IDs, conflict resolution (overwrite, merge, skip), and data transformation using a custom JavaScript function.

Apify

5.0

(5)

YouTube TRANSCRIPT Scraper PRO

imemi/youtube-transcript-scraper-pro

Professional YouTube Transcript Scraper. Extract subtitles and captions from any video in seconds. Supports multiple languages and includes a smart proxy rotation system to bypass blocking. Outputs a variety of structured datasets (JSON, CSV, Excel,srt ,vtt & etc.)

imemi

HomeAdvisor Pro Lead Scraper

meticulous_snail/homeadvisor-pro-leads

Extract home service professionals from HomeAdvisor by service type and zip code. Get pro name, company, phone, rating, review count, years in business, and license status. Perfect for insurance agents, equipment vendors, and home service software companies.

Beatsync Pro

Google Maps Business Scraper Pro

bronze_shovel/google-maps-business-scraper-pro

Power your local marketing campaigns with comprehensive Google Maps business intelligence. Extract complete business profiles including contact information, reviews, photos, hours, and customer insights.

Biffer

Google Sheets Import & Export: Sync Datasets, Update Rows

s_actors/google-sheets-import-export

Send any Apify dataset or JSON to Google Sheets: append, replace, or update rows by a unique key (price and stock monitoring). No OAuth: share the sheet once. Auto-retries on Google limits, one tab per day, dedupe, column picking. Also reads sheets back to JSON.