Pricing

from $0.14 / 1,000 row written to the sheets

Try for free

Go to Apify Store

Google Sheets Export & Import: Dataset to Sheet, No Failed Runs

Try for free

Writes an Apify dataset, JSON or CSV to a Google Sheet (append, replace, update by key) or imports a sheet. Waits out Google's 429 limit, no duplicate rows, rolls over at the cell cap. Inputs: spreadsheet, mode, datasetId. $0.005 per job + $0.0002 per row. Agent-ready via x402 and MCP, no OAuth.

Pricing

from $0.14 / 1,000 row written to the sheets

Rating

0.0

(0)

Developer

Adam Pearce

Actor stats

Bookmarked

Total users

Monthly active users

3 hours ago

Last modified

Categories

Developer tools

Automation

Integrations

You can access the Google Sheets Export & Import: Dataset to Sheet, No Failed Runs 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

# Set API token
$API_TOKEN=<YOUR_API_TOKEN>

# Prepare Actor input
$cat > input.json << 'EOF'
<{
<  "spreadsheet": "https://docs.google.com/spreadsheets/d/1gV5ZFKQsKgake9aKTTQRaPRwmA7yS4BZySrmzGqNVAg/edit",
<  "rawData": [
<    {
<      "company": "Northwind Traders",
<      "city": "London",
<      "website": "https://example.com/northwind",
<      "rating": 4.6,
<      "reviews": 128
<    },
<    {
<      "company": "Contoso Bakery",
<      "city": "Leeds",
<      "website": "https://example.com/contoso",
<      "rating": 4.8,
<      "reviews": 342
<    },
<    {
<      "company": "Fabrikam Plumbing",
<      "city": "Bristol",
<      "website": "https://example.com/fabrikam",
<      "rating": 4.3,
<      "reviews": 57
<    },
<    {
<      "company": "Tailspin Toys",
<      "city": "Manchester",
<      "website": "https://example.com/tailspin",
<      "rating": 4.9,
<      "reviews": 811,
<      "address": {
<        "street": "1 High St",
<        "postcode": "M1 1AA"
<      }
<    }
<  ]
<}
<EOF

# Run the Actor using an HTTP API
# See the full API reference at https://docs.apify.com/api/v2
$curl "https://api.apify.com/v2/actors/nerolabs~google-sheets-export/runs?token=$API_TOKEN" \
<  -X POST \
<  -d @input.json \
<  -H 'Content-Type: application/json'

Google Sheets Export & Import for Apify, No Failed Runs API

Below, you can find a list of relevant HTTP API endpoints for calling the Google Sheets Export & Import: Dataset to Sheet, No Failed Runs Actor. For this, you’ll need an Apify account. Replace <YOUR_API_TOKEN> in the URLs with your Apify API token, which you can find under API & Integrations in Apify Console. For details, see the API reference.

Run Actor

POST
https://api.apify.com/v2/actors/nerolabs~google-sheets-export/runs?token=<YOUR_API_TOKEN>

Note: By adding the method=POST query parameter, this API endpoint can be called using a GET request and thus used in third-party webhooks. Please refer to our Run Actor API documentation.

Run Actor synchronously and get dataset items

POST
https://api.apify.com/v2/actors/nerolabs~google-sheets-export/run-sync-get-dataset-items?token=<YOUR_API_TOKEN>

Note: This endpoint supports both POST and GET request methods. However, only the POST method allows you to pass input data. For more information, please refer to our Run Actor synchronously and get dataset items API documentation.

Get Actor

GET
https://api.apify.com/v2/actors/nerolabs~google-sheets-export?token=<YOUR_API_TOKEN>

For more information, please refer to our Get Actor API documentation.

Actors can be used to scrape web pages, extract data, or automate browser tasks. Use the Google Sheets Export & Import: Dataset to Sheet, No Failed Runs API programmatically via the Apify API.

You can choose from:

Google Sheets Export & Import: Dataset to Sheet, No Failed Runs API in Python

Google Sheets Export & Import: Dataset to Sheet, No Failed Runs API in JavaScript

Google Sheets Export & Import: Dataset to Sheet, No Failed Runs API through CLI

Google Sheets Export & Import: Dataset to Sheet, No Failed Runs OpenAPI definition

You can start Google Sheets Export & Import: Dataset to Sheet, No Failed Runs with the Apify API by sending an HTTP POST request to the Run Actorendpoint. An Actor’s input and its content type can be passed as a payload of the POST request, and additional options can be specified using URL query parameters. The Google Sheets Export & Import: Dataset to Sheet, No Failed Runs is identified within the API by its ID, which is the creator’s username and the name of the Actor.

When the Google Sheets Export & Import: Dataset to Sheet, No Failed Runs run finishes you can list the data from its default dataset(storage) via the API or you can preview the data directly on Apify Console.

RedNote (Xiaohongshu) Search Scraper - 500 Notes/30s

zen-studio/rednote-search-scraper

Extract Xiaohongshu (RedNote / 小红书) search results by keyword. Get author profile, engagement counts (likes, comments, collects), image galleries, and playable video stream URLs — 24 fields per note. 500 notes in 30s. Filter by note type. JSON/CSV/Excel export.

Zen Studio

10K

4.0

(4)

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

457K

4.7

(603)

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

268K

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

673K

4.7

(1,820)

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

369K

4.7

(370)

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

221K

4.6

(220)

Bilibili Scraper — Videos, Comments, Danmaku & Creator Uploads

zhorex/bilibili-scraper

Bilibili (哔哩哔哩, B站) scraper API for China social media video: search, video details, comment threads, Chinese influencer uploads and creator profiles (followers, likes), the popular/trending board — plus danmaku (弹幕), the bullet comments scrolling over each video. No cookie needed.

Sami

2.0

(1)

Instagram Profile Scraper (Bio & Posts)

coderx/instagram-profile-scraper-bio-posts

Instagram Profile Insights Scraper is a lightweight tool that collects detailed public data from a list of Instagram usernames. It fetches profile info and recent posts to help you analyze accounts at scale.

CoderX

11K

5.0

(9)

Facebook Posts Scraper

apify/facebook-posts-scraper

Extract posts, videos, and engagement metrics from Facebook pages. Get text captions, reactions, video transcripts, images, external links, collaborators, and more from Facebook pages and profiles. Export ad data, schedule runs via API, and integrate with other tools or AI workflows.

Apify

133K

4.7

(236)