The Extract Image Metadata automation reads the first image in the selected attachment field for each record. It can extract location coordinates, creation date/time and camera information when available, plus image dimensions and aspect ratio. Depending on your requirements, you can create and configure the following fields:
Attachment Airtable Field:
The field that contains your images as attachments.
Longitude Airtable Field (Optional):
This can be a number or a text field. To correctly capture the data in a number field, enable 'Allow negative numbers' and select the maximum number of decimal places.
Latitude Airtable Field (Optional):
Configured similarly to the longitude field.
Created Date Airtable Field (Optional):
Use a date field with Include time enabled in its field configuration.
Camera Make Airtable Field (Optional)
This must be a text field.
Camera Model Airtable Field (Optional)
Same as the Camera Make field.
Image Width Airtable Field (Optional)
This must be a number field.
Image Height Airtable Field (Optional)
Same as Image Width field.
Aspect Ratio Airtable Field (Optional)
Same as Image Width field.
The automation will only extract data already present in the image metadata. If you’re not getting the expected data from your images, it’s possible that the necessary metadata isn’t included. You can check the image settings in your operating system to confirm this.
For example, on MacOS, you can find the metadata under the More Info section after using the Get Info action, as shown in the image above.
Set up and run
Create the Extract Image Metadata automation and select the base and table containing your images.
Under Setup, select the attachment field and the output fields described above. Configure only the metadata you need to save.
Under Processing Behavior, choose how to handle existing output values.
Start with a filtered view containing a few records, then run the automation from the Run section.
Check the selected output fields in Airtable before processing more records. Use an image that contains the metadata you want to extract; the automation cannot add missing camera or location information.