How to use Google Sheets crypto portfolio tracker?

How would a novice cryptocurrency investor leverage the power of Google Sheets to create a comprehensive crypto portfolio tracker? Assuming they have a basic understanding of spreadsheets but little to no experience with crypto tracking, what steps should they follow? Could you outline a step-by-step guide to importing their transactions, calculating portfolio value, tracking performance, and even integrating real-time market data? Additionally, are there any specific formulas or functions in Google Sheets that are particularly useful for this purpose? Lastly, are there any third-party add-ons or templates that could further enhance the functionality of a crypto portfolio tracker in Google Sheets?