> ## 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 Analytics to Spreadsheets

> Effortlessly connect your Google Analytics data to Google Sheets or Microsoft Excel for unified reporting and analysis.

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

    <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" 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 `Extensions` from the Google Sheets menu.
        <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" 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" width="1347" height="543" data-path="images/launchstackit.png" />
        </Frame>

        <br />

        <Frame>
          <img src="https://mintcdn.com/superjoin/YLExbgl86h2tZ50q/images/googleanalytics/g_analytics_1.jpeg?fit=max&auto=format&n=YLExbgl86h2tZ50q&q=85&s=3631c3a464078bb009c500d082984229" width="2870" height="1556" data-path="images/googleanalytics/g_analytics_1.jpeg" />
        </Frame>
      </Step>

      <Step title="Pick Google Analytics">
        Click on "Connect new Source" and select Google Analytics from the list of available data sources.

        <Frame>
          <img src="https://mintcdn.com/superjoin/YLExbgl86h2tZ50q/images/googleanalytics/g_analytics_2.jpeg?fit=max&auto=format&n=YLExbgl86h2tZ50q&q=85&s=6bdafcbe5d9e00a2a0d7fee6e497b1a7" width="1040" height="744" data-path="images/googleanalytics/g_analytics_2.jpeg" />
        </Frame>

        <br />

        <Frame>
          <img src="https://mintcdn.com/superjoin/YLExbgl86h2tZ50q/images/googleanalytics/g_analytics_3.jpeg?fit=max&auto=format&n=YLExbgl86h2tZ50q&q=85&s=081c6f2424dd8d9f5d68c44e36bde257" width="1112" height="704" data-path="images/googleanalytics/g_analytics_3.jpeg" />
        </Frame>
      </Step>

      <Step title="Connect your account">
        <Frame>
          <img src="https://mintcdn.com/superjoin/YLExbgl86h2tZ50q/images/googleanalytics/g_analytics_4.jpeg?fit=max&auto=format&n=YLExbgl86h2tZ50q&q=85&s=26daa9c84cbe33dca69d3782155e50a7" width="1202" height="780" data-path="images/googleanalytics/g_analytics_4.jpeg" />
        </Frame>

        <br />

        <Frame>
          <img src="https://mintcdn.com/superjoin/YLExbgl86h2tZ50q/images/googleanalytics/g_analytics_5.jpeg?fit=max&auto=format&n=YLExbgl86h2tZ50q&q=85&s=f2e2c8945809eb4ec0b8f2928a598581" width="798" height="1224" data-path="images/googleanalytics/g_analytics_5.jpeg" />
        </Frame>
      </Step>

      <Step title="Select filters">
        Select the filters that you want to apply to filter down the data that you want to work on.

        <Frame>
          <img src="https://mintcdn.com/superjoin/YLExbgl86h2tZ50q/images/googleanalytics/g_analytics_7.jpeg?fit=max&auto=format&n=YLExbgl86h2tZ50q&q=85&s=ca93074136de5dac40f6b399009590e0" width="1988" height="866" data-path="images/googleanalytics/g_analytics_7.jpeg" />
        </Frame>
      </Step>

      <Step title="Click Import">
        Now simply click on the "Import" button to bring this selected data into your Google Sheets.

        <Frame>
          <img src="https://mintcdn.com/superjoin/YLExbgl86h2tZ50q/images/googleanalytics/g_analytics_8.jpeg?fit=max&auto=format&n=YLExbgl86h2tZ50q&q=85&s=21748d677691e0beff4784474273b5b7" width="2378" height="1394" data-path="images/googleanalytics/g_analytics_8.jpeg" />
        </Frame>

        <br />

        <Frame>
          <img src="https://mintcdn.com/superjoin/YLExbgl86h2tZ50q/images/googleanalytics/g_analytics_9.jpeg?fit=max&auto=format&n=YLExbgl86h2tZ50q&q=85&s=7375f0786ff9bf5e8b5be323d2790771" width="2864" height="1532" data-path="images/googleanalytics/g_analytics_9.jpeg" />
        </Frame>
      </Step>

      <Step title="Data pulled! Setup an auto-refresh schedule.">
        Superjoin lets you refresh your imported data instantly with one click or set it to auto-refresh on a pre-set schedule. This way, you won't need to manually update your Google Analytics data in Google Sheets to reflect changes from the source.

        <Frame>
          <img src="https://mintcdn.com/superjoin/YLExbgl86h2tZ50q/images/googleanalytics/g_analytics_10.jpeg?fit=max&auto=format&n=YLExbgl86h2tZ50q&q=85&s=4308a49287ece7e28a7ffc8a0edbd841" width="712" height="1002" data-path="images/googleanalytics/g_analytics_10.jpeg" />
        </Frame>

        <br />

        <Frame>
          <img src="https://mintcdn.com/superjoin/YLExbgl86h2tZ50q/images/googleanalytics/g_analytics_11.jpeg?fit=max&auto=format&n=YLExbgl86h2tZ50q&q=85&s=496cfe72052941fc8257b7b2e53d39ac" width="2842" height="1458" data-path="images/googleanalytics/g_analytics_11.jpeg" />
        </Frame>
      </Step>
    </Steps>
  </Tab>

  <Tab id="excel" title="Microsoft Excel">
    ### Why use Superjoin's Excel-Google Analytics 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 Analytics 4 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 Analytics`.

        <Frame>
          <img src="https://mintcdn.com/superjoin/YLExbgl86h2tZ50q/images/googleanalytics/g_analytics_2.jpeg?fit=max&auto=format&n=YLExbgl86h2tZ50q&q=85&s=6bdafcbe5d9e00a2a0d7fee6e497b1a7" alt="Connect a New Source" width="1040" height="744" data-path="images/googleanalytics/g_analytics_2.jpeg" />
        </Frame>
      </Step>

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

        <Frame>
          <img src="https://mintcdn.com/superjoin/YLExbgl86h2tZ50q/images/googleanalytics/g_analytics_4.jpeg?fit=max&auto=format&n=YLExbgl86h2tZ50q&q=85&s=26daa9c84cbe33dca69d3782155e50a7" alt="Link Account" width="1202" height="780" data-path="images/googleanalytics/g_analytics_4.jpeg" />
        </Frame>
      </Step>

      <Step title="Choose Account">
        Select your Google Analytics 4 property and view that you want to import data from.

        <Frame>
          <img src="https://mintcdn.com/superjoin/YLExbgl86h2tZ50q/images/googleanalytics/g_analytics_5.jpeg?fit=max&auto=format&n=YLExbgl86h2tZ50q&q=85&s=f2e2c8945809eb4ec0b8f2928a598581" width="798" height="1224" data-path="images/googleanalytics/g_analytics_5.jpeg" />
        </Frame>
      </Step>

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

        <Frame>
          <img src="https://mintcdn.com/superjoin/YLExbgl86h2tZ50q/images/googleanalytics/g_analytics_7.jpeg?fit=max&auto=format&n=YLExbgl86h2tZ50q&q=85&s=ca93074136de5dac40f6b399009590e0" alt="Configure Data" width="1988" height="866" data-path="images/googleanalytics/g_analytics_7.jpeg" />
        </Frame>
      </Step>

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

        <Frame>
          <img src="https://mintcdn.com/superjoin/YLExbgl86h2tZ50q/images/googleanalytics/g_analytics_8.jpeg?fit=max&auto=format&n=YLExbgl86h2tZ50q&q=85&s=21748d677691e0beff4784474273b5b7" alt="Import Data" width="2378" height="1394" data-path="images/googleanalytics/g_analytics_8.jpeg" />
        </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://mintcdn.com/superjoin/YLExbgl86h2tZ50q/images/googleanalytics/g_analytics_10.jpeg?fit=max&auto=format&n=YLExbgl86h2tZ50q&q=85&s=4308a49287ece7e28a7ffc8a0edbd841" alt="Refresh Data" width="712" height="1002" data-path="images/googleanalytics/g_analytics_10.jpeg" />
        </Frame>
      </Step>
    </Steps>
  </Tab>
</Tabs>

##### Hope this guide helped you pull data from your Google Analytics to your spreadsheet.

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