With our Bulk Upload Attachments automation, you can upload/import multiple attachments at once and match them to records in Airtable based on a unique identifier.
How to use:
Select the Table: Choose the table you want to work with.
Choose a Unique ID Field: Select a unique identifier field in your table to match the attachment names with the corresponding records.
Select the Attachment Field: This is the field where the matched attachments will be stored.
Choose whether or not to use partial matching. Partial matching allows you to upload multiple attachments per records, by appending additional characters in the file name, e.g. Test1.jpg, Test.png, Test2.jpg would all match to a record whose Unique ID is "Test".
Go to the Upload Attachments section, and either select multiple files or drag and drop them.
Once the automation runs, you’ll see a summary of which attachments were successfully matched and any that failed. You can choose to create new records for any attachments that were not matched with an existing one, by clicking the Create Records for Unmatched Files button. This button will only appear if there are unmatched files.
Note: This automation is available for testing on the free plan, but it is limited to processing one record at a time.