HubSpot Grid Edit Overview

Insycle's Grid Edit module supports the following HubSpot object types:

• Companies
• Contacts
• Courses
• Custom Objects
• Deals
• Leads
• Line Items
• Listings
• Orders
• Tickets

You can select the object type that you would like to work with at the top menu of the module.

Use the Filter to Find Relevant Records

Navigate to Data Management > Grid Edit, and select the object type in the top menu. Then explore the templates for an existing solution that may be close to what you need.

On the Filter tab, select the Field to work with. Use the Condition to set the rule that the data in the selected field must meet. With this filter, you're telling Insycle what records you would like to update.

In the example below, we are looking for Gmail, Hotmail, and Yahoo email addresses with typos.

Click the Search button, and a preview of the records that match this filter will load in the Record Viewer at the bottom of the page. Look through the results to see if there's anything else you want to filter out. If you make changes to the filter, click the Search button again to reload the Viewer.

Edit the Field Values One-by-One

Review the results in the Record Viewer, hover over a value you want to update, and click the pencil icon.

In the Edit popup, update the value and click Save. As soon as you save, the field update is pushed to your live database.

You can save your settings as a template to reuse this setup for future editing tasks.

Return to the Template menu at the top of the page and click Copy to save your configurations as a new version of the template you started with. Then click the pencil to edit your new template name.

With your filter and layout set, Insycle can export your segment of data. The Grid Edit module lets you export your data one time, immediately, or set up automated exports.

Click the Export button below the filter.

In the Export popup, select New File and click Next.

On the Email tab, enter additional email addresses (hit Enter after each), a Subject, and Description. The CSV export will be attached to this email whenever it is generated.

To export the data once:

On the When tab, click Run Now and select which records to apply the change to, then click the Run Now button.

To set up automation for recurring exports:

On the When tab under Automate, set up the frequency your CSV should automatically be exported--hourly, daily, weekly, or monthly.

Data that matches your set filter will be automatically exported and emailed to you or your team on a set schedule, improving data collaboration and helping you keep an eye on the most important customer data.

To revisit your scheduled automation, navigate to Operations > Automations and search by the template name.

To change the fields that appear in the Record Viewer and CSV export, click the Layout tab.

In the right column, you can search for fields to add to the layout and drag them into the left Visible Fields column. Remove fields by dragging from the Visible Fields column into the right column.

If you are sure a value exists in HubSpot but you aren't seeing it in the Record Viewer at the bottom of the page, it is often due to the Filter settings.

Here are a few things to look into:

1. Make sure there isn't anything in the filter that you didn't intend to be. This often happens if you started with an existing template.
2. Ensure that your filter is accurate, and not too specific. For instance, if you are using the "is" operator in your filter, you might broaden the condition using "contains" or "starts with" to identify other records with slight differences.
3. Make sure that you have clicked the Search button.

If you still don't see the expected data, it is likely a field syncing issue.

To refresh the data in Insycle, navigate to Settings > Sync Status, select the account, and click the Refresh Accounts List button. Alternatively, you could log out of Insycle and then log back in.
For help re-syncing a specific field, contact Insycle support.