You can use Awesome Table Connectors to export data from DefiLlama to Google Sheets by logging in with the DefiLlama connector.
DefiLlama 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 DefiLlama connector.