API_KEY

CLIENT_SECRET

CLIENT_SECRET_2

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.

Id of the key-value store where the backup you want to load is located. Can pnly be used if mode is 'load-backup'

Backup store id

Array of keys. First sorts the columns by provided keys. The rest is sorted alphabetically.

Columns order

Old rows from your spreadsheet will be saved to the default key-value store before importing new rows.

Create backup

Dataset or crawler execution id where the new data will be loaded from

Only fill in for `append` or `replace` mode. Choose either `Dataset ID` or `Raw data`. Limit and offset is optional.

Dataset ID

Items will be deduplicated if they are the same. Cannot be used together with 'Deduplicate by field' or 'Transform function'.

Deduplicate by equality

Items will be deduplicated by a value of this field. Cannot be used together with 'Deduplicate by equality' or 'Transform function'.

Choose up to one way to deduplicate or transform your data.

Deduplicate by field

If you want to use this actor locally or with your own version, you have to provide your own crednetials. Check actor readme for more information.

Google Developer Console credentials

If true, keeps the order of columns as they are in the sheet. If there is no sheet data yet, this does nothing.

Keep column order from sheet

Number of items to take from the dataset. The default is 250000.

Limit items

Mode

Number of items to skip from the dataset. Default is 0.

Offset items

If checked, you don't need to authorize. You have to publish your spreadsheet and it works only in read mode

Public spreadsheet (read-only)

Range of the spreadsheet in A1 notation where the actor should operate. Default is the first sheet.

Range

Raw data JSON array. Can be array of arrays for direct row import or arrays of objects.

Raw data

Id of the spreadsheet from where the old data will be loaded

Spreadsheet id

Key-value store where your Google OAuth tokens will be stored so you don't have to authorize every time again. By default it is google-oauth-tokens

Google OAuth tokens store

Custom function that will take new items and old items arrays as parameters and produces final array that will be imported.  Cannot be used together with 'Deduplicate by equality' or 'Deduplicate by field'

Transform function

Spreadsheet import input

google-sheets

Import, export or process datasets or JSON to Google Sheets. Easier and faster than official API. Perfect for importing data to sheets from scrapers.

Apify Store

Actor ideas

Custom solutions

Enterprise

Use cases

Success stories

E-commerce & Retail

Marketing & Media

Software & SaaS

Telecommunications

Healthcare & Pharma

Manufacturing

Real estate

Research & Education

Fintech & Insurance

NGO & Government

Travel & Logistics

Actors

Proxy

Status

Storage

Integrations

Documentation

Apify SDK

Help & Support

Discord community

Web scraping guide

Apify partner programs

Solution providers

Apify Freelancers

Affiliate program

About Apify

Blog

Careers

Contact us

Google Sheets Import & Export

Build new tools

Get a custom solution