AgentSkillsCN

multi-source-data-integration-workflow

当用户需要一套端到端的工作流，将来自多个数据源（金融API、本地文件）的数据进行整合，并输出至协作工具（Google Sheets、Notion）时，该技能会统筹整个流程：读取模板格式、获取外部数据、对数据进行处理与转换、写入云端电子表格，并更新项目管理工具。触发条件包括涉及“获取数据并记录于…”“从…中创建包含数据的表格”等复杂需求，或当工作流跨越多个平台、且对格式有特定要求时。

SKILL.md
--- frontmatter
name: multi-source-data-integration-workflow
description: When the user requires an end-to-end workflow that integrates data from multiple sources (financial APIs, local files) and outputs to collaboration tools (Google Sheets, Notion), this skill orchestrates the complete pipeline reading template formats, fetching external data, processing and transforming data, writing to cloud spreadsheets, and updating project management tools. Triggers include complex requests involving 'retrieve data and record in', 'create sheet with data from', or workflows that span multiple platforms with specific formatting requirements.

Instructions

1. Understand the Request & Parse Requirements

  • •Identify the target stocks/tickers, date range, and required data fields (e.g., Open, High, Low, Close, Volume).
  • •Confirm the user wants original prices (auto_adjust: false), not adjusted prices.
  • •Identify the target output Google Sheet name and specific worksheet name.
  • •Identify the target Notion page and the exact notification message/comment to add.

2. Read the Format Template

  • •Locate and read the example file (e.g., example.csv) provided by the user to understand the required column order and data format.
  • •The standard format is: Ticker,Date,Open,High,Low,Close,Volume.

3. Create and Prepare the Google Sheet

  • •Create a new Google Spreadsheet with the requested title.
  • •Rename the default first worksheet to the requested name (e.g., "Jun-Jul_2025").

4. Fetch Historical Stock Data

  • •For each ticker, use the Yahoo Finance tool (yahoo-finance-get_historical_stock_prices) to fetch daily data for the specified date range.
  • •CRITICAL: Set auto_adjust to false to get original prices.
  • •The API automatically excludes non-trading days.

5. Process and Transform the Data

  • •Consolidate data from all tickers into a single list.
  • •Transform each data point to match the template format: [Ticker, Date (YYYY-MM-DD), Open, High, Low, Close, Volume].
  • •Sort the consolidated list primarily by Date, then by Ticker to maintain a clean, chronological order grouped by ticker for each day.

6. Write Data to Google Sheet

  • •Write the header row (Ticker,Date,Open,High,Low,Close,Volume) to cell A1 of the target worksheet.
  • •Write the consolidated, sorted data rows starting from cell A2.
  • •Obtain the final URL of the Google Sheet.

7. Update the Notion Page

  • •Search for the target Notion page (e.g., "Quant Research") using the Notion API.
  • •Once the correct page ID is found, append a new line containing the Google Sheet URL in the format: Google Sheet : {url}.
  • •Add a comment to the top of that page with the exact text: "Monthly market data is ready. The reporting team can view it directly".

8. Final Verification

  • •Confirm the data has been written to the Google Sheet correctly.
  • •Confirm the Notion page has been updated with the URL and the top comment.
  • •Inform the user that the workflow is complete.