materials are all on same plase on sharepoint, we recomend to sync, but this will be always a different file path name. Revit handles it, when those foldes are in settings preconfigured.
think, materials mapping by name to the existing would be great and the automatied link also