Pricing

from $2.00 / 1,000 1,000 rows synceds

Try for free

Go to Apify Store

Google Sheets Import/Export – Service Account, No OAuth Expiry

Try for free

Append, upsert, replace, read or back up Google Sheets with a service-account key: no OAuth tokens that expire, no browser login. Idempotent upsert by key, nested JSON flattening, 50k+ rows in chunks, automatic 429 backoff, backup before overwrite. $0.002 per 1,000 rows.

Pricing

from $2.00 / 1,000 1,000 rows synceds

Rating

0.0

(0)

Developer

Jordan Banchonpanith

Actor stats

Bookmarked

Total users

Monthly active users

2 days ago

Last modified

Categories

Integrations

Developer tools

Security

You can access the Google Sheets Import/Export – Service Account, No OAuth Expiry 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 = { "rows": [
9        {
10            "id": "sku-1",
11            "name": "Blue mug",
12            "price": 12.5,
13            "stock": {
14                "warehouse": "Lyon",
15                "qty": 40,
16            },
17        },
18        {
19            "id": "sku-2",
20            "name": "Red mug",
21            "price": 11,
22            "stock": {
23                "warehouse": "Paris",
24                "qty": 0,
25            },
26        },
27    ] }
28
29# Run the Actor and wait for it to finish
30run = client.actor("characteristic_division/sheets-sync-service-account").call(run_input=run_input)
31
32# Fetch and print Actor results from the run's dataset (if there are any)
33print(f"💾 Check your data here: https://console.apify.com/storage/datasets/{run.default_dataset_id}")
34for item in client.dataset(run.default_dataset_id).iterate_items():
35    print(item)
36
37# 📚 Want to learn more 📖? Go to → https://docs.apify.com/api/client/python/docs/quick-start

Google Sheets Import/Export via Service Account API in Python

The Apify API client for Python is the official library that allows you to use Google Sheets Import/Export – Service Account, No OAuth Expiry 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 – Service Account, No OAuth Expiry API in JavaScript

Google Sheets Import/Export – Service Account, No OAuth Expiry API through CLI

Google Sheets Import/Export – Service Account, No OAuth Expiry OpenAPI definition

Google Sheets Import/Export – Service Account, No OAuth Expiry API

Instagram Scraper

apify/instagram-scraper

Extract Instagram posts, reels, profiles, places, hashtags, carousels, and comments. Get data from Instagram using one or more Instagram URLs or search queries: content, context, metrics, metadata. Export scraped data, run the scraper via API, schedule and monitor runs or integrate with other tools.

Apify

467K

4.7

(604)

TikTok Scraper

clockworks/tiktok-scraper

Extract data from TikTok videos, hashtags, and users. Use URLs or search queries to scrape TikTok profiles, hashtags, posts, URLs, shares, followers, hearts, names, video, and music-related data. Export scraped data, run the scraper via API, schedule and monitor runs or integrate with other tools.

Clockworks

380K

4.8

(370)

Instagram Profile Scraper

apify/instagram-profile-scraper

Scrape all Instagram profile info. Just add Instagram usernames, IDs or URLs and extract name, join date, number of followers, location, bio, website, related profiles, video&post count, latest posts. Export scraped data, schedule scraper via API, and integrate with other tools or AI workflows.

Apify

275K

4.7

(175)

Google Maps Scraper

compass/crawler-google-places

Extract data from thousands of Google Maps locations and businesses, including reviews, reviewer details, images, contact info, including full name, email, and job title, opening hours, prices & more. Export data, run via API, schedule and monitor runs, or integrate with other tools.

Compass

682K

4.7

(1,825)

Google Search Results Scraper

apify/google-search-scraper

Scrape Google Search Engine Results Pages (SERPs). Select the country or language and extract organic and paid results, AI Mode, AI overviews, ads, queries, People Also Ask, prices, reviews, like a Google SERP API. Export data, run the scraper via API, schedule runs, or integrate with other tools.

Apify

227K

4.7

(218)

LinkedIn Company Details Scraper (No Cookies)

harvestapi/linkedin-company

Extract detailed information from LinkedIn Companies such as company name, address, phone numbers, website, employee count, and more. Find LinkedIn company URLs by name in Bulk. No cookies or account required.

HarvestAPI

32K

4.9

(30)

Skip Trace | Owner Phones & Emails — Pay Only for Hits

thermostatic/skiptrace

Skip tracing & people search: name, address or phone in → ranked phones (type, carrier, confidence), emails, addresses, relatives out. Name + location searches return the right person, not a namesake. Pay only for matched records. Lawful B2B use only.

Irving Ernesto Quezada Ramírez

2.4K

Tweet Scraper V2 - X Scraper / Twitter Scraper / X.com Scraper

apidojo/tweet-scraper

Lightning-fast search, URL, list, and profile scraping, with customizable filters. At $0.40 per 1000 tweets, and 30-80 tweets per second, it is ideal for researchers, entrepreneurs, and businesses! Get comprehensive insights from Twitter (X) now!

API Dojo

130K

3.9

(196)

Website Content Crawler

apify/website-content-crawler

Crawl websites and extract text content to feed AI models, LLM applications, vector databases, or RAG pipelines. The Actor supports rich formatting using Markdown, cleans the HTML, downloads files, and integrates well with 🦜🔗 LangChain, LlamaIndex, and the wider LLM ecosystem.

Apify

175K

4.6

(234)

Instagram Post Scraper

apify/instagram-post-scraper

Scrape Instagram posts. Just add one or more Instagram usernames and get your data in seconds including caption, metrics, images, mentions, coauthors, recent comments, sponsored status, video duration, views. Export scraped data, schedule scraper via API, integrate with other tools or AI workflows.

Apify

153K

4.3

(139)