Auto-Updating Crypto Volume Sheet

I want a Google Sheets file that automatically logs the trading volume of the top 10 cryptocurrencies by market cap. Every ten minutes the sheet should fetch fresh data, add a new timestamped row, and keep the historical record growing so I can scroll back in time or build additional analysis later.

Key functions I need:
• A script (Apps Script or another reliable method inside Google Sheets) that calls a public crypto API, pulls the symbol, last price, and 24-hour trading volume for the current top 10 coins, and writes everything to the next empty row.
• A simple column chart inside the sheet visualising volume so I can glance at which coin is most active at any point.
• Automatic scheduling: the script must trigger every ten minutes without manual input and handle API hiccups gracefully.
• Clear pointers inside the file showing where I can adjust the refresh frequency or swap coins if my priorities change.

Acceptance criteria:
• Sheet refreshes itself for at least one hour during hand-over so I can watch new rows appear.
• No broken API calls or #N/A cells; errors are caught and logged in a separate “Status” column.
• All code is commented and ownership transferred, with a short read-me tab explaining how to authorise, edit, or extend the solution.

If you have solid, hands-on experience building similar Google Sheets automations, I’d love to see it. Let me know how you’d tackle the ten-minute trigger and which API you’d pick to keep the project stable long-term.