Step-by-step guide for manually retrieving Record IDs to precisely map the field so that the data can be exported back to 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.
Click on Export
and download the data in a CSV file.
Click on File
—> Import
and then browse for the CSV file to import it in a new sheet.
Perform a VLOOKUP
on the new sheet to accurately find the Record IDs assigned to each record.
Now use the drag down feature for the VLOOKUP
to be applied for all records.
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.
Step-by-step guide for manually retrieving Record IDs to precisely map the field so that the data can be exported back to 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.
Click on Export
and download the data in a CSV file.
Click on File
—> Import
and then browse for the CSV file to import it in a new sheet.
Perform a VLOOKUP
on the new sheet to accurately find the Record IDs assigned to each record.
Now use the drag down feature for the VLOOKUP
to be applied for all records.
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.