AI-Based User Story Generator & Azure DevOps Automation

📦 What You Get

• Plug-and-play n8n workflow (JSON format)
• Full documentation guide (PDF)

🚀 Why You Need This
Business Analysts and Product Managers waste hours reading lengthy PRD documents, manually extracting user stories, formatting tasks, and updating tools like Azure DevOps. This AI-powered system automates that entire journey—from doc to backlog—accurately and in seconds.

🛠 Tools & Stack Used

• Google Drive (Document source)
• n8n (Automation engine)
• OpenAI (AI-powered story generator)
• Google Sheets (For reviewing, editing, tracking)
• Azure DevOps (For backlog/ticket management)

🔄 Workflow Breakdown

Part 1 – From Document to Sheet

• Upload PRD or requirement doc to Google Drive
• Workflow downloads and extracts clean text from the PDF
• AI reads and generates structured user stories with tasks
• Each story is parsed and appended to a Google Sheet
• Status field added for review/approval

Part 2 – From Sheet to Azure DevOps

• Google Sheets updates trigger the second part of the workflow
• Azure API receives structured data via webhook
• Work items (tasks/stories) are created automatically in the correct backlog

💬 AI Prompt Capabilities

• Detects feature-level requirements and splits into user stories
• Suggests tasks under each story
• Adds metadata: status, priority, tags
• Ensures formatting matches DevOps schema
• Avoids duplication or ambiguous items

🔧 Sample Prompt Snippet
"You're a product analyst assistant. Based on the following PRD content, generate user stories using this format:

• User Story: As a [user], I want to [goal] so that [benefit]
• Tasks: [list of related technical subtasks]
  Status should default to 'Ready'. Avoid repeated or unclear points."

✅ Features & Benefits

• Converts unstructured PDF docs into clear user stories with tasks
• Uses AI for reliable, consistent output every time
• Google Sheets gives a human-friendly layer for review/editing
• Azure DevOps tickets created automatically—no extra clicks
• Scalable for multiple projects and clients
• Works with any PRD, requirement doc, or shared file

🧠 Who Should Use This

• Business Analysts
• Product Managers
• Scrum Masters
• PMOs in SaaS/Agile environments
• Agencies managing client delivery pipelines

⚠️ Smart Error Handling

• Halts on empty PDFs or unreadable files
• Retries failed API calls to OpenAI and Azure
• Validates output structure before writing to Sheets
• Avoids duplicate ticket creation with built-in checks
• Can restrict updates to weekdays only

📈 Benefits Recap

• Saves hours of manual effort
• Reduces human error in backlog creation
• Accelerates kickoff and sprint planning
• Boosts consistency and collaboration between BAs and dev teams

📞 Need Support or Custom Setup?

• 🌐 Website:www.thinknlink.in
• 📸 Instagram:instagram.com/thinknlink.in
• ▶️ YouTube:Yashraj | AI Solution - Thinknlink Channel
  Let’s automate your product pipeline — from doc to delivery.