You can use Awesome Table Connectors to export data from Salesforce to Google Sheets by logging in with the Salesforce connector.
In the Awesome Table add-on Home screen, click Create new request.
The list of available connectors is displayed.
Open the Salesforce connector.
On the Connect to Salesforce screen, click Sign in with Salesforce.
On the Salesforce authorization screen, enter your username and password and click Log In.Awesome Table informs you if your connection is successful.