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.