There is a database that you can link your collection to: https://gowdb.com/
To see your troop usage, go to the “my collection” and sort by Invasions. It took me a few minutes to realize that meant PvP Invasions.
There was also an app created that helps track your requirements to update Kingdoms: New tool analyzes your collection and tells you which kingdom power tasks you can do right now (based on gowdb)