Pricing

$0.20 / 1,000 row writtens

Try for free

Go to Apify Store

Google Sheets Import & Export | No OAuth, Free Import

Try for free

Export any Apify dataset or JSON to Google Sheets (append, append only new rows, replace) or import a Google Sheet into a dataset for free. No OAuth, no Google Cloud: public link, Apps Script or service account. Quota-safe retries, exact text, new columns added automatically.

Pricing

$0.20 / 1,000 row writtens

Rating

0.0

(0)

Developer

Mikirag3

Actor stats

Bookmarked

Total users

Monthly active users

5 days ago

Last modified

Google Sheets Import & Export for Apify Datasets | Apify API

Below, you can find a list of relevant HTTP API endpoints for calling the Google Sheets Import & Export | No OAuth, Free Import 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/mikirag3~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/mikirag3~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/mikirag3~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 Import & Export | No OAuth, Free Import API programmatically via the Apify API.

You can choose from:

Google Sheets Import & Export | No OAuth, Free Import API in Python

Google Sheets Import & Export | No OAuth, Free Import API in JavaScript

Google Sheets Import & Export | No OAuth, Free Import API through CLI

Google Sheets Import & Export | No OAuth, Free Import OpenAPI definition

You can start Google Sheets Import & Export | No OAuth, Free Import 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 Import & Export | No OAuth, Free Import is identified within the API by its ID, which is the creator’s username and the name of the Actor.

When the Google Sheets Import & Export | No OAuth, Free Import 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.

GCP Uploader

circ_le/gcp-uploader

Upload datasets and KV store records to Google cloud storage

Cir◎cle

5.0

(1)

Google Sheet Exporter

jupri/google-sheet-exporter

💫 Export Dataset to GoogleSheet

cat

849

4.9

(4)

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 Sheets Import & Export

cypherstone/google-sheets-import-export

Read a Google Sheet into a dataset (public sheets need no key) and write datasets or JSON back - append, replace, or upsert - using a service account, with no interactive OAuth and automatic rate-limit retries.

Jeff Ralston

Google Sheets Reader & Writer

accurate_pouch/google-sheets-rw

Read any Google Sheet to JSON or write rows to a sheet — via Service Account auth. No OAuth blocking, no failed logins. Supports read, append, replace, modify, and backup modes. Includes safe replace, dry run, auto-create tab, and rate limit retry.

Manchitt Sanan

📗 Google Sheets Import & Export — Free Reads, No OAuth

srd836/google-sheets-import-export

Reading is FREE: pull any link-shared Google Sheet into a dataset with zero setup — no API key, no OAuth, no Google Cloud project, no card. Add a service account key to write: append, replace or upsert with deduplication, straight from any Apify dataset. You only pay for rows written — $1 per 1,000.

David González

Google Sheets Monitoring

dtrungtin/google-sheets-monitoring

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

Tin

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.

Superior Actors

5.0

(1)

Google Sheets Import & Export: No OAuth, 1,000 Rows Free

bridgeworks/sheets-bridge

Export any Apify dataset to Google Sheets, or import a sheet into a dataset, using your own service account: no OAuth screen, no expiring tokens. The first 1,000 rows of every run are free. Append, replace, or upsert rows. Works as a run integration on any scraper.

Bridgeworks

Google Sheets URL Monitor Actor

dtrungtin/google-sheets-url-monitor-actor

Google Sheets URL Monitor turns a plain spreadsheets into a **no-code web monitoring dashboard**. It reads the URLs listed in your sheet's `URL` column, visits each page in a real browser, extracts the values you care about (prices, titles), and writes the fresh values straight back into the sheet.

Tin