> ## 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 retrieve Record IDs manually

> Step-by-step guide for manually retrieving Record IDs to precisely map the field so that the data can be exported back to HubSpot

##### If your preferred workflow requires getting the IDs manually from HubSpot, here’s how you can do it:

<Steps titleSize="h3">
  <Step title="Gather the relevant Record IDs by matching the Data between Sheets and HubSpot">
    Go to the `Object` in HubSpot and tweak the `Advanced filters` in order to view the exact data you’ve been working with on Google Sheets so that you retrieve the accurate Record IDs.

    <Frame>
      <img src="https://mintcdn.com/superjoin/ti4mZujLxipbXAga/images/hubspot/record-id2.jpeg?fit=max&auto=format&n=ti4mZujLxipbXAga&q=85&s=a0945ea8968539ef4af1138059db82d6" width="2880" height="1800" data-path="images/hubspot/record-id2.jpeg" />
    </Frame>
  </Step>

  <Step title="Export the data as a CSV file">
    Click on `Export` and download the data in a CSV file.

    <Frame>
      <img src="https://mintcdn.com/superjoin/ti4mZujLxipbXAga/images/hubspot/record-id3.jpeg?fit=max&auto=format&n=ti4mZujLxipbXAga&q=85&s=4bfb92eb1be5b391f924e7e15458a33c" width="2880" height="1800" data-path="images/hubspot/record-id3.jpeg" />
    </Frame>
  </Step>

  <Step title="Import the CSV to Sheets">
    Click on `File` --> `Import` and then browse for the CSV file to import it in a new sheet.

    <Frame>
      <img src="https://mintcdn.com/superjoin/ti4mZujLxipbXAga/images/hubspot/record-id5.png?fit=max&auto=format&n=ti4mZujLxipbXAga&q=85&s=76340fdd2be386d06a7e008e7097692c" width="2880" height="1800" data-path="images/hubspot/record-id5.png" />
    </Frame>
  </Step>

  <Step title="Match the Record IDs">
    Perform a `VLOOKUP` on the new sheet to accurately find the Record IDs assigned to each record.

    ```
    =VLOOKUP(record-to-search-for,'imported-csv-sheet'!range-of-search,column-number-of-record-IDs) 
    ```

    <Frame>
      <img src="https://mintcdn.com/superjoin/ti4mZujLxipbXAga/images/hubspot/record-id6.jpeg?fit=max&auto=format&n=ti4mZujLxipbXAga&q=85&s=1108a3e8b68161715f3918277b4eca7e" width="2880" height="1800" data-path="images/hubspot/record-id6.jpeg" />
    </Frame>

    <br />

    <Frame>
      <img src="https://mintcdn.com/superjoin/gjRFjFkthepgDSdX/images/hubspot/record-id8.jpeg?fit=max&auto=format&n=gjRFjFkthepgDSdX&q=85&s=97654ba290cd7aa6d8af9311e1eee329" width="2880" height="1800" data-path="images/hubspot/record-id8.jpeg" />
    </Frame>

    <br />

    <Card img="https://mintcdn.com/superjoin/ti4mZujLxipbXAga/images/hubspot/record-id7.jpeg?fit=max&auto=format&n=ti4mZujLxipbXAga&q=85&s=2c003a4dcf8c92878801eb13978a6b65" width="2880" height="1800" data-path="images/hubspot/record-id7.jpeg">
      Now use the drag down feature for the `VLOOKUP` to be applied for all records.
    </Card>
  </Step>

  <Step title="Map the fields">
    Map the Google Sheet's Record ID field to the HubSpot's Record ID field on Superjoin. Click on `Save` and then follow the rest of the steps on the `Export Data` page for exporting data back to Hubspot.

    <Frame>
      <img src="https://mintcdn.com/superjoin/gjRFjFkthepgDSdX/images/hubspot/record-id9.jpeg?fit=max&auto=format&n=gjRFjFkthepgDSdX&q=85&s=05fe2f2a9580de8d50e19b2aca940eb5" width="2880" height="1800" data-path="images/hubspot/record-id9.jpeg" />
    </Frame>
  </Step>
</Steps>

##### Hope this guide helped you manually retrieve Record IDs from HubSpot to Google Sheets.

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