Ecommerce Competitor Analyzer

# E-commerce Competitor Analyzer Skill - Environment Variables
# Copy this file to `.env` and fill in your actual values

# ===================================================================
# REQUIRED API KEYS
# ===================================================================

# Olostep API Key
# Get your API key from: https://olostep.com/
# Pricing: 1000 free requests/month, $0.002/request
# IMPORTANT: Include the "olostep_" prefix in your key
# Example: olostep_xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
OLOSTEP_API_KEY=your_olostep_api_key_here

# Olostep API Version (v1 or v2)
# v1: /v1/scrapes - Recommended (do NOT use extract parameter)
# v2: /v2/agent/web-agent - Alternative if your key supports it
# Default: v1
# Recommendation: Use v1 without extract parameter for best accuracy
OLOSTEP_API_VERSION=v1

# Google Gemini API Key
# Get your API key from: https://aistudio.google.com/app/apikey
# Model used: gemini-3-flash-preview
GEMINI_API_KEY=your_gemini_api_key_here

# ===================================================================
# OPTIONAL CONFIGURATIONS
# ===================================================================

# Google Sheets API Credentials (OAuth2 JSON)
# Only needed if writing to Google Sheets
# See: https://console.cloud.google.com/apis/credentials
GOOGLE_SHEETS_CREDENTIALS='{"type":"service_account",...}'

# Default Google Sheets ID for output
GOOGLE_SHEETS_ID=YOUR_GOOGLE_SHEETS_ID_HERE

# Output directory for markdown reports
MARKDOWN_OUTPUT_DIR=./output

# ===================================================================
# ADVANCED SETTINGS
# ===================================================================

# Scraping settings
SCRAPER_COMMENTS_NUMBER=100
SCRAPER_TIMEOUT=120000

# Batch processing settings
MAX_BATCH_SIZE=20
CONCURRENCY_LIMIT=5

# ===================================================================
# SETUP INSTRUCTIONS
# ===================================================================

# 1. Olostep API Key:
#    - Sign up at https://olostep.com/
#    - Get API key from dashboard
#    - Free tier: 1000 requests/month
#
# 2. Google Gemini API Key:
#    - Visit https://aistudio.google.com/app/apikey
#    - Click "Create API Key"
#    - Copy the key
#
# 3. Google Sheets (Optional):
#    - Create Google Cloud Project
#    - Enable Google Sheets API
#    - Create OAuth2 credentials
#    - Download JSON credentials
#    - Paste content (single line) above

# Environment variables (contains API keys)
.env
.env.local
.env.*.local

# OAuth2 tokens
.google-tokens.json
*.tokens.json
service-account-key.json
.google-credentials.json

# Output files (generated results)
output/*.json
reports/*.md

# System files
.DS_Store
.DS_Store?
._*
.Spotlight-V100
.Trashes
ehthumbs.db
Thumbs.db

# IDE
.vscode/
.idea/
*.swp
*.swo
*~
.project
.classpath
.settings/

# Logs
*.log
npm-debug.log*
yarn-debug.log*
yarn-error.log*

# Node modules
node_modules/

# Test coverage
coverage/
.npm

# Temporary files
tmp/
temp/
*.tmp

# Development test scripts with hardcoded API keys
test-olostep-key.js

MIT License

Copyright (c) 2026 Buluslan@新西楼Newest AI

Permission is hereby granted, free of charge, to any person obtaining a copy
of this software and associated documentation files (the "Software"), to deal
in the Software without restriction, including without limitation the rights
to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
copies of the Software, and to permit persons to whom the Software is
furnished to do so, subject to the following conditions:

The above copyright notice and this permission notice shall be included in all
copies or substantial portions of the Software.

THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE
SOFTWARE.

# 电商平台配置
# 参考：n8n 工作流配置 (v81)

# 支持的平台
platforms:
  amazon:
    name: "Amazon"
    version: "1.0.0"
    status: "active"
    enabled: true

    # URL 匹配模式
    url_patterns:
      - "amazon.com"
      - "amazon.co.uk"
      - "amazon.de"
      - "amazon.es"
      - "amazon.fr"
      - "amazon.it"
      - "amazon.ca"
      - "amazon.co.jp"

    # ASIN 提取正则表达式
    asin_regex:
      standard: "/dp/([A-Z0-9]{10})"
      product_page: "/([A-Z0-9]{10})/ref="
      direct: "^[A-Z0-9]{10}$"

    # 爬虫配置
    scraper:
      provider: "olostep"
      api_endpoint: "https://api.olostep.com/v2/agent/web-agent"
      comments_to_scrape: 100  # 匹配 n8n 配置
      wait_time: 10
      timeout: 120000

    # 数据提取模式（来自 n8n "Code - 提取结构化数据" 节点）
    extraction_patterns:
      title:
        - regex: "产品标题[：:]+([^\\n]+)"
        - regex: "Title[：:]+([^\\n]+)"
        - default: "未知"
      price:
        - regex: "价格[：:]+[^0-9]*([0-9]+\\.?[0-9]*)"
        - regex: "Price[：:]+[^0-9]*([0-9]+\\.?[0-9]*)"
        - default: "未知"
      rating:
        - regex: "评分[：:]+[^0-9]*([0-9]+\\.?[0-9]*)"
        - regex: "Rating[：:]+[^0-9]*([0-9]+\\.?[0-9]*)"
        - default: "未知"

    # 输出格式（匹配 Google Sheets 结构）
    output_format:
      - "ASIN"
      - "产品标题"
      - "价格"
      - "评分"
      - "文案分析摘要"
      - "视觉分析摘要"
      - "评论分析摘要"
      - "市场分析摘要"

  # 未来平台（尚未实现）
  temu:
    name: "Temu"
    version: "0.0.1"
    status: "planned"
    enabled: false
    notes: "需要基于 Playwright 的爬虫"

  shopee:
    name: "Shopee"
    version: "0.0.1"
    status: "planned"
    enabled: false
    notes: "需要基于 Playwright 的爬虫"

# 全局设置
settings:
  # 批处理限制
  max_batch_size: 20
  concurrency_limit: 5
  retry_attempts: 3

  # API 超时设置
  scraping_timeout: 120000  # 2分钟
  analysis_timeout: 60000   # 1分钟

  # 错误处理
  continue_on_error: true
  require_all_success: false

  # 输出设置
  google_sheets_id: "YOUR_GOOGLE_SHEETS_ID_HERE"
  markdown_output_dir: "./output"

#!/usr/bin/env node

/**
 * Manual Google Sheets OAuth2 Authorization
 * Simpler alternative for users who prefer manual flow
 */

const fs = require('fs');
const path = require('path');
const readline = require('readline');

// Load environment variables
function loadEnv() {
  const envPath = path.join(__dirname, '..', '.env');
  const envContent = fs.readFileSync(envPath, 'utf8');
  const lines = envContent.split('\n');

  for (const line of lines) {
    const trimmedLine = line.trim();
    if (trimmedLine && !trimmedLine.startsWith('#')) {
      const [key, ...valueParts] = trimmedLine.split('=');
      const value = valueParts.join('=').trim();
      if (key && value) {
        process.env[key.trim()] = value;
      }
    }
  }
}

async function main() {
  console.log('\n' + '='.repeat(60));
  console.log('🔐 Google Sheets OAuth2 Manual Authorization');
  console.log('='.repeat(60) + '\n');

  loadEnv();

  const config = {
    clientId: process.env.GOOGLE_SHEETS_CLIENT_ID,
    clientSecret: process.env.GOOGLE_SHEETS_CLIENT_SECRET,
    redirectUri: process.env.GOOGLE_SHEETS_REDIRECT_URI || 'http://localhost:8080',
    sheetId: process.env.GOOGLE_SHEETS_ID_DEFAULT,
    sheetName: process.env.GOOGLE_SHEET_NAME_DEFAULT || '工作表1',
    gid: process.env.GOOGLE_SHEET_GID
  };

  if (!config.clientId || !config.clientSecret) {
    console.error('❌ Google Sheets credentials not found in .env');
    console.error('Please set GOOGLE_SHEETS_CLIENT_ID and GOOGLE_SHEETS_CLIENT_SECRET');
    process.exit(1);
  }

  console.log('📋 Configuration:');
  console.log(`   Spreadsheet ID: ${config.sheetId}`);
  console.log(`   Sheet Name: ${config.sheetName}`);
  if (config.gid) {
    console.log(`   GID: ${config.gid}`);
  }
  console.log();

  // Generate auth URL
  const crypto = require('crypto');
  const state = crypto.randomBytes(16).toString('hex');

  const scope = 'https://www.googleapis.com/auth/spreadsheets';
  const params = new URLSearchParams({
    client_id: config.clientId,
    redirect_uri: config.redirectUri,
    scope: scope,
    response_type: 'code',
    state: state,
    access_type: 'offline',
    prompt: 'consent'
  });

  const authUrl = `https://accounts.google.com/o/oauth2/v2/auth?${params.toString()}`;

  console.log('🔗 Step 1: Open this URL in your browser:\n');
  console.log(`   ${authUrl}\n`);

  console.log('⚠️  Important: Make sure your OAuth2 client has this redirect URI:');
  console.log(`   ${config.redirectUri}\n`);

  console.log('📝 Step 2: After authorizing, you will be redirected to a page');
  console.log('   that shows an error (this is normal).');
  console.log('   Copy the "code" parameter from the URL.\n');

  const rl = readline.createInterface({
    input: process.stdin,
    output: process.stdout
  });

  rl.question('Paste the authorization code here: ', async (code) => {
    code = code.trim();

    if (!code) {
      console.log('\n❌ No code provided. Authorization canceled.');
      rl.close();
      process.exit(1);
    }

    console.log('\n🔄 Exchanging code for tokens...');

    try {
      const response = await fetch('https://oauth2.googleapis.com/token', {
        method: 'POST',
        headers: {
          'Content-Type': 'application/x-www-form-urlencoded'
        },
        body: new URLSearchParams({
          code: code,
          client_id: config.clientId,
          client_secret: config.clientSecret,
          redirect_uri: config.redirectUri,
          grant_type: 'authorization_code'
        })
      });

      if (!response.ok) {
        const error = await response.text();
        throw new Error(`Token exchange failed: ${error}`);
      }

      const tokens = await response.json();

      // Save tokens
      const tokenPath = path.join(__dirname, '..', '.google-tokens.json');
      const tokenData = {
        ...tokens,
        expiry_date: Date.now() + (tokens.expires_in * 1000)
      };

      fs.writeFileSync(tokenPath, JSON.stringify(tokenData, null, 2));

      console.log('✅ Authorization successful!\n');
      console.log('   Tokens saved to: .google-tokens.json');
      console.log('   Access Token: ' + tokens.access_token.substring(0, 20) + '...');
      if (tokens.refresh_token) {
        console.log('   Refresh Token: ' + tokens.refresh_token.substring(0, 20) + '...');
      }

      console.log('\n' + '='.repeat(60));
      console.log('✅ You can now use the skill to write to Google Sheets!');
      console.log('='.repeat(60) + '\n');

      rl.close();
    } catch (error) {
      console.error('\n❌ Authorization failed:', error.message);
      console.error('\nPossible issues:');
      console.error('1. Invalid authorization code');
      console.error('2. Redirect URI mismatch in OAuth2 client settings');
      console.error('3. OAuth2 client does not have correct scopes');
      rl.close();
      process.exit(1);
    }
  });
}

main();

#!/usr/bin/env node

/**
 * Google Sheets Service Account Setup Guide
 *
 * Service accounts are simpler than OAuth2 for server-to-server communication
 * No user authorization required - just need to share the sheet with the service account email
 */

const fs = require('fs');
const path = require('path');

console.log('\n' + '='.repeat(70));
console.log('🔐 Google Sheets Service Account Setup');
console.log('='.repeat(70) + '\n');

console.log('Service accounts are recommended for server applications.\n');

console.log('📋 Steps to set up:\n');

console.log('1. Create a Service Account');
console.log('   - Go to: https://console.cloud.google.com/iam-admin/serviceaccounts');
console.log('   - Click "Create Service Account"');
console.log('   - Name: ecommerce-competitor-analyzer');
console.log('   - Click "Create and Continue"\n');

console.log('2. Grant Permissions');
console.log('   - Role: Editor (or Sheets Editor)\n');

console.log('3. Create Key');
console.log('   - Click on the service account');
console.log('   - Go to "Keys" tab');
console.log('   - Click "Add Key" → "Create New Key"');
console.log('   - Key type: JSON');
console.log('   - Download the JSON file\n');

console.log('4. Save the Key');
console.log('   - Rename the downloaded file to: service-account-key.json');
console.log('   - Move it to: ' + path.join(__dirname, '..'));
console.log('   - Or paste the content below:\n');

console.log('5. Share the Google Sheet');
console.log('   - Open your Google Sheet');
console.log('   - Click "Share" button');
console.log('   - Add the service account email (looks like: xxx@xxx.iam.gserviceaccount.com)');
console.log('   - Grant "Editor" permission\n');

console.log('6. Update .env file');
console.log('   - Add: GOOGLE_SHEETS_USE_SERVICE_ACCOUNT=true');
console.log('   - Remove or comment out: GOOGLE_SHEETS_CLIENT_ID/SECRET/REDIRECT_URI\n');

console.log('='.repeat(70));
console.log('✅ After completing these steps, the skill will use service account auth');
console.log('='.repeat(70) + '\n');

// Check if service account key already exists
const keyPath = path.join(__dirname, '..', 'service-account-key.json');
if (fs.existsSync(keyPath)) {
  console.log('✅ Service account key found at: service-account-key.json');
  console.log('   You can skip step 4!\n');
} else {
  console.log('⚠️  Service account key not found');
  console.log('   Please complete step 4 to create and save the key\n');
}

#!/usr/bin/env node

/**
 * Google Sheets OAuth2 Authorization Script
 * Run this script to authorize access to Google Sheets
 */

const fs = require('fs');
const path = require('path');

// Load environment variables
function loadEnv() {
  const envPath = path.join(__dirname, '..', '.env');
  if (!fs.existsSync(envPath)) {
    console.error('❌ .env file not found');
    process.exit(1);
  }

  const envContent = fs.readFileSync(envPath, 'utf8');
  const lines = envContent.split('\n');

  for (const line of lines) {
    const trimmedLine = line.trim();
    if (trimmedLine && !trimmedLine.startsWith('#')) {
      const [key, ...valueParts] = trimmedLine.split('=');
      const value = valueParts.join('=').trim();
      if (key && value) {
        process.env[key.trim()] = value;
      }
    }
  }
}

// Check dependencies
function checkDependencies() {
  try {
    require('http');
    require('crypto');
  } catch (error) {
    console.error('❌ Missing required dependencies');
    console.error('Please ensure you are running Node.js 14+');
    process.exit(1);
  }
}

// Main authorization flow
async function main() {
  console.log('\n' + '='.repeat(60));
  console.log('🔐 Google Sheets OAuth2 Authorization');
  console.log('='.repeat(60) + '\n');

  loadEnv();
  checkDependencies();

  const { getAuthUrl, exchangeCodeForToken, config } = require('./google-sheets-writer.js');

  // Check configuration
  if (!config.clientId || !config.clientSecret) {
    console.error('❌ Google Sheets credentials not found in .env');
    console.error('Please set GOOGLE_SHEETS_CLIENT_ID and GOOGLE_SHEETS_CLIENT_SECRET');
    process.exit(1);
  }

  console.log('📋 Configuration:');
  console.log(`   Spreadsheet ID: ${config.sheetId}`);
  console.log(`   Sheet Name: ${config.sheetName}`);
  if (config.gid) {
    console.log(`   GID: ${config.gid}`);
  }
  console.log();

  // Generate authorization URL
  const { url, state } = getAuthUrl();

  console.log('🔗 Step 1: Open this URL in your browser:\n');
  console.log(`   ${url}\n`);
  console.log('⚠️  Note: If the redirect URI mismatch error occurs, update your OAuth2 client');
  console.log(`   to include this redirect URI: ${config.redirectUri}\n`);

  // Start a simple HTTP server to handle callback
  const http = require('http');
  const server = http.createServer((req, res) => {
    const url = new URL(req.url, `http://${req.headers.host}`);

    if (url.pathname === '/callback') {
      const code = url.searchParams.get('code');
      const returnedState = url.searchParams.get('state');

      if (returnedState !== state) {
        res.writeHead(400);
        res.end('Invalid state parameter');
        console.error('❌ State mismatch');
        server.close();
        return;
      }

      if (code) {
        console.log('\n✅ Received authorization code');
        console.log('🔄 Exchanging for tokens...');

        exchangeCodeForToken(code)
          .then((tokens) => {
            console.log('✅ Authorization successful!\n');
            console.log('   Tokens saved to: .google-tokens.json');
            console.log('   Access Token: ' + tokens.access_token.substring(0, 20) + '...');
            if (tokens.refresh_token) {
              console.log('   Refresh Token: ' + tokens.refresh_token.substring(0, 20) + '...');
            }
            console.log('\n' + '='.repeat(60));
            console.log('✅ You can now use the skill to write to Google Sheets!');
            console.log('='.repeat(60) + '\n');

            res.writeHead(200, { 'Content-Type': 'text/html' });
            res.end(`
              <html>
                <head>
                  <title>Authorization Successful</title>
                  <style>
                    body { font-family: Arial, sans-serif; text-align: center; padding: 50px; }
                    .success { color: #4CAF50; font-size: 24px; }
                  </style>
                </head>
                <body>
                  <div class="success">✅ Authorization Successful!</div>
                  <p>You can close this window and return to the terminal.</p>
                </body>
              </html>
            `);

            server.close();
            setTimeout(() => process.exit(0), 1000);
          })
          .catch((error) => {
            console.error('\n❌ Token exchange failed:', error.message);
            res.writeHead(500, { 'Content-Type': 'text/html' });
            res.end(`
              <html>
                <head><title>Authorization Failed</title></head>
                <body>
                  <h1>❌ Authorization Failed</h1>
                  <p>${error.message}</p>
                </body>
              </html>
            `);
            server.close();
            setTimeout(() => process.exit(1), 1000);
          });
      } else {
        const error = url.searchParams.get('error');
        console.error('\n❌ Authorization denied:', error);
        res.writeHead(400, { 'Content-Type': 'text/html' });
        res.end(`
          <html>
            <head><title>Authorization Failed</title></head>
            <body>
              <h1>❌ Authorization Failed</h1>
              <p>Reason: ${error}</p>
            </body>
          </html>
        `);
        server.close();
        setTimeout(() => process.exit(1), 1000);
      }
    } else {
      res.writeHead(404);
      res.end('Not found');
    }
  });

  const PORT = 8081;
  server.listen(PORT, () => {
    console.log(`🌐 Local server started on http://localhost:${PORT}`);
    console.log('⏳ Waiting for authorization callback...\n');
  });

  // Timeout after 5 minutes
  setTimeout(() => {
    console.log('\n⏱️ Authorization timeout (5 minutes)');
    server.close();
    process.exit(1);
  }, 5 * 60 * 1000);
}

// Run the script
main().catch(error => {
  console.error('❌ Error:', error);
  process.exit(1);
});

#!/bin/bash

# Google Sheets OAuth2 配置指南

echo "============================================================"
echo "🔧 Google Sheets OAuth2 重定向 URI 配置指南"
echo "============================================================"
echo ""
echo "❌ 错误: redirect_uri_mismatch"
echo ""
echo "这是因为你的 OAuth2 客户端配置中没有添加对应的重定向 URI"
echo ""
echo "━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━"
echo "📋 解决步骤:"
echo "━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━"
echo ""
echo "1️⃣  打开 Google Cloud Console:"
echo "   https://console.cloud.google.com/apis/credentials"
echo ""
echo "2️⃣  找到 OAuth 2.0 客户端 ID:"
echo "   994295017900-j3hrfe9f53fil0fe1ek7lbd1ao1df5es.apps.googleusercontent.com"
echo ""
echo "3️⃣  点击 '编辑' (或点击铅笔图标)"
echo ""
echo "4️⃣  在 '已授权的重定向 URI' 部分，点击 '添加 URI'"
echo ""
echo "5️⃣  添加以下 URI（任选其一或全部）:"
echo ""
echo "   推荐（最简单）:"
echo "   urn:ietf:wg:oauth:2.0:oob"
echo ""
echo "   或者（本地回调）:"
echo "   http://localhost:8081"
echo "   http://localhost:8082"
echo ""
echo "6️⃣  点击 '保存'"
echo ""
echo "━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━"
echo "⏳ 等待几分钟后，重新运行授权脚本:"
echo "━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━"
echo ""
echo "   node scripts/auth-oob.js"
echo ""
echo "============================================================"
echo ""
echo "💡 提示:"
echo "   - 如果添加了 'urn:ietf:wg:oauth:2.0:oob'，授权码会直接显示在浏览器中"
echo "   - 如果添加了 'http://localhost:xxxx'，需要本地服务器监听回调"
echo "   - 修改后可能需要等待 1-2 分钟才能生效"
echo ""

#!/usr/bin/env node

/**
 * 手动授权流程 - 从浏览器 URL 复制授权码
 */

const fs = require('fs');
const path = require('path');
const readline = require('readline');

function loadEnv() {
  const envPath = path.join(__dirname, '..', '.env');
  const envContent = fs.readFileSync(envPath, 'utf8');
  const lines = envContent.split('\n');

  for (const line of lines) {
    const trimmedLine = line.trim();
    if (trimmedLine && !trimmedLine.startsWith('#')) {
      const [key, ...valueParts] = trimmedLine.split('=');
      const value = valueParts.join('=').trim();
      if (key && value) {
        process.env[key.trim()] = value;
      }
    }
  }
}

async function main() {
  console.log('\n' + '='.repeat(70));
  console.log('🔐 Google Sheets 手动授权流程');
  console.log('='.repeat(70) + '\n');

  loadEnv();

  const config = {
    clientId: process.env.GOOGLE_SHEETS_CLIENT_ID,
    clientSecret: process.env.GOOGLE_SHEETS_CLIENT_SECRET,
    redirectUri: process.env.GOOGLE_SHEETS_REDIRECT_URI || 'http://localhost:8081',
    sheetId: process.env.GOOGLE_SHEETS_ID_DEFAULT
  };

  console.log('📋 配置信息:');
  console.log(`   客户端 ID: ${config.clientId.substring(0, 20)}...`);
  console.log(`   重定向 URI: ${config.redirectUri}`);
  console.log(`   表格 ID: ${config.sheetId}\n`);

  // Generate auth URL
  const scope = 'https://www.googleapis.com/auth/spreadsheets';
  const params = new URLSearchParams({
    client_id: config.clientId,
    redirect_uri: config.redirectUri,
    scope: scope,
    response_type: 'code',
    access_type: 'offline',
    prompt: 'consent'
  });

  const authUrl = `https://accounts.google.com/o/oauth2/v2/auth?${params.toString()}`;

  console.log('━'.repeat(70));
  console.log('📍 步骤 1：在浏览器中打开以下 URL');
  console.log('━'.repeat(70));
  console.log(`\n${authUrl}\n`);
  console.log('💡 提示：选中 URL 后按 Cmd+C 复制\n');

  console.log('━'.repeat(70));
  console.log('📍 步骤 2：授权后处理');
  console.log('━'.repeat(70));
  console.log(`
   1. 登录你的 Google 账号
   2. 点击"允许"授权应用访问 Google Sheets
   3. 浏览器会尝试跳转到 ${config.redirectUri}
   4. 你会看到类似 "无法访问此网站" 或页面不存在（这是正常的！）
   5. ⚠️  **重要**：复制浏览器地址栏中的完整 URL
   6. 里面包含授权码（code 参数）

   示例 URL:
   ${config.redirectUri}/?code=4/0Axxxxxxxxxxxx&scope=...
                    ↑
                这部分就是授权码
`);

  const rl = readline.createInterface({
    input: process.stdin,
    output: process.stdout
  });

  rl.question('\n🔑 粘贴完整的回调 URL (或只粘贴授权码): ', async (input) => {
    input = input.trim();

    if (!input) {
      console.log('\n❌ 未输入授权信息。授权已取消。');
      rl.close();
      process.exit(1);
    }

    // Extract code from URL or use input directly
    let code = input;
    if (input.includes('code=')) {
      const match = input.match(/[?&]code=([^&]+)/);
      if (match) {
        code = match[1];
      }
    }

    if (code.length < 10) {
      console.log('\n❌ 授权码太短，可能不完整。');
      rl.close();
      process.exit(1);
    }

    console.log('\n⏳ 正在交换令牌...');
    console.log(`   授权码: ${code.substring(0, 20)}...\n`);

    try {
      const response = await fetch('https://oauth2.googleapis.com/token', {
        method: 'POST',
        headers: {
          'Content-Type': 'application/x-www-form-urlencoded'
        },
        body: new URLSearchParams({
          code: code,
          client_id: config.clientId,
          client_secret: config.clientSecret,
          redirect_uri: config.redirectUri,
          grant_type: 'authorization_code'
        })
      });

      if (!response.ok) {
        const errorText = await response.text();
        let errorMsg = `令牌交换失败 (${response.status})`;

        try {
          const errorJson = JSON.parse(errorText);
          if (errorJson.error) {
            errorMsg = `错误: ${errorJson.error}`;
            if (errorJson.error_description) {
              errorMsg += `\n${errorJson.error_description}`;
            }
          }
        } catch (e) {
          errorMsg += `\n${errorText}`;
        }

        throw new Error(errorMsg);
      }

      const tokens = await response.json();

      // Save tokens
      const tokenPath = path.join(__dirname, '..', '.google-tokens.json');
      const tokenData = {
        ...tokens,
        expiry_date: Date.now() + (tokens.expires_in * 1000)
      };

      fs.writeFileSync(tokenPath, JSON.stringify(tokenData, null, 2));

      console.log('━'.repeat(70));
      console.log('✅ 授权成功！');
      console.log('━'.repeat(70));
      console.log(`\n📁 令牌已保存: ${tokenPath}`);
      console.log(`\n🔑 访问令牌: ${tokens.access_token.substring(0, 40)}...`);

      if (tokens.refresh_token) {
        console.log(`🔄 刷新令牌: ${tokens.refresh_token.substring(0, 40)}...`);
      }

      console.log('\n━'.repeat(70));
      console.log('🎉 现在可以使用 skill 写入 Google Sheets 了！');
      console.log('━'.repeat(70));

      console.log('\n🧪 测试命令:');
      console.log('   node scripts/test-skill.js B08LNY11RK');

      console.log('\n📊 结果将写入:');
      console.log(`   https://docs.google.com/spreadsheets/d/${config.sheetId}\n`);

      rl.close();
      process.exit(0);
    } catch (error) {
      console.error('\n' + '━'.repeat(70));
      console.error('❌ 授权失败');
      console.error('━'.repeat(70));
      console.error(`\n${error.message}\n`);

      console.error('💡 常见问题:');
      console.error('1. 授权码已过期（重新获取）');
      console.error('2. 重定向 URI 未在 Google Cloud Console 中配置');
      console.error(`   需要添加: ${config.redirectUri}`);
      console.error('3. 授权码格式不正确\n');

      rl.close();
      process.exit(1);
    }
  });
}

main();

#!/usr/bin/env node

/**
 * Out-of-Band Google Sheets Authorization
 * Authorization code will be displayed in the browser - just copy and paste
 */

const fs = require('fs');
const path = require('path');
const readline = require('readline');

function loadEnv() {
  const envPath = path.join(__dirname, '..', '.env');
  const envContent = fs.readFileSync(envPath, 'utf8');
  const lines = envContent.split('\n');

  for (const line of lines) {
    const trimmedLine = line.trim();
    if (trimmedLine && !trimmedLine.startsWith('#')) {
      const [key, ...valueParts] = trimmedLine.split('=');
      const value = valueParts.join('=').trim();
      if (key && value) {
        process.env[key.trim()] = value;
      }
    }
  }
}

async function main() {
  console.log('\n' + '='.repeat(70));
  console.log('🔐 Google Sheets 授权 (复制粘贴方式)');
  console.log('='.repeat(70) + '\n');

  loadEnv();

  console.log('⚠️  首次使用？请确保在 Google Cloud Console 添加此重定向 URI：');
  console.log('   urn:ietf:wg:oauth:2.0:oob\n');

  const config = {
    clientId: process.env.GOOGLE_SHEETS_CLIENT_ID,
    clientSecret: process.env.GOOGLE_SHEETS_CLIENT_SECRET,
    redirectUri: 'urn:ietf:wg:oauth:2.0:oob',
    sheetId: process.env.GOOGLE_SHEETS_ID_DEFAULT
  };

  // Generate auth URL
  const scope = 'https://www.googleapis.com/auth/spreadsheets';
  const params = new URLSearchParams({
    client_id: config.clientId,
    redirect_uri: config.redirectUri,
    scope: scope,
    response_type: 'code',
    access_type: 'offline',
    prompt: 'consent'
  });

  const authUrl = `https://accounts.google.com/o/oauth2/v2/auth?${params.toString()}`;

  console.log('📋 步骤 1：复制以下 URL 并在浏览器中打开\n');
  console.log('─'.repeat(70));
  console.log(authUrl);
  console.log('─'.repeat(70));
  console.log('\n💡 提示：点击上方 URL 会自动复制（取决于终端）\n');

  console.log('📝 步骤 2：完成授权后');
  console.log('   - 浏览器会显示一个授权码');
  console.log('   - 复制这个授权码\n');

  const rl = readline.createInterface({
    input: process.stdin,
    output: process.stdout
  });

  rl.question('🔑 粘贴授权码: ', async (code) => {
    code = code.trim();

    if (!code || code.length < 10) {
      console.log('\n❌ 授权码无效。授权已取消。');
      rl.close();
      process.exit(1);
    }

    console.log('\n⏳ 正在交换令牌...');

    try {
      const response = await fetch('https://oauth2.googleapis.com/token', {
        method: 'POST',
        headers: {
          'Content-Type': 'application/x-www-form-urlencoded'
        },
        body: new URLSearchParams({
          code: code,
          client_id: config.clientId,
          client_secret: config.clientSecret,
          redirect_uri: config.redirectUri,
          grant_type: 'authorization_code'
        })
      });

      if (!response.ok) {
        const errorText = await response.text();
        let errorMsg = `令牌交换失败: ${response.status}`;

        try {
          const errorJson = JSON.parse(errorText);
          if (errorJson.error) {
            errorMsg = `错误: ${errorJson.error}`;
            if (errorJson.error_description) {
              errorMsg += `\n说明: ${errorJson.error_description}`;
            }
          }
        } catch (e) {
          // Not JSON, use text
        }

        throw new Error(errorMsg);
      }

      const tokens = await response.json();

      // Save tokens
      const tokenPath = path.join(__dirname, '..', '.google-tokens.json');
      const tokenData = {
        ...tokens,
        expiry_date: Date.now() + (tokens.expires_in * 1000)
      };

      fs.writeFileSync(tokenPath, JSON.stringify(tokenData, null, 2));

      console.log('\n' + '='.repeat(70));
      console.log('✅ 授权成功！');
      console.log('='.repeat(70));

      console.log('\n📁 令牌已保存到:');
      console.log(`   ${tokenPath}`);

      console.log('\n🔑 访问令牌:');
      console.log('   ' + tokens.access_token.substring(0, 40) + '...');

      if (tokens.refresh_token) {
        console.log('\n🔄 刷新令牌:');
        console.log('   ' + tokens.refresh_token.substring(0, 40) + '...');
      }

      console.log('\n' + '='.repeat(70));
      console.log('🎉 现在可以使用 skill 写入 Google Sheets 了！');
      console.log('='.repeat(70));

      console.log('\n🧪 测试一下：');
      console.log('   node scripts/test-skill.js B08LNY11RK');

      console.log('\n📊 结果将写入到:');
      console.log(`   https://docs.google.com/spreadsheets/d/${config.sheetId}\n`);

      rl.close();
      process.exit(0);
    } catch (error) {
      console.error('\n' + '='.repeat(70));
      console.error('❌ 授权失败');
      console.error('='.repeat(70));
      console.error(`\n错误: ${error.message}\n`);

      console.error('💡 可能的问题:');
      console.error('1. 授权码无效或已过期（重新获取）');
      console.error('2. 重定向 URI 未在 Google Cloud Console 中配置');
      console.error('   请添加: urn:ietf:wg:oauth:2.0:oob');
      console.error('3. OAuth 客户端配置错误\n');

      rl.close();
      process.exit(1);
    }
  });
}

main();

#!/usr/bin/env node

/**
 * Simple Manual Google Sheets Authorization
 * Copy authorization code from browser URL
 */

const fs = require('fs');
const path = require('path');
const readline = require('readline');

// Load environment variables
function loadEnv() {
  const envPath = path.join(__dirname, '..', '.env');
  const envContent = fs.readFileSync(envPath, 'utf8');
  const lines = envContent.split('\n');

  for (const line of lines) {
    const trimmedLine = line.trim();
    if (trimmedLine && !trimmedLine.startsWith('#')) {
      const [key, ...valueParts] = trimmedLine.split('=');
      const value = valueParts.join('=').trim();
      if (key && value) {
        process.env[key.trim()] = value;
      }
    }
  }
}

async function main() {
  console.log('\n' + '='.repeat(70));
  console.log('🔐 Google Sheets 手动授权');
  console.log('='.repeat(70) + '\n');

  loadEnv();

  const config = {
    clientId: process.env.GOOGLE_SHEETS_CLIENT_ID,
    clientSecret: process.env.GOOGLE_SHEETS_CLIENT_SECRET,
    redirectUri: process.env.GOOGLE_SHEETS_REDIRECT_URI || 'urn:ietf:wg:oauth:2.0:oob',
    sheetId: process.env.GOOGLE_SHEETS_ID_DEFAULT
  };

  console.log('📋 配置:');
  console.log(`   Spreadsheet ID: ${config.sheetId}\n`);

  // Generate auth URL using "out of band" redirect URI
  const scope = 'https://www.googleapis.com/auth/spreadsheets';
  const params = new URLSearchParams({
    client_id: config.clientId,
    redirect_uri: config.redirectUri,
    scope: scope,
    response_type: 'code',
    access_type: 'offline',
    prompt: 'consent'
  });

  const authUrl = `https://accounts.google.com/o/oauth2/v2/auth?${params.toString()}`;

  console.log('🔗 步骤 1：在浏览器中打开以下 URL：\n');
  console.log(`   ${authUrl}\n`);

  console.log('📝 步骤 2：授权后，会显示一个授权码');
  console.log('   复制这个授权码\n');

  const rl = readline.createInterface({
    input: process.stdin,
    output: process.stdout
  });

  rl.question('粘贴授权码: ', async (code) => {
    code = code.trim();

    if (!code) {
      console.log('\n❌ 未提供授权码。授权已取消。');
      rl.close();
      process.exit(1);
    }

    console.log('\n🔄 正在交换令牌...');

    try {
      const response = await fetch('https://oauth2.googleapis.com/token', {
        method: 'POST',
        headers: {
          'Content-Type': 'application/x-www-form-urlencoded'
        },
        body: new URLSearchParams({
          code: code,
          client_id: config.clientId,
          client_secret: config.clientSecret,
          redirect_uri: config.redirectUri,
          grant_type: 'authorization_code'
        })
      });

      if (!response.ok) {
        const error = await response.text();
        throw new Error(`令牌交换失败: ${error}`);
      }

      const tokens = await response.json();

      // Save tokens
      const tokenPath = path.join(__dirname, '..', '.google-tokens.json');
      const tokenData = {
        ...tokens,
        expiry_date: Date.now() + (tokens.expires_in * 1000)
      };

      fs.writeFileSync(tokenPath, JSON.stringify(tokenData, null, 2));

      console.log('\n✅ 授权成功！\n');
      console.log('   令牌已保存到: .google-tokens.json');
      console.log('   访问令牌: ' + tokens.access_token.substring(0, 30) + '...');
      if (tokens.refresh_token) {
        console.log('   刷新令牌: ' + tokens.refresh_token.substring(0, 30) + '...');
      }

      console.log('\n' + '='.repeat(70));
      console.log('✅ 现在可以使用 skill 写入 Google Sheets 了！');
      console.log('='.repeat(70) + '\n');

      console.log('🧪 测试一下：');
      console.log('   node scripts/test-skill.js B08LNY11RK\n');

      rl.close();
      process.exit(0);
    } catch (error) {
      console.error('\n❌ 授权失败:', error.message);
      console.error('\n可能的问题:');
      console.error('1. 授权码无效或已过期');
      console.error('2. 客户端密钥不正确');
      console.error('3. 重定向 URI 不匹配');
      rl.close();
      process.exit(1);
    }
  });
}

main();

/**
 * Batch Processor for E-commerce Competitor Analysis
 *
 * Core processing engine that orchestrates:
 * 1. Product scraping (Olostep API)
 * 2. AI analysis (Gemini)
 * 3. Structured output (Google Sheets + Markdown)
 *
 * Based on n8n workflow batch processing pattern (v81)
 * Reference: 工作流配置.json - "Code - 提取结构化数据" node
 */

const { scrapeAmazonProduct, batchScrapeAmazon, extractASIN } = require('./scrape-amazon.js');

/**
 * Parse Google Sheets specification from user input
 * @param {string} userInput - User's text input
 * @returns {Object} - Parsed sheet configuration
 */
function parseGoogleSheetsSpec(userInput) {
  if (!userInput) {
    // Return default from env
    return {
      sheetId: process.env.GOOGLE_SHEETS_ID_DEFAULT || null,
      sheetName: process.env.GOOGLE_SHEET_NAME_DEFAULT || '工作表1',
      source: 'default'
    };
  }

  const input = userInput.toLowerCase();

  // Pattern 1: Sheet ID (e.g., "Sheet ID: abc123" or "SheetID:abc123")
  const sheetIdMatch = userInput.match(/sheet\s*id\s*[:：]\s*([a-zA-Z0-9-_]+)/);
  if (sheetIdMatch) {
    return {
      sheetId: sheetIdMatch[1],
      sheetName: '工作表1',
      source: 'explicit_id'
    };
  }

  // Pattern 2: Google Sheets URL (e.g., "https://docs.google.com/spreadsheets/d/abc123")
  const urlMatch = userInput.match(/docs\.google\.com\/spreadsheets\/d\/([a-zA-Z0-9-_]+)/);
  if (urlMatch) {
    return {
      sheetId: urlMatch[1],
      sheetName: '工作表1',
      source: 'url'
    };
  }

  // Pattern 3: Table name (e.g., "写入到表格\"我的竞品分析\"")
  const nameMatch = userInput.match(/表格["""](.+?)["""]|表格\s*[:：]\s*(.+)/);
  if (nameMatch) {
    return {
      sheetId: null,  // Will search by name
      sheetName: nameMatch[1] || nameMatch[2],
      source: 'name'
    };
  }

  // Return default
  return {
    sheetId: process.env.GOOGLE_SHEETS_ID_DEFAULT || null,
    sheetName: process.env.GOOGLE_SHEET_NAME_DEFAULT || '工作表1',
    source: 'default'
  };
}

/**
 * Process all input items (matching n8n $input.all() pattern)
 * @param {Array} items - Array of product identifiers (ASINs/URLs)
 * @param {Object} options - Processing options
 * @returns {Promise<Array>} - Processed results
 */
async function processBatch(items, options = {}) {
  const {
    platform = 'amazon',
    onProgress = null,  // Callback for progress updates
    onError = null      // Callback for error handling
  } = options;

  console.log(`[BatchProcessor] Starting batch processing: ${items.length} items`);

  const results = [];
  const errors = [];

  // Process each item (matching n8n .map() pattern)
  for (let index = 0; index < items.length; index++) {
    const item = items[index];

    try {
      // Progress callback
      if (onProgress) {
        onProgress({
          current: index + 1,
          total: items.length,
          item: item
        });
      }

      console.log(`[BatchProcessor] Processing item ${index + 1}/${items.length}: ${item}`);

      // Step 1: Scrape product data
      const scrapeResult = await scrapeAmazonProduct(item);
      if (!scrapeResult.success) {
        throw new Error(scrapeResult.error || 'Scraping failed');
      }

      // Step 2: AI analysis
      const analysisResult = await analyzeWithAI(scrapeResult);
      if (!analysisResult.success) {
        throw new Error(analysisResult.error || 'AI analysis failed');
      }

      // Step 3: Extract structured data
      const extractedData = extractStructuredData(
        analysisResult.content,
        scrapeResult.asin
      );

      // Step 4: Format output
      results.push({
        success: true,
        index: index,
        input: item,
        asin: scrapeResult.asin,
        scraped: scrapeResult,
        analysis: analysisResult,
        extracted: extractedData
      });

    } catch (error) {
      console.error(`[BatchProcessor] Error processing item ${index + 1}:`, error.message);

      const errorResult = {
        success: false,
        index: index,
        input: item,
        error: error.message,
        timestamp: new Date().toISOString()
      };

      results.push(errorResult);
      errors.push(errorResult);

      // Error callback
      if (onError) {
        onError(errorResult);
      }

      // Continue processing (error isolation pattern from n8n)
      continue;
    }
  }

  console.log(`[BatchProcessor] Batch complete: ${results.filter(r => r.success).length}/${results.length} succeeded`);

  return {
    results: results,
    summary: {
      total: results.length,
      succeeded: results.filter(r => r.success).length,
      failed: results.filter(r => !r.success).length,
      timestamp: new Date().toISOString()
    }
  };
}

/**
 * Analyze scraped content with AI (Gemini)
 * @param {Object} scrapedData - Data from scraper
 * @returns {Promise<Object>} - AI analysis result
 */
async function analyzeWithAI(scrapedData) {
  // Import prompt template
  const prompt = getAnalysisPrompt();

  // Prepare content for AI
  const content = prompt.replace('{{ PRODUCT_CONTENT }}', scrapedData.markdownContent);

  try {
    // Call Gemini API (using n8n's model: gemini-3-flash-preview)
    const response = await fetch('https://generativelanguage.googleapis.com/v1beta/models/gemini-3-flash-preview:generateContent', {
      method: 'POST',
      headers: {
        'Content-Type': 'application/json',
        'x-goog-api-key': process.env.GEMINI_API_KEY || ''
      },
      body: JSON.stringify({
        contents: [{
          parts: [{
            text: content
          }]
        }]
      })
    });

    if (!response.ok) {
      throw new Error(`Gemini API error: ${response.status}`);
    }

    const data = await response.json();

    return {
      success: true,
      content: data.candidates?.[0]?.content?.parts?.[0]?.text || '',
      model: 'gemini-3-flash-preview',
      timestamp: new Date().toISOString()
    };

  } catch (error) {
    return {
      success: false,
      error: error.message,
      timestamp: new Date().toISOString()
    };
  }
}

/**
 * Extract structured data from AI response
 * Matching n8n "Code - 提取结构化数据" node logic (v81)
 * @param {string} aiResponse - AI analysis text
 * @param {string} asin - Product ASIN
 * @returns {Object} - Extracted structured data
 */
function extractStructuredData(aiResponse, asin) {
  // Initialize with defaults (matching n8n pattern)
  let title = '未知';
  let price = '未知';
  let rating = '未知';

  // Extract title
  const titlePatterns = [
    /产品标题[：:]+([^\n]+)/,
    /Title[：:]+([^\n]+)/
  ];
  for (const pattern of titlePatterns) {
    const match = aiResponse.match(pattern);
    if (match) {
      title = match[1].trim();
      break;
    }
  }

  // Extract price
  const pricePatterns = [
    /价格[：:]+[^0-9]*([0-9]+\.?[0-9]*)/,
    /Price[：:]+[^0-9]*([0-9]+\.?[0-9]*)/
  ];
  for (const pattern of pricePatterns) {
    const match = aiResponse.match(pattern);
    if (match) {
      price = match[1];
      break;
    }
  }

  // Extract rating
  const ratingPatterns = [
    /评分[：:]+[^0-9]*([0-9]+\.?[0-9]*)/,
    /Rating[：:]+[^0-9]*([0-9]+\.?[0-9]*)/
  ];
  for (const pattern of ratingPatterns) {
    const match = aiResponse.match(pattern);
    if (match) {
      rating = match[1];
      break;
    }
  }

  return {
    asin: asin,
    title: title,
    price: price,
    rating: rating,
    fullAnalysis: aiResponse
  };
}

/**
 * Format results for Google Sheets output
 * @param {Array} results - Processed results
 * @returns {Array} - Formatted rows for Google Sheets
 */
function formatForGoogleSheets(results) {
  const rows = [];

  // Header row
  rows.push([
    'ASIN',
    '产品标题',
    '价格',
    '评分',
    '文案分析摘要',
    '视觉分析摘要',
    '评论分析摘要',
    '市场分析摘要'
  ]);

  // Data rows (successful results only)
  for (const result of results) {
    if (!result.success) continue;

    const extracted = result.extracted;
    const analysis = result.analysis.content;

    // Extract summaries from analysis (300 chars each)
    rows.push([
      extracted.asin,
      extracted.title,
      extracted.price,
      extracted.rating,
      extractSummary(analysis, '文案构建', 300),
      extractSummary(analysis, '视觉资产', 300),
      extractSummary(analysis, '评论', 300),
      extractSummary(analysis, '市场', 300)
    ]);
  }

  return rows;
}

/**
 * Format results for Markdown report
 * @param {Array} results - Processed results
 * @returns {string} - Complete Markdown report
 */
function formatMarkdownReport(results) {
  const date = new Date().toISOString().split('T')[0];
  const successful = results.filter(r => r.success);

  let markdown = `# 亚马逊竞品分析报告\n\n`;
  markdown += `## 分析概览\n\n`;
  markdown += `- 分析产品数：${successful.length}\n`;
  markdown += `- 分析时间：${date}\n`;
  markdown += `- 成功率：${successful.length}/${results.length}\n\n`;
  markdown += `---\n\n`;

  for (let i = 0; i < successful.length; i++) {
    const result = successful[i];
    const extracted = result.extracted || {};

    // Use top-level asin and analysis, with fallback to extracted
    const asin = result.asin || extracted.asin || '未知';
    const title = extracted.title || '未知';
    const price = extracted.price || '未知';
    const rating = extracted.rating || '未知';
    const analysis = result.analysis || extracted.fullAnalysis || '暂无分析';

    markdown += `## 产品 ${i + 1}: ${asin}\n\n`;
    markdown += `### 基本信息\n`;
    markdown += `- 标题：${title}\n`;
    markdown += `- 价格：${price}\n`;
    markdown += `- 评分：${rating}\n\n`;
    markdown += `### 详细分析\n\n`;
    markdown += `${analysis}\n\n`;
    markdown += `---\n\n`;
  }

  // Failed items
  const failed = results.filter(r => !r.success);
  if (failed.length > 0) {
    markdown += `## 处理失败的产品\n\n`;
    for (const item of failed) {
      markdown += `- **${item.input}**: ${item.error}\n`;
    }
  }

  return markdown;
}

/**
 * Extract summary section from analysis
 * @param {string} analysis - Full analysis text
 * @param {string} keyword - Section keyword
 * @param {number} maxLength - Maximum length
 * @returns {string} - Extracted summary
 */
function extractSummary(analysis, keyword, maxLength) {
  // Find section containing keyword
  const index = analysis.indexOf(keyword);
  if (index === -1) {
    return analysis.substring(0, maxLength) + '...';
  }

  // Extract around the keyword
  const start = Math.max(0, index - 50);
  const end = Math.min(analysis.length, index + maxLength);
  let summary = analysis.substring(start, end).trim();

  if (summary.length > maxLength) {
    summary = summary.substring(0, maxLength) + '...';
  }

  return summary;
}

/**
 * Get analysis prompt from file
 * @returns {string} - Prompt template
 */
function getAnalysisPrompt() {
  // This would read from prompts/analysis-prompt-base.md
  // For now, return a placeholder
  return `你是亚马逊竞品分析专家。请分析以下产品页面的内容：

{{ PRODUCT_CONTENT }}

# Role / 身份角色
你是一位拥有 10 年经验的"亚马逊顶级运营总监"和"品牌战略官"...

[Full prompt from analysis-prompt-base.md]`;
}

// Export functions
module.exports = {
  processBatch,
  parseGoogleSheetsSpec,
  analyzeWithAI,
  extractStructuredData,
  formatForGoogleSheets,
  formatMarkdownReport
};