skills.rest
reGeorge
reGeorgeCOMMUNITY
Explore all skills by this author →
GitHub

用例ID回填工具

Backfill test case IDs from the SDET platform into Feishu spreadsheets.

Updated Aug 27, 2026
Search Tags:#automation#data synchronization#feishu#test case management#sdet platform#id backfilling
One-click install
npx skills add https://github.com/reGeorge/caseHelperSkills --skill id
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: 用例ID回填工具
Source: https://github.com/reGeorge/caseHelperSkills/tree/main/skills/sdet-skills/case-id-backfiller
Command: npx skills add https://github.com/reGeorge/caseHelperSkills --skill id

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill automates the process of updating your test case management spreadsheets with the latest IDs from your test automation platform, ensuring data consistency and saving manual update time.

Core Features & Use Cases

  • Automated ID Synchronization: Automatically writes generated test case IDs from the SDET platform back into a designated column in your Feishu (Lark) spreadsheet.
  • Name-Based Matching: Accurately matches test cases between the platform and the spreadsheet using the test case name.
  • Use Case: After a batch creation of automated test cases in the SDET platform, use this Skill to instantly populate the 'Script ID' column in your Feishu test case tracker, maintaining a live link between your manual and automated test suites.

Quick Start

Run the python script scripts/write_case_id_cell_by_cell.py to update your Feishu spreadsheet with case IDs.

Frequently Asked Questions about 用例ID回填工具

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I automatically backfill test case IDs from the SDET platform into a Feishu spreadsheet?▼

To backfill test case IDs into a Feishu spreadsheet, this Skill matches test case names from the SDET platform and writes the corresponding IDs to the '脚本序号' column using the Feishu API.

What is the best way to synchronize test case names between my automation platform and Feishu sheets?▼

The best way to synchronize test case data is by using name-based matching. This process fetches case details from the SDET platform and updates specific cells in your target Feishu sheet to ensure data consistency.

Do I need to run a specific script to update the Script ID column in Feishu?▼

Yes, you need to run the Python script 'scripts/write_case_id_cell_by_cell.py' to execute the data synchronization and populate the designated column in your Feishu test case tracker.

Can I use this tool to maintain a live link between manual and automated test suites in Feishu?▼

Yes, you can use this tool after batch creating automated test cases in the SDET platform. It instantly populates the spreadsheet with IDs, maintaining a live link between your manual and automated test suites.

Does the tool update multiple Feishu cells at once or process data cell by cell?▼

The tool updates Feishu cells cell by cell. It utilizes the Feishu API to write the fetched SDET case IDs into specific cells within the target sheet sequentially based on name matching.

Related Skills

Explore More Software Engineering Skills→
TestAny-ioTestAny-io
79

case

Manage Testany platform test cases with CRUD and bulk operations.

Official
Intermediate
zephyrwang6zephyrwang6
333

feishu-wiki

Save Markdown documents to Feishu wiki and read bitable tables via Python scripts.

Community
Intermediate
hashSTACS-GlobalhashSTACS-Global
33

feishu-sheet

Automate Feishu spreadsheet read, write, append, find, create, and export operations.

Official
Advanced
yokingmayokingma
35

lark-sheets

Create, update, read/write cells, and export Feishu/Lark spreadsheets.

Community
Intermediate