Feishu Book Match

Fill book match results (匹配结果) and Amazon links (书籍链接) into a Feishu Bitable by querying Amazon with ISBN. Use when asked to match books, fill 匹配结果, 填充书籍链接,...

Security Scan

The skill's instructions and requirements are internally consistent with its stated purpose (query Amazon by ISBN and update a Feishu Bitable); nothing requested is disproportionate or unrelated.

Purpose & Capability

Name/description match the actions in SKILL.md: the skill reads Feishu table metadata/records, scrapes Amazon search results by ISBN, determines a match color, and updates the Bitable. No unrelated credentials, binaries, or installs are requested.

Instruction Scope

Instructions stay within the stated task (list fields, list records, open Amazon search pages in the provided browser relay, extract title/author/link, and update records). Caution: the instructions call for executing JavaScript in a browser relay on third-party pages (Amazon) which could access cookies or other page state if the relay profile is not isolated; the SKILL.md does not mention any isolation, rate limiting, or explicit handling of personalized results.

Install Mechanism

No install spec or external downloads — instruction-only skill (lowest install risk).

Credentials

No environment variables, secrets, or config paths are requested. The required Feishu bitable operations are appropriate for the described task.

Persistence & Privilege

always is false and the skill is user-invocable; it does not request permanent presence or system-wide configuration changes. It does mention background/cron usage as an operational suggestion but does not demand persistent privileges.

Assessment

This skill appears to do what it says: scrape Amazon search results by ISBN and update a Feishu Bitable. Before installing: (1) verify that the platform's Feishu bitable permissions granted to the skill are limited to the specific table/fields it needs; (2) run it against a copy of your table first to confirm it writes only intended fields; (3) confirm that the browser relay/profile used for Amazon searches is isolated (no personal Amazon session cookies) to avoid personalized or private data leakage; (4) be mindful of Amazon's scraping/rate-limit policies and avoid unattended high-volume runs unless you have permission; (5) if you require stronger assurance, request the skill author to add explicit notes about relay isolation and any expected result formats.

Fill 匹配结果 (match color) and 书籍链接 (Amazon detail link) for books in a Feishu Bitable by querying Amazon UK/US with ISBN.

Step-by-Step Workflow

1. Parse the Bitable URL

Use feishu_bitable_get_meta on the Feishu wiki/base URL to get app_token and table_id.

2. Confirm Field IDs

Use feishu_bitable_list_fields to find the field IDs. Expected field names:

• ISBN → field_id (e.g. fldbjxXubv)
• Title → field_id (e.g. fld8AkZOXn)
• Author → field_id (e.g. fldEVOXS5u)
• 匹配结果 → field_id (e.g. fldrgtxF6l)
• 书籍链接 → field_id (e.g. fldxZrhJeG)

3. Find Unprocessed Records

Use feishu_bitable_list_records with page_size=100. Filter to records where 匹配结果 is empty. Process in batches.

4. Query Amazon (Browser Relay)

Use Chrome browser relay (profile: "chrome-relay"):

Step A: Amazon UK search URL: https://www.amazon.co.uk/s?k={ISBN}

Step B: Check results

• If page shows "No results for your search query in Books" → try Amazon US: https://www.amazon.com/s?k={ISBN}
• If Amazon US also shows no results → mark 匹配结果 = 🔴 未匹配 → update Bitable → stop for this ISBN

Step C: Get first result info Take the first search result (usually div[data-cy="title-recipe"]). Extract:

• Title: from the heading inside div[data-cy="title-recipe"] or h2 a span
• Author: from the author line (often contains by text or a link)

5. Determine Match Color

Compare Amazon result with Excel Title and Author:

• 🟢 完全一致 (green): Title AND Author both match exactly
• 🟡 可能一致 (yellow): Title matches, Author similar or slightly different
• 🔴 很可能不同 (red): Title or Author clearly different

Common causes of yellow:

• Amazon shows audiobook narrator alongside author (e.g., "Ian Rankin and James Macpherson" where Macpherson is the narrator)
• Slight title variations (subtitle differences, punctuation)
• Author name formatting differences

6. Get Detail Link

Execute in the browser tab:

() => {
  const el = document.querySelector('div[data-cy="title-recipe"] a');
  return el ? el.href : null;
}

Strip query parameters — keep only the clean path:

# FROM: https://www.amazon.co.uk/Art-Edible-Flowers-.../dp/B07BQD9D5N?ref=...&dib=...
# TO:   https://www.amazon.co.uk/Art-Edible-Flowers-.../dp/B07BQD9D5N

7. Update Bitable Record

Use feishu_bitable_update_record:

{
  "匹配结果": "完全一致",
  "书籍链接": "https://www.amazon.co.uk/.../dp/ASIN"
}

Known Field IDs (RIVERSIDE_BOOKS Table)

Field	field_id
ISBN	fldbjxXubv
Title	fld8AkZOXn
Author	fldEVOXS5u
匹配结果	fldrgtxF6l
书籍链接	fldxZrhJeG

These are stable for the specific table tblskx3DEQkwhc9r. Always verify with feishu_bitable_list_fields if unsure.

Batch Processing

For large tables (2000+ records):

1. Process in batches of 20–50
2. Use feishu_bitable_list_records with page_token for pagination
3. Filter out already-processed records (匹配结果 not empty)
4. Report progress after each batch
5. Use background exec or cron if the task needs to run unattended

Tips

• ISBN normalization: Some ISBNs have dashes; Amazon search works better with dashes removed (e.g., 978-0857834768 → 9780857834768)
• CD/audiobook: Category 1 = "CD" often indicates audiobook — author on Amazon may differ (narrator vs author)
• No results on .co.uk: Always fall back to .com before marking as unmatched
• Chrome relay tab reuse: If a tab is already on the right URL, navigate to the new ISBN URL directly rather than opening a new tab