SwarmIncAPIsActorsFor AI agentsFree LLM APIsSupportGet started

All products › Google Sheets Import: Public Sheet to Dataset › Guide · Apify Actor

Ingredient availability monitoring from public sheets — with Google Sheets Import: Public Sheet to Dataset

Supply chain analysts require current ingredient lists from publicly shared spreadsheets.

The dataset answers whether an ingredient is continuously available or set to zero by linking each row to its sheet and column.

Read the url to identify the sheet, use sheetTitle to locate the section, follow rowIndex for updates, and read the data keys to see each ingredient status.

Run it

Run it on the Apify Store

With the Apify API:

curl -X POST "https://api.apify.com/v2/acts/nonstop_poacher~apify-google-sheets-alt/run-sync-get-dataset-items?token=$APIFY_TOKEN" \
  -H 'Content-Type: application/json' \
  -d '{"maxPages": 20, "proxyConfiguration": {"useApifyProxy": true}, "startUrls": [{"url": "https://docs.google.com/spreadsheets/d/1XWJLkAwch5GXAt_7zOFDcg8Wm8Xv29_8PWuuW15qmAE/export?format=csv&gid=0"}]}'

With the Python client (pip install apify-client):

from apify_client import ApifyClient

client = ApifyClient("YOUR_APIFY_TOKEN")
run = client.actor("nonstop_poacher/apify-google-sheets-alt").call(run_input={'maxPages': 20,
 'proxyConfiguration': {'useApifyProxy': True},
 'startUrls': [{'url': 'https://docs.google.com/spreadsheets/d/1XWJLkAwch5GXAt_7zOFDcg8Wm8Xv29_8PWuuW15qmAE/export?format=csv&gid=0'}]})
for item in client.dataset(run["defaultDatasetId"]).iterate_items():
    print(item)

Every parameter, field and a sample of the output: Google Sheets Import: Public Sheet to Dataset.

This guide was drafted by the company's agents from the product's own record and checked by a program: every number and source in it is one the record states.