Skip to main content

Log in with the SQL Server Connector

You can use Awesome Table Connectors to export data from SQL Server to Google Sheets by logging in with the SQL Server connector.

Prerequisites

  1. In the Awesome Table add-on Home screen, click Create new request.


    The list of available connectors is displayed.

  2. Open the SQL Server connector.

    The SQL Server connector is listed in the Databases category of the add-on

  3. On the Connect to SQL Server screen, enter your credentials:

    SQL Server credentials are entered into their respective fields, which are: Host, Port (Optional), Database name, Username, and Password.

  4. (Optional) If your database is protected by network security, you must add Awesome Table's static IP address (34.133.53.19) to your whitelist.

    1. Open SQL Server Management Studio.
    2. Go to Object Explorer, right-click the server you want to grant access to, then select Properties.
    3. Click Connections.
    4. Under Remote server connections, ensure that Allow remote connections to this server is selected.

  5. Click Test & Save.

You are now logged in with the SQL Server connector. The Select data drop-down shows the data you can export to Google Sheets.
The list of options to export from SQL Server connector
What’s next
You can now use Awesome Table Connectors to export data from SQL Server to Google Sheets.