Spreadsheet Extractor avatar
Spreadsheet Extractor
Try for free

1 day trial then $5.00/month - No credit card required now

View all Actors
Spreadsheet Extractor

Spreadsheet Extractor

saswave/spreadsheet-extractor
Try for free

1 day trial then $5.00/month - No credit card required now

Extract all data from a sheet name inside a spreadsheet and generate a DataFrame (list of objects). Then you can chain to another Apify actor and provide the DataFrame as input data. Allows you to give data from a spreadsheet to Apify actor as input.

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  "url": "https://docs.google.com/spreadsheets/d/1MjDbzh8PY5VS_FF0r11o_dMS3XKEOW1b0p3pX-mzEWw",
8  "sheet_name": "test"
9}
10EOF
11
12# Run the Actor using an HTTP API
13# See the full API reference at https://docs.apify.com/api/v2
14curl "https://api.apify.com/v2/acts/saswave~spreadsheet-extractor/runs?token=$API_TOKEN" \
15  -X POST \
16  -d @input.json \
17  -H 'Content-Type: application/json'
Developer
Community logoMaintained by Community
Actor metrics
  • 1 monthly users
  • Created in Nov 2023
  • Modified 4 months ago

You might also like these Actors