Airtable automations only have a few integrations so far (no ClickUp), but this could be done with Zapier or Integromat. No script needed, just triggers setup to watch specific Airtable tables or views and then subsequent actions to perform in Clickup.
In my opinion Zapier is more user friendly and easier to get started, but Integromat is much more powerful. Either one could probably handle this automation though. One limitation is that the free version of both of these services only check for the trigger every 15 minutes.
Let me know if you need any other suggestions or help with the setup.