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