How to get Onchain data?

How do you typically acquire on-chain data for cryptocurrency analysis and financial decision-making? Are there specific tools or platforms that you rely on to gather this information, or do you use a combination of methods? What are some of the key challenges that you've encountered in accessing and utilizing on-chain data, and how have you overcome these obstacles? Is it possible to automate the process of gathering and analyzing on-chain data, and if so, what are the benefits and drawbacks of doing so?