Google Sheets Import & Export
No credit card required
Google Sheets Import & Export
No credit card required
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.
Do you want to learn more about this Actor?
Get a demoMode
modeEnumOptional
What should the actor do
Value options:
"append": string"replace": string"modify": string"read": string"load backup": stringSpreadsheet id
spreadsheetIdstringOptional
Id of the spreadsheet from where the old data will be loaded
Public spreadsheet (read-only)
publicSpreadsheetbooleanOptional
If checked, you don't need to authorize. You have to publish your spreadsheet and it works only in read mode
Default value of this property is false
Dataset ID
datasetIdstringOptional
Dataset or crawler execution id where the new data will be loaded from
Raw data
rawDataarrayOptional
Raw data JSON array. Can be array of arrays for direct row import or arrays of objects.
Limit items
limitintegerOptional
Number of items to take from the dataset. The default is 250000.
Default value of this property is 250000
Offset items
offsetintegerOptional
Number of items to skip from the dataset. Default is 0.
Default value of this property is 0
Deduplicate by field
deduplicateByFieldstringOptional
Items will be deduplicated by a value of this field. Cannot be used together with 'Deduplicate by equality' or 'Transform function'.
Deduplicate by equality
deduplicateByEqualitybooleanOptional
Items will be deduplicated if they are the same. Cannot be used together with 'Deduplicate by field' or 'Transform function'.
Transform function
transformFunctionstringOptional
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'
Range
rangestringOptional
Range of the spreadsheet in A1 notation where the actor should operate. Default is the first sheet.
Columns order
columnsOrderarrayOptional
Array of keys. First sorts the columns by provided keys. The rest is sorted alphabetically.
Keep column order from sheet
keepSheetColumnOrderbooleanOptional
If true, keeps the order of columns as they are in the sheet. If there is no sheet data yet, this does nothing.
Google OAuth tokens store
tokensStorestringOptional
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
Default value of this property is "google-oauth-tokens"
Create backup
createBackupbooleanOptional
Old rows from your spreadsheet will be saved to the default key-value store before importing new rows.
Lukáš KřivkaActor Metrics
47 monthly users
-
29 stars
82% runs succeeded
17 days response time
Created in Jan 2019
Modified 5 months ago
