Step 1 — Create your Airtable Base
Go to
airtable.com → Create a new Base → Name it
ServiceFlow
Step 2 — Get your Base ID
Open the base → Help → API Documentation → copy the
app... ID
Step 3 — Create a Personal Access Token
Go to
airtable.com/create/tokens → scopes needed:
data.records:read · data.records:write · schema.bases:read
Step 4 — Add these fields to your Services table
Required: title (Text), service_date (Date), day_of_week (Text), theme (Text), speaker (Text), notes (Long Text), status (Single select: draft/final),
segments_json (Long Text) — this stores the full service flow.
Songs table fields: title, artist, key, tempo, youtube_link, chord_chart_link, tags, notes, lyrics (Long Text), ccli_number