> ## 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 Google Search Console to Spreadsheets

> Effortlessly connect your Google Search Console account to Google Sheets or Microsoft Excel for simplified reporting and analysis.

<Tabs>
  <Tab id="gsheets" title="Google Sheets">
    ### Why use Superjoin's Google Sheets-Google Search Console 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 Google Search Console to Google Sheets

    <iframe width="560" height="415" src="https://www.youtube.com/embed/km9JViB7BSs?si=FP650NuQEFL5qRhH" title="Pull data from Google Search Console 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">
        Head over to `Extensions` , 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 `Google Search Console`.

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

      <Step title="Link Account">
        Click on the `Connect` button and follow the on-screen instructions to link your account.

        <Frame>
          <img src="https://mintcdn.com/superjoin/YLExbgl86h2tZ50q/images/googlesearchconsole/gscconnection.png?fit=max&auto=format&n=YLExbgl86h2tZ50q&q=85&s=06c686471d051eec3f481612f7df4b4e" alt="Link Account" width="1314" height="1694" data-path="images/googlesearchconsole/gscconnection.png" />
        </Frame>
      </Step>

      <Step title="Preview Data">
        After connecting your account, a data preview window will appear, allowing you to modify your metrics and apply various filters to refine your data.

        <Frame>
          <img src="https://mintcdn.com/superjoin/YLExbgl86h2tZ50q/images/googlesearchconsole/dpgsc.png?fit=max&auto=format&n=YLExbgl86h2tZ50q&q=85&s=6293c5c11711b54ed98ffa60f6ef97c2" alt="Import Data" width="3054" height="1694" data-path="images/googlesearchconsole/dpgsc.png" />
        </Frame>
      </Step>

      <Step title="Import Data">
        After previewing the data, click on `Import` and wait for a few seconds. This action transfers all data from your Google Search Console account into Google Sheets.

        <Frame>
          <img src="https://usercontent.clueso.io/b12466ec-51c0-441d-9320-d74e55240eff/075f0f38-76e6-4fb7-8d4e-7a0a7f77d2cf/f0a394ad-354f-49b9-8042-d1572da0e850/images/5658d87e-6d3b-4751-ac0f-08c7b169a7c6.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/075f0f38-76e6-4fb7-8d4e-7a0a7f77d2cf/f0a394ad-354f-49b9-8042-d1572da0e850/images/da41c0ec-483a-429d-abd7-6fdc5473e2f2.png" alt="Setup Auto-Refresh" />
        </Frame>
      </Step>
    </Steps>
  </Tab>

  <Tab id="excel" title="Microsoft Excel">
    ### Why use Superjoin's Excel-Google Search Console 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="One-Click Refreshes" icon="rotate" iconType="duotone">
        Enjoy one-click refreshes to ensure your sheets are always up to date.
      </Card>

      <Card title="Power of Microsoft Excel" icon="table-cells" iconType="duotone">
        Benefit from Microsoft Excel's powerful data analysis & visualization capabilities.
      </Card>
    </CardGroup>

    ## Step-by-step walkthrough: How to connect Google Search Console to Microsoft Excel

    <Steps titleSize="h3">
      <Step title="Launch Add-ins">
        Click on `Add-ins` on the right side of the Excel toolbar.

        <Frame>
          <img src="https://mintcdn.com/superjoin/YLExbgl86h2tZ50q/images/get-addins.png?fit=max&auto=format&n=YLExbgl86h2tZ50q&q=85&s=9a602917c1d56ab7f30977dc0f467293" width="2880" height="1800" data-path="images/get-addins.png" />
        </Frame>
      </Step>

      <Step title="Get Add-in">
        Click on the searchbar and type "Superjoin". The results would show our add-in under the `More search results` section.

        <Frame>
          <img src="https://mintcdn.com/superjoin/Fj1m3rGY5-lshl-N/images/excel-addin.png?fit=max&auto=format&n=Fj1m3rGY5-lshl-N&q=85&s=2eaebe9dbede327814e129893f551325" width="491" height="665" data-path="images/excel-addin.png" />
        </Frame>
      </Step>

      <Step title="Authenticate with your Microsoft Account">
        Once Superjoin launches as a side panel, just click on `Sign in with Microsoft` and follow the steps to authenticate your Microsoft Office account with Superjoin.

        <Frame>
          <img src="https://mintcdn.com/superjoin/Fj1m3rGY5-lshl-N/images/excel-auth.png?fit=max&auto=format&n=Fj1m3rGY5-lshl-N&q=85&s=052b68df7e66f275c750ff01d446ac50" width="2560" height="1440" data-path="images/excel-auth.png" />
        </Frame>
      </Step>

      <Step title="Launch Superjoin">
        You should now see Superjoin running as a side panel on the right side of your screen.

        <Frame>
          <img src="https://mintcdn.com/superjoin/Fj1m3rGY5-lshl-N/images/excel-superjoin.png?fit=max&auto=format&n=Fj1m3rGY5-lshl-N&q=85&s=ec2d8be38abd9d4fa3fcb9b4fca35788" width="2560" height="1440" data-path="images/excel-superjoin.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 `Google Search Console`.

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

      <Step title="Link Account">
        Click on the `Connect` button and follow the on-screen instructions to link your Google Search Console account.

        <Frame>
          <img src="https://mintcdn.com/superjoin/YLExbgl86h2tZ50q/images/googlesearchconsole/gscconnection.png?fit=max&auto=format&n=YLExbgl86h2tZ50q&q=85&s=06c686471d051eec3f481612f7df4b4e" alt="Link Account" width="1314" height="1694" data-path="images/googlesearchconsole/gscconnection.png" />
        </Frame>
      </Step>

      <Step title="Configure Data Selection">
        After connecting your account, a data preview window will appear, allowing you to select your metrics and dimensions, apply date ranges, and set various filters to refine your Search Console data.

        <Frame>
          <img src="https://mintcdn.com/superjoin/YLExbgl86h2tZ50q/images/googlesearchconsole/dpgsc.png?fit=max&auto=format&n=YLExbgl86h2tZ50q&q=85&s=6293c5c11711b54ed98ffa60f6ef97c2" alt="Configure Data" width="3054" height="1694" data-path="images/googlesearchconsole/dpgsc.png" />
        </Frame>
      </Step>

      <Step title="Import Data">
        Once you've configured your data selection, click the "Import" button to bring your Google Search Console data into Microsoft Excel.

        <Frame>
          <img src="https://usercontent.clueso.io/b12466ec-51c0-441d-9320-d74e55240eff/075f0f38-76e6-4fb7-8d4e-7a0a7f77d2cf/f0a394ad-354f-49b9-8042-d1572da0e850/images/5658d87e-6d3b-4751-ac0f-08c7b169a7c6.png" alt="Import Data" />
        </Frame>
      </Step>

      <Step title="Refresh Data">
        Your data has been imported successfully! You can refresh your data at any time by clicking the refresh button in the Superjoin panel.

        <Frame>
          <img src="https://usercontent.clueso.io/b12466ec-51c0-441d-9320-d74e55240eff/075f0f38-76e6-4fb7-8d4e-7a0a7f77d2cf/f0a394ad-354f-49b9-8042-d1572da0e850/images/da41c0ec-483a-429d-abd7-6fdc5473e2f2.png" alt="Refresh Data" />
        </Frame>
      </Step>
    </Steps>
  </Tab>
</Tabs>

##### Hope this guide helped you connect Google Search Console to your spreadsheet using Superjoin.

##### If you have any questions or need further assistance, please don't hesitate to reach out to our support team [support@superjoin.ai](mailto:support@superjoin.ai). Thank you!