The fuzzy lookup addon can be used with intergromat to join and match data between the google sheets. The configuration can be scheduled to be updating after a given time.
Read the whole article on the link attached
