The problem:
- Same workflow, different environments (test vs prod)
- Different API endpoints for each
- Hardcoded values = manual updates everywhere
- One typo = cascade of failures
My solution: Centralized config in Airtable.
How it works:
1. Store all variables in Airtable "Variables" table
- API endpoints
- Webhook URLs
- Feature flags
2. Automation script reads the table and:
- Normalizes variable names (MY_API_URL → myApiUrl)
- Switches environments (PRODUCTION=true strips "-test" suffix)
- Groups related configs (all NCA_* endpoints together)
- Sends clean payload to n8n webhook
3. n8n workflows receive structured config, no hardcoding
The win:
- Change one Airtable cell → all workflows update
- Toggle PRODUCTION flag → instant environment switch
- Add new variable → automatically available everywhere
No more:
- Hunt-and-replace across 50 workflows
- Which workflow still has the old endpoint?
Real example:
Works with any n8n + Airtable setup.
Airtable base (with script included) → Template Library, look for the Airtable base link at the bottom of the page.