> ## Documentation Index
> Fetch the complete documentation index at: https://docs.superjoin.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# Connect your Microsoft SQL to Google Sheets

> Effortlessly connect your Microsoft SQL data to Google Sheets for reporting and analysis.

### Why use Superjoin’s Google Sheets-Microsoft SQL Integration?

<CardGroup cols={2}>
  <Card title="Quick and Easy Integration" icon="plug" iconType="duotone">
    We've meticulously organized the data points to ensure easy accessibility in a format you're already familiar with.
  </Card>

  <Card title="Preview your imports visually" icon="magnifying-glass" iconType="duotone">
    Get a sneak peek of your data. Select columns, apply filters & limits as per your need before importing.
  </Card>

  <Card title="Automatic Refreshes" icon="rotate" iconType="duotone">
    Enjoy one-click refreshes or schedule regular updates to ensure your sheets are always up to date.
  </Card>

  <Card title="Power of Google Sheets" icon="table-cells" iconType="duotone">
    Benefit from Google Sheets' collaborative data analysis & other powerful capabilities.
  </Card>
</CardGroup>

## Step-by-step walkthrough: How to connect Microsoft SQL to Google Sheets

<iframe width="560" height="415" src="https://www.youtube.com/embed/dFMR3OrjTgY?si=rBQIk1hcgqBwg8M7" title="Pull data from Microsoft SQL to Google Sheets" frameBorder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share" allowFullScreen style={{ width: "100%", borderRadius: "0.5rem" }} />

<Steps titleSize="h3">
  <Step title="Get Add-ons">
    Select `Add-ons` and choose `Get Add-ons`. This action will redirect you to the Google Workspace Marketplace.

    <Frame>
      <img src="https://mintcdn.com/superjoin/YLExbgl86h2tZ50q/images/getaddons.png?fit=max&auto=format&n=YLExbgl86h2tZ50q&q=85&s=ba23d07d1410cd3afb25454c5581cc85" alt="Get Add-ons" width="1361" height="648" data-path="images/getaddons.png" />
    </Frame>
  </Step>

  <Step title="Search Superjoin">
    In the Google Workspace Marketplace pop-up window, search for "Superjoin".
  </Step>

  <Step title="Click on Install">
    Click on the `Install` button to install Superjoin.
    <Note>**Note:** For the best experience, install Superjoin where there's only a single account logged in the Chrome profile.</Note>

    <Frame>
      <img src="https://mintcdn.com/superjoin/gjRFjFkthepgDSdX/images/marketplace.png?fit=max&auto=format&n=gjRFjFkthepgDSdX&q=85&s=8b32a5ed819c10448985a7e3df6f7731" alt="Marketplace" width="966" height="884" data-path="images/marketplace.png" />
    </Frame>
  </Step>

  <Step title="Launch Superjoin">
    Once installed, navigate back to the `Extensions` menu tab in Google Sheets. Launch Superjoin from here. You should now see Superjoin running as a side panel on the right side of your screen.

    <Frame>
      <img src="https://mintcdn.com/superjoin/gjRFjFkthepgDSdX/images/launchstackit.png?fit=max&auto=format&n=gjRFjFkthepgDSdX&q=85&s=14e2ecb541402cb914b79951a8faff16" alt="Launch Superjoin" width="1347" height="543" data-path="images/launchstackit.png" />
    </Frame>
  </Step>

  <Step title="Navigate to Queries">
    To begin, you can navigate to `Queries` , choose to  `Create new query`.

    <Frame>
      <img src="https://mintcdn.com/superjoin/gjRFjFkthepgDSdX/images/microsftsql/homepage.png?fit=max&auto=format&n=gjRFjFkthepgDSdX&q=85&s=28cfe023be3a0bb69e89809de5727929" alt="Navigate to Queries" width="1314" height="1426" data-path="images/microsftsql/homepage.png" />
    </Frame>
  </Step>

  <Step title="Connect a New Source">
    Navigate to `Sources`, select `Connect to a new source` and search for Microsoft SQL Server.

    <Frame>
      <img src="https://mintcdn.com/superjoin/gjRFjFkthepgDSdX/images/microsftsql/newconnection.png?fit=max&auto=format&n=gjRFjFkthepgDSdX&q=85&s=b7baa8c21b7f30c69bdc5d8a4ac1bde1" alt="Navigate to Queries" width="1314" height="1426" data-path="images/microsftsql/newconnection.png" />
    </Frame>
  </Step>

  <Step title="Enter Connection Details and Authorize">
    Enter your `Host Name/IP Address`, `Port number` (which is usually 3306), `Database Name` , `Username` ( Make sure to create a new user with read-only access to your database) and `Password`.
    Once this is done click on `Authorize` to allow Superjoin to access your Microsoft SQL Server data.

    <Frame>
      <img src="https://usercontent.clueso.io/b12466ec-51c0-441d-9320-d74e55240eff/dc8da7af-d4d6-41ba-8e7e-100c5c54894d/126f8b56-f2d3-4208-9b11-ffdb11a3b833/images/06c010c1-c445-47ec-b41a-a37c98d81c56.png" alt="Enter Connection Details" />
    </Frame>

    Once this is done click on `Authorize` to allow Superjoin to access your Microsoft SQL Server data.
  </Step>

  <Step title="Choose a Query Method">
    Choose between three query methods through which you would like to import.

    <Frame>
      <img src="https://mintcdn.com/superjoin/gjRFjFkthepgDSdX/images/microsftsql/query.png?fit=max&auto=format&n=gjRFjFkthepgDSdX&q=85&s=8491aeb43d4bea18a1dec5d0254ce753" alt="Enter SQL Query" width="1599" height="866" data-path="images/microsftsql/query.png" />
    </Frame>
  </Step>

  <Step title="Enter your SQL Query and Run">
    Enter you SQL query and click `Run query` and then you can preview your data.

    <Frame>
      <img src="https://usercontent.clueso.io/b12466ec-51c0-441d-9320-d74e55240eff/dc8da7af-d4d6-41ba-8e7e-100c5c54894d/126f8b56-f2d3-4208-9b11-ffdb11a3b833/images/e4ddb3b1-d19e-49f8-85f8-b25db2d05e9d.png" alt="Run Query" />
    </Frame>
  </Step>

  <Step title="Import Data">
    Once you have previewed the data select `Import` and wait for a few seconds. This action pulls all your data from Microsoft SQL to Google Sheets.

    <Frame>
      <img src="https://usercontent.clueso.io/b12466ec-51c0-441d-9320-d74e55240eff/dc8da7af-d4d6-41ba-8e7e-100c5c54894d/126f8b56-f2d3-4208-9b11-ffdb11a3b833/images/94966595-8a60-4b72-9e5f-3eb62b7209d6.png" alt="Import Data" />
    </Frame>
  </Step>

  <Step title="Setup Auto-Refresh">
    You can schedule a `Refresh` to automatically update your data daily, weekly, or monthly at a specific time.

    <Frame>
      <img src="https://usercontent.clueso.io/b12466ec-51c0-441d-9320-d74e55240eff/dc8da7af-d4d6-41ba-8e7e-100c5c54894d/126f8b56-f2d3-4208-9b11-ffdb11a3b833/images/fc66e8a3-06f8-4b0d-bb43-cb7af467dfeb.png" alt="Setup Auto-Refresh" />
    </Frame>
  </Step>
</Steps>
