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
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.