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

# How to update existing HubSpot data from your Spreadsheet

> Step-by-step guide to update existing HubSpot data from Google Sheets or Microsoft Excel

<Tabs>
  <Tab id="gsheets" title="Google Sheets">
    <Steps titleSize="h3">
      <Step title="Choose the Source">
        In the Superjoin side panel, click on `Sources`, navigate through `Your Sources` and click on the HubSpot source you want to export the data to.

        <Frame>
          <img src="https://mintcdn.com/superjoin/ti4mZujLxipbXAga/images/hubspot/hs-export-common1.png?fit=max&auto=format&n=ti4mZujLxipbXAga&q=85&s=ded1a68d16868a2f8bb9a8c8556c5b95" alt="Choose the Source" width="2880" height="1800" data-path="images/hubspot/hs-export-common1.png" />
        </Frame>
      </Step>

      <Step title="Create new Export">
        A pop-up will come up at the bottom of the side panel. Click on `Export to HubSpot`.

        <Frame>
          <img src="https://mintcdn.com/superjoin/ti4mZujLxipbXAga/images/hubspot/hs-export-common2.png?fit=max&auto=format&n=ti4mZujLxipbXAga&q=85&s=e7bfb8c05f227fbe38e4fe3196b91e80" alt="Create new Export" width="930" height="908" data-path="images/hubspot/hs-export-common2.png" />
        </Frame>
      </Step>

      <Step title="Fill Source Data">
        Choose the sheet with the data that you want to export to HubSpot and the row with the header cells of the sheet that you want to export.

        <Frame>
          <img src="https://mintcdn.com/superjoin/ti4mZujLxipbXAga/images/hubspot/hs-export-common3.png?fit=max&auto=format&n=ti4mZujLxipbXAga&q=85&s=2ef8de1da6812def46a2fcec9ad8620b" alt="Fill Source Data" width="2880" height="1800" data-path="images/hubspot/hs-export-common3.png" />
        </Frame>
      </Step>

      <Step title="Select Destination">
        Choose the HubSpot `Object` you want to export data to, from the `Object` dropdown and select `Update` under the `Action` dropdown.

        <Frame>
          <img src="https://mintcdn.com/superjoin/ti4mZujLxipbXAga/images/hubspot/hs-export-update1.png?fit=max&auto=format&n=ti4mZujLxipbXAga&q=85&s=bedbe80458d5a6c8105844e76a569e66" alt="Select Destination" width="590" height="962" data-path="images/hubspot/hs-export-update1.png" />
        </Frame>

        <Note>If your sheet is dynamic, that is, the existing data constantly undergoes changes as well as new data keeps getting added, click on `Upsert`.</Note>

        <CardGroup cols={1}>
          <Card title="Need help with Upserting data into HubSpot?" icon="life-ring" iconType="duotone" href="upsert-data-google-sheets-hubspot">
            Head over to this page to get a detailed explanation on it.
          </Card>
        </CardGroup>
      </Step>

      <Step title="Mapping the Data">
        Map the Google Sheets columns to the HubSpot properties to ensure accuracy.

        <Frame>
          <img src="https://mintcdn.com/superjoin/ti4mZujLxipbXAga/images/hubspot/hs-export-common4.png?fit=max&auto=format&n=ti4mZujLxipbXAga&q=85&s=d7443a174b0578917d60bb992e9adf69" width="584" height="848" data-path="images/hubspot/hs-export-common4.png" />
        </Frame>

        <br />

        <Card img="https://mintcdn.com/superjoin/ti4mZujLxipbXAga/images/hubspot/hs-export-common5.png?fit=max&auto=format&n=ti4mZujLxipbXAga&q=85&s=17bc4a6c4cf86eebea0ee5a2421dc2c4" width="1236" height="1030" data-path="images/hubspot/hs-export-common5.png">
          Search for the HubSpot property you want to map your Google Sheet column to and click on it. Now repeat this for all the columns you want to map with the relevant HubSpot properties.
        </Card>

        Once you're done with the mapping, click on `Save` and then click on `Export`.

        <Note>Record IDs are mandatory to perform the `UPDATE` action. You can use the `Click here to get Record IDs` feature or retrieve the IDs manually.</Note>

        <CardGroup cols={1}>
          <Card title="Need help with retrieving Record IDs manually from HubSpot?" icon="life-ring" iconType="duotone" href="/faqs/manually-import-record-ids">
            Head over to this page to get a detailed explanation on it.
          </Card>
        </CardGroup>
      </Step>

      <Step title="Select rows or sheet to export">
        You can choose to export the entire sheet or only specific rows. If you want to export specific rows, further select the rows you want to export.

        <Frame>
          <img src="https://mintcdn.com/superjoin/ti4mZujLxipbXAga/images/hubspot/hs-export-common6.png?fit=max&auto=format&n=ti4mZujLxipbXAga&q=85&s=a3f18109a0042bcd4d83ac15b50e7563" alt="Select rows or sheet to export" width="958" height="860" data-path="images/hubspot/hs-export-common6.png" />
        </Frame>
      </Step>

      <Step title="Export Data">
        Verify the number of rows and click on `Update in HubSpot` button, this action exports the selected data from your Google Sheets into your HubSpot account.

        <Frame>
          <img src="https://mintcdn.com/superjoin/ti4mZujLxipbXAga/images/hubspot/hs-export-common7.png?fit=max&auto=format&n=ti4mZujLxipbXAga&q=85&s=ab1ca39ff4f0dd6af6d92f23883bb027" alt="Export Data" width="588" height="916" data-path="images/hubspot/hs-export-common7.png" />
        </Frame>

        This completes the process of using Superjoin to update existing HubSpot data from Google Sheets. <br />
        Below are the steps to automate this process.
      </Step>

      <Step title="Automate the process">
        Now you'll see a card called `Automatic Exports`. Click on the `Create Schedule` button.

        <Frame>
          <img src="https://mintcdn.com/superjoin/ti4mZujLxipbXAga/images/hubspot/hs-export-common8.png?fit=max&auto=format&n=ti4mZujLxipbXAga&q=85&s=0a9b39f462b9b8f00651e05829b7273f" alt="Export Data" width="1254" height="1104" data-path="images/hubspot/hs-export-common8.png" />
        </Frame>
      </Step>

      <Step title="Create a schedule">
        Configure the frequency in which you want this export process to repeat.

        <Frame>
          <img src="https://mintcdn.com/superjoin/ti4mZujLxipbXAga/images/hubspot/hs-export-common9.png?fit=max&auto=format&n=ti4mZujLxipbXAga&q=85&s=9d038776555b9438fe2e09a7e6237ff2" alt="Export Data" width="984" height="962" data-path="images/hubspot/hs-export-common9.png" />
        </Frame>
      </Step>
    </Steps>

    ##### Hope this guide helped you export your data from Google Sheets to HubSpot using Superjoin.

    ##### If you have any questions or need further assistance, please don’t hesitate to reach out to our support team. Thank you!
  </Tab>

  <Tab id="excel" title="Microsoft Excel">
    #### Coming Soon!
  </Tab>
</Tabs>
