Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Take data from attachment and populate fields?

Topic Labels: Automations
1470 1
cancel
Showing results for 
Search instead for 
Did you mean: 
AverageUser
4 - Data Explorer
4 - Data Explorer

Hi there!

I was wondering if it possible to have a form that allows the user to attach a file (csv or xlsx) then using automation, take that attachment and populate the matching columns - as well as do any update.

Basically would be the CSV Importer but instead of dropping a file, it would consider the values from the attachment.

There is Spreadsheet importer: Airtable Scripting but not sure how to make it work.

Thanks!

1 Reply 1
Tim_Mackey
6 - Interface Innovator
6 - Interface Innovator

As far as I am aware, there is no direct way to read the contents of an attachment using an automation. I looked into this once and gave up on the idea.

However, this may in theory be possible. Perhaps someone else on the forums has done this already and can provide more details? This method would require the use of an external service to read the file contents and return it back to you in a format that you can use (JSON perhaps). Here’s the concept:

  1. Create an automation which uses a scripting action
  2. In your script, use the Airtable API to get the url of the attachment field
  3. send that public attachment url to your external service and await the processed file contents
  4. proceed with your script using the data that the external service provided you

Caveat: assuming this works, you would need to be mindful of time limits on automations. The service would need to send the data back to you quickly so that you don’t hit the 30 second max execution time.