Google Sheets Import Export
Pricing
Pay per usage
Easy way to import and export data from datasets across multiple Google sheets. Apify does not use Google Workspace APIs to develop, improve, or train generalized AI and/or ML models.
Pricing
Pay per usage
Rating
0.0
(0)
Developer
Apify
Actor stats
0
Bookmarked
2
Total users
0
Monthly active users
10 months ago
Last modified
Categories
Share
You can access the Google Sheets Import Export 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 Integrations settings in Apify Console.
$echo '{< "transformFunction": "// Uncomment this code only if you don'\''t use \\"Deduplicate by field\\" or \\"Deduplicate by equality\\"\\n// This code behaves as if there was no transform function\\n/*({ spreadsheetData, datasetData }) => {\\n return spreadsheetData.concat(datasetData);\\n}*/"<}' |<apify call apify/google-sheets-import-export --silent --output-datasetThe Apify CLI is the official tool that allows you to use Google Sheets Import Export locally, providing convenience functions and automatic retries on errors.
Using installation script (macOS/Linux):
$curl -fsSL https://apify.com/install-cli.sh | bashUsing installation script (Windows):
$irm https://apify.com/install-cli.ps1 | iexUsing Homebrew:
$brew install apify-cliUsing npm:
$npm install -g apify-cliOther API clients include: