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

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




1from apify_client import ApifyClient
3# Initialize the ApifyClient with your Apify API token
4client = ApifyClient("<YOUR_API_TOKEN>")
6# Prepare the Actor input
7run_input = {
8    "url": "https://docs.google.com/spreadsheets/d/1MjDbzh8PY5VS_FF0r11o_dMS3XKEOW1b0p3pX-mzEWw",
9    "sheet_name": "test",
12# Run the Actor and wait for it to finish
13run = client.actor("saswave/spreadsheet-extractor").call(run_input=run_input)
15# Fetch and print Actor results from the run's dataset (if there are any)
16for item in client.dataset(run["defaultDatasetId"]).iterate_items():
17    print(item)
Community logoMaintained by Community
Actor metrics
  • 1 monthly users
  • Created in Nov 2023
  • Modified 4 months ago

You might also like these Actors