You can use our 'Unzip Attachments' automation for this use case. Simply set the Source ZIP Field and Output Attachments Field and run the automation!
Set up the automation
Create the Unzip Attachments automation, then select your Airtable base and table.
Prepare an attachment field containing the ZIP files and a different attachment field for the extracted files.
Set Source ZIP Field to the ZIP attachments and Output Attachments Field to the destination.
Limit the run to a view containing one or two sample records, then run the automation. Check the extracted files in Airtable before running the remaining records.
Extracted files are added to any attachments already in the output field. Running the same record again can add the files again, so avoid unnecessary repeat runs.