Google Sheets Import & Export
Pricing
Pay per usage
Go to Store
Google Sheets Import & Export
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.
5.0 (1)
Pricing
Pay per usage
36
Monthly users
103
Runs succeeded
84%
Response time
20 days
Last modified
12 hours ago
Version 2
2022-03-03
- Migrated to new SDK version which caused crashes for one day until hotfixed.
- Better error messages
2020-10-08
- Fixed: A bug that prevented loading big amount of data from the spreadsheets (by upgrading
googleapisversion) - Fixed:
transformFunctionwas adding extra columns from the dataset even if they were renamed - Fixed: Sub-array default sorting
- Feature: Added
keepSheetColumnOrderoption to input to prevent re-sorting data in your sheet
2019-11-17
- Removed support for Apify Crawler (this product has been removed)
- Webhooks work out of the box without a need to change the payload template (for tasks).
- Input -
datasetOrExecutionIdchanged todatasetId. - Added sections to input (only visual change)
2019-12-31
- Fixed: Excess rows/columns were wrongly trimmed if the range was not the first sheet. May have caused a removal of data in the first sheet.
2020-01-11
- Warning!: For running this actor's code outside of
lukaskrivka/google-sheetsofficial version, you will need to create your own Google Dev Console project and provide your own keys to the input! This change will apply to older versions as well! - Added: Option to read from public spreadsheets without authorization (pass
publicSpreadsheet: trueto the input).
2020-04-24
- Added
columnsOrderfield so the user can define the order of columns
2020-04-29
- New sheets (via
rangeinput) are now automatically created by the actor, no need to pre-create them anymore
Pricing
Pricing model
Pay per usageThis Actor is paid per platform usage. The Actor is free to use, and you only pay for the Apify platform usage.
