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

> Effortlessly connect PayPal to Google Sheets in a few clicks using Superjoin

### Why use Superjoin's Google Sheets-PayPal 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 PayPal to Google Sheets

<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" 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 is 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>
  </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" 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 `PayPal`.

    <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>

    <Frame>
      <img src="https://mintcdn.com/superjoin/95T8cmea616drJuC/images/paypal/paypal_1.png?fit=max&auto=format&n=95T8cmea616drJuC&q=85&s=336e09a7b215084f39c48ce19dda55c5" width="491" height="520" data-path="images/paypal/paypal_1.png" />
    </Frame>
  </Step>

  <Step title="Link Account">
    Add Client Id and Client Secret, then Click on the `Connect` button and follow the on-screen instructions to link your PayPal account.

    <CardGroup cols={1}>
      <Card title="Create new API credentials in PayPal" icon="key" iconType="duotone" href="../paypal/create-key">
        Step-by-step guide to obtain or generate PayPal API credentials
      </Card>
    </CardGroup>

    <Frame>
      <img src="https://mintcdn.com/superjoin/95T8cmea616drJuC/images/paypal/paypal_2.png?fit=max&auto=format&n=95T8cmea616drJuC&q=85&s=74c57e6a02332d1bcd76a009ae7ca8d4" width="972" height="1472" data-path="images/paypal/paypal_2.png" />
    </Frame>
  </Step>

  <Step title="Preview Data">
    After connecting your account, a data preview window will appear, allowing you to modify your `Objects` (like Transactions, Payments, Invoices, etc.) and apply various `Filters` to refine your data.

    <Info>
      Select the date range for which you want to import the transaction or payment data.
    </Info>
  </Step>

  <Step title="Add/Modify columns">
    Add/modify the data fields you want to import. You can select specific transaction details like Date, Amount, Description, Status, and more. The `Fields` you selected should start showing up in the data preview section.
  </Step>

  <Step title="Apply Filters (Optional)">
    You can filter your PayPal data based on:

    * Transaction types (sales, refunds, transfers)
    * Date range
    * Payment status
    * Amount range
    * Currency
  </Step>

  <Step title="Sort and Limit Data (Optional)">
    You can sort your data by date, amount, or other fields, and set a row limit to control how many transactions are imported.
  </Step>

  <Step title="Import Data">
    After previewing the data, click on `Import` and wait for a few seconds. This action transfers all selected PayPal transaction data into your Google Sheets.
  </Step>

  <Step title="Setup Auto-Refresh">
    You can schedule a `Refresh` to automatically update your data daily, weekly, or monthly at a specific time. This is particularly useful for keeping your PayPal transaction data up-to-date for regular financial reporting.
  </Step>
</Steps>

##### Hope this guide helped you connect PayPal to Google Sheets using Superjoin.

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