You can use Awesome Table Connectors to export data from SQL Server to Google Sheets by logging in with the SQL Server connector.
In the Awesome Table add-on Home screen, click Create new request.
The list of available connectors is displayed.
Open the SQL Server connector.
On the Connect to SQL Server screen, enter your credentials:
(Optional) If your database is protected by network security, you must add Awesome Table's static IP address (220.127.116.11) to your whitelist.
- Open SQL Server Management Studio.
- Go to Object Explorer, right-click the server you want to grant access to, then select Properties.
- Click Connections.
- Under Remote server connections, ensure that Allow remote connections to this server is selected.
Click Test & Save.