There doesn’t appear to be an action step in Airtable Automations that allows for finding records by a search criteria and creating the record if it doesn’t exist. This can be done with Zapier, but I would love to be able to accomplish automations requiring this to be done with Airtable Automations. Is there a workaround that would allow for this? Perhaps using a script?
Automations is still quite new, so it doesn’t yet have features that come with Zapier.
You are right that the workaround is to use a script. However, because the script cannot produce output for chained actions, you would need to complete the remaining steps in the script as well. If you would like a future action that would be difficult to accomplish in the script (such as sending a message) you can move that final step into a different automation.