AppHighway + Airtable: Supercharge Your Database Automation

Grundlegende Skript-Einrichtung

// Airtable Script: Basic AppHighway Integration
const APPHIGHWAY_API_KEY = input.config().apiKey;
const API_ENDPOINT = ''https://apphighway.com/api/v1/sentiment-analysis'';

// Get table and view
let table = base.getTable(''Customer Reviews'');
let view = table.getView(''Pending Analysis'');
let records = await view.selectRecordsAsync();

console.log(`Processing $'{'records.records.length'}' records...`);

Dies richtet die Grundstruktur für ein Airtable-Skript ein, das sich mit AppHighway-Tools verbindet. Speichern Sie Ihren API-Schlüssel in den Skript-Einstellungen für die Sicherheit.

API-Integrations-Beispiel

for (let record of records.records) '{'
  try '{'
    let response = await fetch(API_ENDPOINT, '{'
      method: ''POST'',
      headers: '{'
        ''Authorization'': `Bearer $'{'APPHIGHWAY_API_KEY'}'`,
        ''Content-Type'': ''application/json''
      '}',
      body: JSON.stringify('{' text: record.getCellValue(''Review Text'') '}')
    '}');
    let result = await response.json();
    await table.updateRecordAsync(record.id, '{' ''Sentiment'': result.sentiment '}');
  '}' catch (error) '{'
    console.error(`Error: $'{'error.message'}'`);
  '}'
'}'

Diese Schleife verarbeitet jeden Datensatz, ruft das AppHighway-Tool auf und aktualisiert den Airtable-Datensatz mit den Ergebnissen.

Webhook-Handler (Next.js)

export async function POST(req) '{'
  const '{' recordId, fields '}' = await req.json();
  const result = await fetch(''https://apphighway.com/api/v1/sentiment-analysis'', '{'
    method: ''POST'',
    headers: '{' ''Authorization'': `Bearer $'{'API_KEY'}'` '}',
    body: JSON.stringify('{' text: fields.reviewText '}')
  '}');
  return Response.json('{' success: true '}');
'}'

Diese serverlose Funktion empfängt Webhooks von Airtable und ruft AppHighway-Tools auf.

Airtable-Automatisierungs-Setup

1. Go to Automations in your base
2. Create new automation with trigger ''When record matches conditions''
3. Add action ''Run script'' or ''Send webhook''
4. Configure webhook URL to your handler endpoint
5. Map fields to send in webhook payload

Konfigurieren Sie Airtable, um Webhooks zu senden, wenn sich Datensätze ändern.

Ansichtsdatensätze abrufen

// Get records from a specific view
let table = base.getTable(''Tasks'');
let view = table.getView(''Needs Processing'');
let records = await view.selectRecordsAsync();

// Process only records in this view
for (let record of records.records) '{'
  await processWithAppHighway(record);
'}'

Stapelverarbeitung mit Ansichten

// Process records in batches
let allRecords = records.records;
let batchSize = 10;

for (let i = 0; i < allRecords.length; i += batchSize) '{'
  let batch = allRecords.slice(i, i + batchSize);
  await Promise.all(batch.map(r => processRecord(r)));
'}'

Geplante Ausführung

// Run automation hourly for ''Urgent'' view
// Run daily for ''Standard'' view
// Configure in Airtable Automations

Verwenden Sie verschiedene Zeitpläne für verschiedene Prioritätsansichten, um die Verarbeitung zu optimieren.

Workflow-Trigger-Setup

// Trigger when record status changes to ''Ready for Review''
let table = base.getTable(''Content'');
let view = table.getView(''Ready for Review'');

for (let record of (await view.selectRecordsAsync()).records) '{'
  // Analyze content with AppHighway
  let analysis = await analyzeWithAppHighway(record);
  // Update record with insights
  await table.updateRecordAsync(record.id, '{'
    ''AI Summary'': analysis.summary,
    ''Sentiment'': analysis.sentiment
  '}');
'}'

Team-Benachrichtigung

// Send notification after AI processing
const notifyTeam = async (record, analysis) => '{'
  // Create linked task for reviewer
  await taskTable.createRecordAsync('{'
    ''Title'': `Review: $'{'record.name'}'`,
    ''AI Insights'': analysis.summary,
    ''Priority'': analysis.urgency
  '}');
'}';

Datenbankschema

// Table: Customer Feedback
// Fields: ID, Customer Name, Feedback Text, Status, Sentiment, Score
// View: ''Needs Analysis'' filters Status = ''New''

Analyseskript

// Airtable Script for Sentiment Analysis
let table = base.getTable(''Customer Feedback'');
let view = table.getView(''Needs Analysis'');
let records = await view.selectRecordsAsync();

for (let record of records.records) '{'
  let feedback = record.getCellValue(''Feedback Text'');
  let response = await fetch(''https://apphighway.com/api/v1/sentiment-analysis'', '{'
    method: ''POST'',
    headers: '{' ''Authorization'': ''Bearer API_KEY'' '}',
    body: JSON.stringify('{' text: feedback '}')
  '}');
  let result = await response.json();
  await table.updateRecordAsync(record.id, '{' Sentiment: result.sentiment '}');
'}'