
# v10: ÙT D1  ´  tÜ

•XiÈä! ÀLÀ °¬” Freee ŒÄ pt0| Ù<\  8@ Vertex AI\ „XXà, Google SheetsÐ  ¥X” D\ Ü¤\D l•ˆµÈä. tˆ ÈÀÉ ì¤¸Ð” ´ Ü¤\D ¬Xà, ä4Ð \©`  ˆ” ÙT )•äD LDô µÈä.

## ´ Ü¤\ D¤M˜ ”}

```
             
  Freee API     º OAuth2 x (Ù  p 1à)
             
       
       ¼
                 
  p˜ ´í pŒ     º tˆ ì p˜ pt0
                 
       
       ¼
                 
  Vertex AI         º Gemini 2.5 Pro\ tLà¬ Ù „X
  (Gemini)            (ÝD, PµD, Ì ñ)
                 
       
       ¼
                 
 Google Sheets      º õ p Ä Ù  ¥
                      (tLà¬ ìh)
                 
```

## D1 | lp

```
/20251126-googlesheet-vertexai-freee-script
   /src
      index.ts              # Tx µi ¤l½¸
      testVertexAI.ts       # Vertex AI L¤¸ ©
      freeeClient.ts        # Freee API t|t¸¸
      googleSheetClient.ts  # Google Sheets API t|t¸¸
      vertexAiClient.ts     # Vertex AI t|t¸¸
      tokenManager.ts       #  p l  ¥  ¬
      interfaces.ts         # TypeScript x0˜t¤ X
   /credentials
      freee-sheets-service-key.json  # Google D¤ Ä ¤
   .env                      # X½ À
   tokens.json              # Ù Ý1”  p |
   package.json
   tsconfig.json
   .gitignore
```

## Ù ä‰

¸àÀ äL …9´\ Ù<\ Ù0T| ä‰`  ˆµÈä:

```bash
npx ts-node src/index.ts
```

## ÙT )•

### )• 1: Cron (Linux/Mac)

ä| $ 9ÜÐ Ù<\ ä‰XÄ] $:

```bash
# crontab ¸Ñ
crontab -e

# äL |x ”  (ä| $ 9Ü ä‰)
0 9 * * * cd /path/to/project && npx ts-node src/index.ts >> /path/to/logs/freee-sync.log 2>&1
```

\ø |D UxXì ä‰ °ü| ¨È0Á`  ˆµÈä:

```bash
tail -f /path/to/logs/freee-sync.log
```

### )• 2: GitHub Actions

GitHub  ¥ŒÐ TÜ| xÜXà, GitHub Actions\ ÙT:

```yaml
# .github/workflows/sync-freee.yml
name: Freee to Google Sheets Sync

on:
  schedule:
    # ä| $ 9Ü (UTC 0  0Ü)
    - cron: '0 0 * * *'
  workflow_dispatch: # Ù ä‰  ¥

jobs:
  sync:
    runs-on: ubuntu-latest

    steps:
      - name: Checkout code
        uses: actions/checkout@v3

      - name: Setup Node.js
        uses: actions/setup-node@v3
        with:
          node-version: '18'

      - name: Install dependencies
        run: npm install

      - name: Create credentials file
        run: |
          mkdir -p credentials
          echo '${{ secrets.GOOGLE_SERVICE_ACCOUNT_KEY }}' > credentials/freee-sheets-service-key.json

      - name: Create .env file
        run: |
          echo "FREEE_CLIENT_ID=${{ secrets.FREEE_CLIENT_ID }}" >> .env
          echo "FREEE_CLIENT_SECRET=${{ secrets.FREEE_CLIENT_SECRET }}" >> .env
          echo "FREEE_BUSINESS_ID=${{ secrets.FREEE_BUSINESS_ID }}" >> .env
          echo "FREEE_REFRESH_TOKEN=${{ secrets.FREEE_REFRESH_TOKEN }}" >> .env
          echo "GOOGLE_DOCUMENT_ID=${{ secrets.GOOGLE_DOCUMENT_ID }}" >> .env
          echo "GOOGLE_SERVICE_ACCOUNT_KEY_PATH=./credentials/freee-sheets-service-key.json" >> .env

      - name: Run sync
        run: npx ts-node src/index.ts
```

GitHub SecretsÐ äLD ” :
- `FREEE_CLIENT_ID`
- `FREEE_CLIENT_SECRET`
- `FREEE_BUSINESS_ID`
- `FREEE_REFRESH_TOKEN`
- `GOOGLE_DOCUMENT_ID`
- `GOOGLE_SERVICE_ACCOUNT_KEY`

### )• 3: Cloud Run / Cloud Functions

Google CloudÐ „¬¤\ ä‰:

```typescript
// functions/index.ts
import { getDeals } from '../src/freeeClient';
import { appendFreeeDeals } from '../src/googleSheetClient';
import { classifyTransactionsBatch } from '../src/vertexAiClient';

export const syncFreeeToSheets = async (req: any, res: any) => {
  try {
    const companyId = parseInt(process.env.FREEE_BUSINESS_ID || '', 10);
    const today = new Date();
    const firstDayOfMonth = new Date(today.getFullYear(), today.getMonth(), 1);
    const startDate = firstDayOfMonth.toISOString().split('T')[0];
    const endDate = today.toISOString().split('T')[0];

    const deals = await getDeals(companyId, startDate, endDate);
    const categories = await classifyTransactionsBatch(deals);
    const result = await appendFreeeDeals(deals, categories);

    res.json({
      success: true,
      added: result.added,
      skipped: result.skipped,
    });
  } catch (error: any) {
    console.error('Error:', error.message);
    res.status(500).json({ success: false, error: error.message });
  }
};
```

Cloud Scheduler\ ä| ä‰Ä] $`  ˆµÈä.

## ´ ¨È0Á

### \ø Ux

¨à ä‰ \ø” X”Ð œ%À\, |\  ¥Xp˜ t|°Ü \E D¤| ¬©`  ˆµÈä:

```bash
npx ts-node src/index.ts | tee -a logs/sync-$(date +%Y%m%d).log
```

### $X L¼

”\ $X Ý Ü tT|t˜ Slack<\ L¼D Ä] $:

```typescript
// src/index.tsÐ ” 
import axios from 'axios';

const sendSlackNotification = async (message: string) => {
  const webhookUrl = process.env.SLACK_WEBHOOK_URL;
  if (!webhookUrl) return;

  try {
    await axios.post(webhookUrl, { text: message });
  } catch (error) {
    console.error('Slack L¼ ¡ ä(:', error);
  }
};

// main hX catch ]Ð 8œ
catch (error: any) {
  const errorMessage = `L Freee Ù0T ä(: ${error.message}`;
  console.error(errorMessage);
  await sendSlackNotification(errorMessage);
  throw error;
}
```

## D© \T

### Vertex AI D© 

1. **¨x  Ý**: `gemini-2.5-pro`  à `gemini-1.5-flash` ¬© (T  4)
2. **ñ**: Ù|\ ¸Ð  t t „X °ü ¬¬©
3. **0X ˜¬**: ìì p˜| \ ˆX l¸\ „X

```typescript
// ñ Ü
const categoryCache = new Map<string, string>();

export const classifyTransactionWithCache = async (deal: any): Promise<string> => {
  const cacheKey = `${deal.partner_id}-${deal.ref_number}`;

  if (categoryCache.has(cacheKey)) {
    console.log(`Ü ˆ¸: ${cacheKey}`);
    return categoryCache.get(cacheKey)!;
  }

  const category = await classifyTransaction(deal);
  categoryCache.set(cacheKey, category);
  return category;
};
```

## ôH Œ¥¬m

1. **X½ À**:   `.env` |D GitÐ äXÀ È8”
2. ** p ô8**: `tokens.json`Ä `.gitignore`Ð ìh
3. **D¤ Ä**: Google D¤ ÄÐ \Œ Œ\Ì €ì
4. **0 ¬**: ü0<\ API ¬© \ø Ux

## 8 t°

###  p ÌÌ $X

```bash
# tokens.jsonD ­Xà ¬x
rm tokens.json
npx ts-node src/freeeClient.ts
```

### Vertex AI D© ü

```typescript
// || \  ˜¬ t \
const MAX_DAILY_TRANSACTIONS = 100;

if (deals.length > MAX_DAILY_TRANSACTIONS) {
  deals = deals.slice(0, MAX_DAILY_TRANSACTIONS);
  console.log(`   || \<\ ${MAX_DAILY_TRANSACTIONS}tÌ ˜¬iÈä.`);
}
```

### Google Sheets ©É \

Google Sheets” \  500Ì @LÀ  ¥  ¥iÈä. pt0  ÎDÀt ÔÄ\ Ü¸| „¬X8”:

```typescript
const sheetName = `Freeep˜´í_${today.getFullYear()}_${String(today.getMonth() + 1).padStart(2, '0')}`;
```

## È4¬

t Dˆ ÙT Freee ŒÄ pt0  ¬ Ü¤\t D1ÈµÈä!

**uì 1ü:**
-  Freee API OAuth2 Ù x   p 1à
-  Vertex AI (Gemini)| ¬©\ AI Ù „X
-  Google Sheets Ù Ù0T  õ p
-  D 4x ÙT  ¥

t Ü¤\D 0<\ ä‘\ U¥t  ¥iÈä:
- Ô/ð ¬ì¸ Ù Ý1
- ° ü L¼
- pt0 ÜT  ÜôÜ
- äx ŒÄ D¤@X µi

\¸| D1Xà ƒD •XÜ½Èä!