Sunday family meal planner in Notion with grocery email

Every Sunday at 8am local time, build my family's dinner plan for the upcoming week (Monday through Friday) and email me the grocery list. The trigger is a cron schedule.

Step 1. Call Tasty's List Tags first to confirm the valid filter slugs before searching. The dietary preferences I want applied are: under_30_minutes, vegetarian, and healthy. If any of these aren't valid slugs in the response, swap in the closest equivalent that is.

Step 2. Use Tasty's List Recipes (filtered by those tag slugs) to pick five dinner options. Rotate cuisines through the week so I don't get two similar meals back to back. For example, don't schedule Italian on both Monday and Tuesday. Tasty's List Recipes already returns ingredients, nutrition, prep time, and the recipe link inline, so don't make a second call per recipe.

Step 3. Check my Notion Meal Plans database for an existing page titled with this week's date range (formatted like "Jun 23 - Jun 29"). Use Query a Database to look it up. If one exists, update that page (Update a Page for properties, Update Page Content as Markdown to replace the body). If not, create a new page under that database (Create a Page) with the title set to the week range.

Step 4. On the Notion page, lay out Monday through Friday as a clean section per day. For each day include the recipe name, the recipe image (as an image block), the prep time, and a link back to the recipe on Tasty.

Step 5. Build a single consolidated grocery list by reasoning over the ingredients field returned by List Recipes. Group items into four sections: Produce, Protein, Dairy, and Pantry. Combine duplicate ingredients across recipes (e.g. if two recipes need garlic, list garlic once with a combined quantity). Append this grouped grocery list to the bottom of the Notion page.

Step 6. Email me the same categorized grocery list using Gmail's Send a Message. Subject line should be "Grocery list for <week range>" and the body should mirror the Produce / Protein / Dairy / Pantry sections so I can shop from my phone.

Keep it idempotent: re-running on the same Sunday must update the existing Notion page in place, never create a duplicate. The dietary preferences and the Notion Meal Plans database id should be configurable inputs so I can tweak them without editing the workflow.