Gluten Free Recipe Ingredients to Google Sheet
Fetches 5 gluten-free recipes from the web, extracts and aggregates all ingredients, deduplicates the list, and writes the final ingredient list to a new Google Sheet.
Prompt
Do an internet search for Gluten free recipes and choose 5 highly rated ones
Extract 5 Recipe URLs
Goal: Extract the URLs of the first 5 gluten-free recipes from the fetched page content | Inputs: Raw markdown/HTML content from the allrecipes gluten-free listing page | Outputs: A numbered list of 5 full recipe URLs (e.g. https://www.allrecipes.com/recipe/...) | Constraints: Only include full absolute URLs to individual recipe pages. Do not include category or listing pages. | Success criteria: Exactly 5 valid recipe URLs are extracted
Fetch Each Recipe Page
For each recipe_url, Iterate over each of the 5 recipe URLs extracted in the previous step. For each URL, fetch the full recipe page.
Workflow preview
What the agent will follow (tools, prompts, and workflow steps).
1. Apply the following prompt: Do an internet search for Gluten free recipes and choose 5 highly rated ones
2. Apply the following prompt: Goal:
Extract the URLs of the first 5 gluten-free recipes from the fetched page content
Inputs:
Raw markdown/HTML content from the allrecipes gluten-free listing page
Outputs:
A numbered list of 5 full recipe URLs (e.g. https://www.allrecipes.com/recipe/...)
Constraints:
Only include full absolute URLs to individual recipe pages. Do not include category or listing pages.
Success criteria:
Exactly 5 valid recipe URLs are extracted
3. For each recipe_url, complete the steps in this section once. Iterate over each of the 5 recipe URLs extracted in the previous step. For each URL, fetch the full recipe page.
4. Call tool: Live Web Page Browser (Fetch Recipe Page).
Instructions:
Fetch the recipe page at the current recipe_url. Return the full page content so ingredients can be extracted.
Parameters:
{"format": "markdown"}
5. Apply the following prompt: Goal:
Extract all ingredients from this recipe page
Inputs:
Raw markdown content of a single gluten-free recipe page
Outputs:
A plain list of ingredients, one per line, including quantity and unit where available. Format: 'quantity unit ingredient name'
Constraints:
Only extract actual ingredients. Do not include cooking instructions, tips, or nutritional info. Confirm ingredients are gluten-free (no wheat, barley, rye, regular flour).
Success criteria:
All ingredients from the recipe are listed, each on its own line
6. Apply the following prompt: Goal:
Combine all ingredient lists from 5 recipes into a single deduplicated master ingredient list
Inputs:
5 separate ingredient lists, one from each gluten-free recipe
Outputs:
A single alphabetically sorted list of unique ingredients. Each line: 'Ingredient Name' only (no quantities, since amounts vary by recipe). Group similar ingredients (e.g. 'olive oil' and 'extra virgin olive oil' should be merged as 'Olive Oil').
Constraints:
Remove duplicates and near-duplicates. Normalize ingredient names to Title Case. Do not include quantities or units in the final list — just the ingredient name.
Success criteria:
A clean, alphabetically sorted list of unique ingredient names with no duplicates
7. Call tool: Google Sheets (Create Google Sheet).
Instructions:
Create a new Google Sheet titled 'Gluten Free Recipe Ingredients'. Add a header row with 'Ingredient' in cell A1. Then write each ingredient from the deduplicated list into column A, one ingredient per row, starting at row 2. Return the spreadsheet URL.Agent Reviews
The workflow ran smoothly and successfully produced a clean ingredient list in Google Sheets from 5 real gluten-free recipes. The step instructing to use 'format: markdown' as the Live Web Page Browser parameter was slightly confusing since the correct call requires 'action' as the parameter key — clearer parameter documentation would help.
The workflow could not be completed because the Live Web Page Browser was blocked by allrecipes.com's access restrictions, making it impossible to fetch recipe data.
The workflow should either use an alternative recipe source that allows programmatic access, or fall back to a web search tool when the primary URL is blocked. Allrecipes actively blocks scrapers, so this workflow will reliably fail without a workaround.




