Query Record ID from Parent Table and add its Record ID to a Connected Table

I have a connected table that pulls 15,000 records from a csv in a shared Google Drive folder. I have a parent table that has the physical location of all these records. I need to relate the records to their location, but because it is a connected table, I cant do a VLOOKUP and reimport the data. 

Is it possible to do a webhook that says something like:

When a record is added, take the [Child Location] and query the parent table for the same location then add the [Record ID] for that location to the [Child Reference Field]

Thanks