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