Hi @Josie_Duffy
It sounds like an integration app such as Integromat or Zapier might be helpful. It automates manual taskes and places information into each record, into Airtable, I am just not sure about attaching folders.
Now I am not 100% sure if this will work, but you might want to check these apps out. The other thing to check out are the monthly fees and how many actions you can do within a month and decide what is the most cost effective way.
Hope this helps.
Mary