Gluten Free Recipe Ingredients to Google Sheet

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.