Unfortunately, Airtable’s default values only work for new records entered manually by a collaborator who is logged into Airtable and using the Airtable interface to create new records.
For all other types of records, you would need to create an automation to set field values.