Google Sheets Import & Export avatar
Google Sheets Import & Export

No credit card required

View all Actors
Google Sheets Import & Export

Google Sheets Import & Export

lukaskrivka/google-sheets

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.

The code examples below show how to run the Actor and get its results. To run the code, you need to have an Apify account. Replace <YOUR_API_TOKEN> in the code with your API token, which you can find under Settings > Integrations in Apify Console. Learn mode

Node.js

Python

curl

1# Set API token
2API_TOKEN=<YOUR_API_TOKEN>
3
4# Prepare Actor input
5cat > input.json <<'EOF'
6{
7  "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}*/"
8}
9EOF
10
11# Run the Actor
12curl "https://api.apify.com/v2/acts/lukaskrivka~google-sheets/runs?token=$API_TOKEN" \
13  -X POST \
14  -d @input.json \
15  -H 'Content-Type: application/json'
Developer
Apify logo Maintained by Apify
Actor metrics
  • 49 monthly users
  • 96.2% runs succeeded
  • 1.0 days response time
  • Modified about 1 month ago
Categories

You might also like these Actors