> ## 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 PostgreSQL Database to Google Sheets

> Connect PostgreSQL to Google Sheets in just a few clicks for easy data analysis directly in your spreadsheets.

superjoin has revolutionized the way organizations connect to PostgreSQL databases, offering secure and efficient connection solutions. This guide will walk you through setting up a connection with superjoin, ensuring you can leverage the full capabilities of superjoin with your PostgreSQL database. 🚀

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

<iframe width="560" height="415" src="https://www.youtube.com/embed/m5muhl6xODY?si=hvT-fb_7WXsmQZrk" title="Pull data from PostgreSQL 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="h2">
  <Step title="Launch Superjoin">
    Once Superjoin is installed, navigate 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://mintlify.s3.us-west-1.amazonaws.com/superjoin/integrations/postgres/images/launchstackit.png" />
    </Frame>
  </Step>

  <Step title="Pick PostgreSQL">
    Select PostgreSQL from the list of available data sources.

    <Frame>
      <img src="https://mintcdn.com/superjoin/95T8cmea616drJuC/images/mysql/ms-step2.webp?fit=max&auto=format&n=95T8cmea616drJuC&q=85&s=5137dae9dc53eb1d88167b978e1ec98c" width="1821" height="870" data-path="images/mysql/ms-step2.webp" />
    </Frame>
  </Step>

  <Step title="Connect your PostgreSQL Database">
    Enter your connection credentials.

    <Warning>
      Avoid using local IP address (127.0.0.1) or private IP addresses like 192.168.1.100 (192.168.X.X). A private IP address for a server is like a private address of your device in a home or office network which can only be accessed from within the network and not from outside.
    </Warning>

    <Note>
      Typically, you can find these details in the configuration files of the application that interacts with your database, such as a config.php, .env, or other server-side configuration files. Alternatively, you may access these details from your database management system like phpMyAdmin or directly through PostgreSQL command line using the status command.
    </Note>

    | Field    | Description                                                             | Example                |
    | -------- | ----------------------------------------------------------------------- | ---------------------- |
    | Host     | Enter the path to your database, which could be a URL or an IP address. | mydatabase.example.com |
    | Port     | Use the specific port for your PostgreSQL database.                     | Default is 5432        |
    | Database | Specify the name of the database you want to query.                     | mydatabase             |
    | User     | Enter the username for connecting to your PostgreSQL database.          | admin or user123       |
    | Password | Provide the password corresponding to the specified user.               | password123            |

    <Frame>
      <img src="https://mintcdn.com/superjoin/95T8cmea616drJuC/images/mysql/ms-step3.webp?fit=max&auto=format&n=95T8cmea616drJuC&q=85&s=b8b0b907b03582e7a097d866419f95ff" width="1821" height="870" data-path="images/mysql/ms-step3.webp" />
    </Frame>
  </Step>
</Steps>

## Setting up Amazon RDS

<CardGroup cols={1}>
  <Card title="Looking for RDS?" icon="life-ring" iconType="duotone" href="../rds/overview">
    Head over to the AWS RDS page to get a step by step guide to connect or troubleshoot connectivity.
  </Card>
</CardGroup>