Uipath and automation anywhere seem to be big players with community/free starter editions. PWC (who are spearheading the RPA at $work) seem to have decreed that all their staff are going to use uipath worldwide.

There are a handful of open source RPA tools, but I don’t think there’s a breakthrough project yet.

Azure LogicApps are good for these kind of silly integrations, if it has a connector for it then it's a piece of cake.

They have a pretty limited use case though.