Which items are included in the generated QA list?

By default, the skill filters the spreadsheet to only include items marked as 'Open' or 'Reopen' to help you focus on pending tasks.

How does the skill handle different spreadsheet column names?

The skill uses flexible column mapping to identify relevant data like ID, Status, and Priority, allowing it to work with various header variations like 'Bug ID' or 'Ticket'.

Can I update my spreadsheet or image sources later?

Yes, you can simply tell Claude to 'update sources' to modify your saved links or local image paths at any time.

Do I need to enter my Google links every time I run the skill?

No, the skill automatically saves your configuration in a local source.json file after the first setup for future use.

What happens to the Google Drive links in my spreadsheet?

The skill resolves Google Drive file IDs to actual filenames and replaces the web links with your specified local directory path for easy local viewing.

QA List Generator

Name: QA List Generator
Author: potenlab

bypotenlab

生産性とワークフロー

Automates the creation of local QA tracking documents by syncing Google Sheets data with local image assets.

概要

The QA List Generator streamlines the bug-tracking workflow by extracting 'Open' and 'Reopen' items from Google Sheets and automatically converting Google Drive image links into local filesystem paths. It eliminates the manual effort of maintaining cross-referenced documentation by generating a ready-to-use Markdown checklist (qa-list-automated.md) featuring professional table formatting, centered status columns, and interactive checkboxes. This skill is ideal for developers who need to bridge the gap between cloud-based project management and local development environments.

主な機能

Persistent configuration management via source.json to prevent repetitive data entry
0 GitHub stars
Automatic extraction of Open and Reopen status items from Google Sheets via MCP
Professional Markdown generation with custom table alignment and task checkboxes
Dynamic mapping of Google Drive file links to specific local image directories
Flexible column mapping that adapts to various spreadsheet header naming conventions

ユースケース

Synchronizing project management spreadsheets with local development workflows
Converting cloud-based bug reports into offline documentation for faster asset previewing
Generating a daily local checklist for developers to address pending QA bugs

概要

主な機能

Persistent configuration management via source.json to prevent repetitive data entry
0 GitHub stars
Automatic extraction of Open and Reopen status items from Google Sheets via MCP
Professional Markdown generation with custom table alignment and task checkboxes
Dynamic mapping of Google Drive file links to specific local image directories
Flexible column mapping that adapts to various spreadsheet header naming conventions

ユースケース

Synchronizing project management spreadsheets with local development workflows
Converting cloud-based bug reports into offline documentation for faster asset previewing
Generating a daily local checklist for developers to address pending QA bugs