Alli Alosa demonstrates how to use the 'Insert as JSON' feature in Airtable automations to reliably handle incoming data from external webhooks, such as Fillout. She explains why this method is more robust than traditional field mapping, especially when dealing with inconsistent data. The discussion covers a practical use case involving event feedback collection. By passing the entire payload as a JSON object, you can prevent automations from failing when certain form fields are left empty or missing from the payload. Finally, the team explores how to use this JSON data within a script action. Instead of manually mapping every individual field as an input, you can pass the entire object into a script, allowing for much more scalable and maintainable automation logic. ⏱ In this cut: 01:03 — Using feedback collection as a use case 12:38 — The benefits of using Insert as JSON 13:37 — Solving errors caused by empty field values 17:00 — Passing JSON data into a script action 25:09 — Conditional filters and advanced integrations
This is a clip from S25-E06 of the BuiltOnAir Podcast.