Keep Algolia search in sync with new Airtable records

Every time a new record is created in a specific Airtable table, push it into my Algolia index so the search on my public site stays current.

Trigger: an Airtable poll on the new_record event, scoped to one base and one table that I pick when I set this up.

For each new Airtable record, call Algolia's Add or Replace Record operation on my target index. Use the Airtable record ID as the Algolia objectID so a future re-sync of the same record updates the existing Algolia entry instead of creating a duplicate.

Map a fixed set of Airtable fields into the Algolia record body. Start with Name, Category, Description, Image URL, and the public page URL. Copy them straight across, keeping the same field names on the Algolia side unless I say otherwise. Skip records where the Name field is empty so the search index does not fill up with placeholder rows.

I do not want a nightly full re-index and I do not want a manual sync button. The whole point is that new rows from content editors show up in site search within a minute or two of being saved in Airtable. A follow-up workflow can later extend this to updates (new_or_updated_record) and deletes; keep this one focused on inserts.