The main way in which the Spanish success at extracting gold from their colonies ultimately resulted in financial ruin is that since they were so busy taking gold they failed to establish any other long-term economic markets--meaning that when the goal ran out so did their wealth.
