From Spreadsheet to Pipeline: 5 FX Data Automation Workflows That Cut Month-End Close by 60%

// Google Apps Script — Currency Rate Feed
// Paste into Extensions > Apps Script in your Google Sheet

const API_KEY = 'YOUR_API_KEY';
const BASE_URL = 'https://currency-exchange.app/api';
const PAIRS = [
  { from: 'USD', to: 'EUR' },
  { from: 'USD', to: 'GBP' },
  { from: 'USD', to: 'JPY' },
  { from: 'USD', to: 'CAD' },
  { from: 'USD', to: 'AUD' },
];

function updateRates() {
  const sheet = SpreadsheetApp.getActiveSpreadsheet()
    .getSheetByName('Rates');

  // Clear previous data (keep header row)
  sheet.getRange(2, 1, sheet.getLastRow(), 5).clearContent();

  const now = new Date();
  let row = 2;

  for (const pair of PAIRS) {
    const url = BASE_URL +
      '/v1-get-currency-exchange-rate' +
      '?from=' + pair.from + '&to=' + pair.to +
      '&x-api-key=' + API_KEY;

    const response = UrlFetchApp.fetch(url, {
      muteHttpExceptions: true,
    });

    if (response.getResponseCode() === 200) {
      const data = JSON.parse(response.getContentText());

      sheet.getRange(row, 1).setValue(pair.from);
      sheet.getRange(row, 2).setValue(pair.to);
      sheet.getRange(row, 3).setValue(data.exchangeRate);
      sheet.getRange(row, 4).setValue(data.rateTime);
      sheet.getRange(row, 5).setValue(now);

      row++;
    }
  }
}

// Run this function once to create the trigger
function createTrigger() {
  ScriptApp.newTrigger('updateRates')
    .timeBased()
    .everyMinutes(15)
    .create();
}

# n8n Workflow Configuration (JSON)
# Import into n8n via Workflow > Import

{
  "nodes": [
    {
      "type": "n8n-nodes-base.scheduleTrigger",
      "name": "Every 5 minutes",
      "parameters": {
        "rule": { "interval": [ { "field": "minutes", "minutesInterval": 5 } ] }
      }
    },
    {
      "type": "n8n-nodes-base.httpRequest",
      "name": "Get USD/EUR Rate",
      "parameters": {
        "method": "GET",
        "url": "https://currency-exchange.app/api/v1-get-currency-exchange-rate",
        "sendQuery": true,
        "queryParameters": {
          "parameters": [
            { "name": "from", "value": "USD" },
            { "name": "to", "value": "EUR" },
            { "name": "x-api-key", "value": "YOUR_API_KEY" }
          ]
        }
      }
    },
    {
      "type": "n8n-nodes-base.googleSheets",
      "name": "Append to Sheet",
      "parameters": {
        "operation": "append",
        "documentId": "YOUR_SHEET_ID",
        "sheetName": "Rates",
        "columns": {
          "mappingMode": "defineBelow",
          "value": {
            "from": "={{ $json.from }}",
            "to": "={{ $json.to }}",
            "rate": "={{ $json.exchangeRate }}",
            "timestamp": "={{ $json.rateTime }}",
            "fetched": "={{ $now.toISO() }}"
          }
        }
      }
    }
  ],
  "connections": {
    "Every 5 minutes": {
      "main": [[{ "node": "Get USD/EUR Rate", "type": "main", "index": 0 }]]
    },
    "Get USD/EUR Rate": {
      "main": [[{ "node": "Append to Sheet", "type": "main", "index": 0 }]]
    }
  }
}

// TypeScript — AI Agent Currency Tool (LLM Framework Agnostic)
// Works with OpenAI, Anthropic, or any tool-calling LLM

interface CurrencyConversionResult {
  from: string;
  to: string;
  amount: number;
  exchangeRate: number;
  convertedAmount: number;
  rateTime: string;
}

async function convertCurrency(
  from: string,
  to: string,
  amount: number,
): Promise<CurrencyConversionResult> {
  const url = new URL(
    'https://currency-exchange.app/api/v1-convert-currency',
  );
  url.searchParams.set('from', from);
  url.searchParams.set('to', to);
  url.searchParams.set('amount', String(amount));
  url.searchParams.set('x-api-key', process.env.FX_API_KEY ?? '');

  const response = await fetch(url.toString());
  if (!response.ok) {
    throw new Error(`Currency API error: ${response.status}`);
  }

  const data = await response.json();

  return {
    from: data.from,
    to: data.to,
    amount: data.originalAmount,
    exchangeRate: data.exchangeRate,
    convertedAmount: data.convertedAmount,
    rateTime: data.rateTime,
  };
}

// Tool schema for LLM registration
const currencyToolSchema = {
  name: 'convert_currency',
  description:
    'Convert an amount between two currencies using live exchange rates. ' +
    'Returns the converted amount, exchange rate, and rate timestamp.',
  parameters: {
    type: 'object',
    properties: {
      from: { type: 'string', description: 'Source currency (ISO 4217)' },
      to: { type: 'string', description: 'Target currency (ISO 4217)' },
      amount: { type: 'number', description: 'Amount to convert' },
    },
    required: ['from', 'to', 'amount'],
  },
};