Skip to main content

Overview: ExtendInsights HubSpot Workspace

ExtendInsights HubSpot | Understand the Excel workspace after loading a template

Overview

When you load a template, ExtendInsights transforms your worksheet into a workspace for managing data.

This article explains each area of the workspace and what it's used for.


Workspace Layout

  • The table loads on the left side of the worksheet.

  • The ExtendInsights panel provides options to download, upload, refresh, and delete records within Excel.


Key Sections

1. Row 1 – Mapping Syntax

  • Reserved for data source field names (hidden by default).

  • Should not be edited unless you are a power user.

  • Click on a cell in Row 1 to reveal field names.

2. Column A – Error Messages

  • Displays error messages encountered when sending data to your data source.

  • Helps quickly identify and correct issues.

3. Record ID Field

  • Represents the unique identifier for an object or record type.

  • A unique alphanumeric value used to manage specific records.

4. Connections

  • Establish connections to the data source.

5. Object and Fields

  • Define objects and fields clearly to establish the foundation of your data.

  • This serves as a guide on how your data, your data source, and Excel will communicate.

6. Filter

  • Set criteria rules within the app using filter options.

  • Filtering is based on object, filter type, operator, and values to refine your dataset.

7. Preview

  • Previewing your data helps validate the template structure before finalizing.

  • Download the first 50 records when enabled, and the Proceed button is triggered.

8. Proceed

  • If preview is turned off, the table will appear blank until data is fetched.

  • If preview is turned on, download the first 50 records.

9. Save as Template

  • Save your templates in ExtendInsights to avoid repetitive mapping.

  • If you frequently update similar data, pre-configured templates improve efficiency.

10. Assign Schedule

  • Automate data downloads by scheduling filters or SOQL queries.

  • Click Assign Schedule > Create to set up automatic syncs.

11. ExtendInsights Actions

  • ExtendInsights enables users to efficiently manage records by performing:
    Create, upload, and delete operations.
    Filter and download records for streamlined data management.

12. Picklist Cell Operations

  • ExtendInsights recognizes list-type fields in your template.

  • You can view and select values directly from your data source.


What Would You Like to Do Next?

I want to...

Learn More

Build a template

Download records

Create new records

Update existing records

Save templates

Create a connection


💬 Need Help?

Before contacting Support, try searching:

If you still need assistance:

Did this answer your question?