You can use Awesome Table Connectors to export data from CoinGecko to Google Sheets by logging in with the CoinGecko connector.
CoinGecko does not require any authentication to connect to Awesome Table.
In the Awesome Table add-on Home screen, click Create new request.
The list of available connectors is displayed.
Open the CoinGecko connector.