Description

What this workflow does

This workflow automates the process of analyzing source code files, generating structured testing plans via AI, and logging the results into Google Sheets. It streamlines the code review cycle, helps identify issues early, and improves collaboration across teams.

How it works

• The process starts when a user manually triggers the workflow or uploads code files.
• It reads code files from a specified directory, extracts their content, and processes the data in batches.
• The workflow sends the code snippets to an AI model (GPT-4.1-mini) which analyzes what the code does and generates a structured testing plan in JSON format.
• The testing plan is split into individual elements and selected details are extracted.
• Results are logged into a Google Sheet for tracking, documentation, and further review.

Setup & requirements

• Access to a code repository or files stored on disk
• OpenAI API credentials configured in n8n
• Google Sheets API credentials and permissions to update a specific spreadsheet
• No coding skills needed, only configuration of file paths and API keys
• Estimated setup complexity: Intermediate

Use cases

• Developers performing automated code reviews and test plan creation
• QA teams generating testing scenarios from code snippets
• Product teams documenting code functionality and testing strategies

Who is this for

• Tech startups and software development teams
• Development, QA, and product managers seeking automation
• Non-technical users looking to incorporate AI-powered code analysis

Why this matters

• Speeds up code review and testing preparation, saving hours per cycle
• Reduces human error in understanding complex code
• Enhances scalability by automating repetitive tasks