Automatic fuel surcharge calculation from US on Diesel Highway Website

Summary

We have configured the standard fuel surcharge setup using rate factor rule. It is working as expected but the as we have more than 100 of service provider and the fuel surcharge region and even range various between them. So the user needs to update the fuel price manually every week in rate factor source id. As there are lot of service provider it is not feasible for client to update it every week. So they want it to be automated, either directly through integration or Excell sheet upload in system, Client expectation is that OTM should automatically map the