Googleスプレッドシート（上級）

- id: add_multiple_rows
  name: add_multiple_rows
  tool: GOOGLE_SPREADSHEET_ADD_ROWS
  config:
    - name: credentials
      value: "{{secrets.GOOGLE_SHEETS_CREDENTIALS}}"
  input:
    - name: spreadsheet_id
      value: "your_spreadsheet_id_here"
    - name: sheet_name
      value: "データ"
    - name: values
      value: [
        ["田中太郎", "tanaka@example.com", "マネージャー", "2024-01-15"],
        ["佐藤花子", "sato@example.com", "開発者", "2024-01-16"],
        ["鈴木一郎", "suzuki@example.com", "デザイナー", "2024-01-17"]
      ]

- id: update_multiple_rows
  name: update_multiple_rows
  tool: GOOGLE_SPREADSHEET_UPDATE_ROWS
  config:
    - name: credentials
      value: "{{secrets.GOOGLE_SHEETS_CREDENTIALS}}"
  input:
    - name: spreadsheet_id
      value: "your_spreadsheet_id_here"
    - name: sheet_name
      value: "データ"
    - name: start_row
      value: 2
    - name: values
      value: [
        ["田中太郎（更新）", "tanaka.taro@example.com", "シニアマネージャー", "2024-01-15"],
        ["佐藤花子（更新）", "sato.hanako@example.com", "シニア開発者", "2024-01-16"]
      ]

- id: create_new_sheet
  name: create_new_sheet
  tool: GOOGLE_SPREADSHEET_ADD_SHEET
  config:
    - name: credentials
      value: "{{secrets.GOOGLE_SHEETS_CREDENTIALS}}"
  input:
    - name: spreadsheet_id
      value: "your_spreadsheet_id_here"
    - name: sheet_name
      value: "月次レポート_{{current_date}}"

- id: setup_headers
  name: setup_headers
  tool: GOOGLE_SPREADSHEET_ADD_ROW
  config:
    - name: credentials
      value: "{{secrets.GOOGLE_SHEETS_CREDENTIALS}}"
  input:
    - name: spreadsheet_id
      value: "your_spreadsheet_id_here"
    - name: sheet_name
      value: "月次レポート_{{current_date}}"
    - name: values
      value: ["名前", "メール", "部署", "開始日", "ステータス"]