Back to Nutshell in Excel
SheetXAI logo
Nutshell logo
Nutshell · Excel Guide

Provision Nutshell Custom Fields From a Excel workbook Config List

2026-05-14
5 min read

The Scenario

Your revenue ops team is standardizing Nutshell across three sales sub-teams who have been running it differently since the acquisition. The alignment plan includes eight new custom fields — some for accounts, some for contacts — each with a specific data type and naming convention. You have an Excel workbook with the full field specification. You need them all created in Nutshell before the training session on Thursday.

The bad version:

  • You open Nutshell's admin settings, navigate to custom fields, click "Add Field," type the name, select the type, choose the entity, save.
  • Eight fields. Eight trips through the same settings panel.
  • On field six, you realize the naming convention has a capitalization inconsistency. You go back and edit the first five.

The specs are clear. The creation process is a form-filling exercise that shouldn't require a human.

The Easy Way: One Prompt in SheetXAI

SheetXAI is an AI agent that lives inside your Excel workbook. It reads the field specification workbook and, through its built-in Nutshell integration, creates all eight custom fields in one operation.

Open SheetXAI in the sidebar and ask:

Read my Excel CRM-config sheet listing 8 custom field definitions and bulk-create them all in Nutshell right now

What You Get

  • All eight custom fields created in Nutshell with the specified names, types, and entity assignments.
  • Any rows with an unsupported field type flagged in a result column rather than silently skipped.
  • Field names applied exactly as specified.
  • A confirmation written back into a result column so you have a record of what was created.

What If the Data Is Not Quite Ready

Field names have inconsistent formatting

Before creating custom fields, normalize the field names to title case and trim whitespace — then create all eight Nutshell custom fields with the cleaned names

Some fields already exist in Nutshell

Check each field name against existing Nutshell custom fields before creating — skip any that already exist and write ALREADY EXISTS in the result column; create only the new ones

You need fields for three entity types

Create Nutshell custom fields for all rows in this workbook — use the entity column to determine whether each field applies to accounts, contacts, or leads — flag any rows where the entity type is unsupported

Full provisioning run with validation in one shot

Normalize field names to title case, check each against existing Nutshell custom fields, skip duplicates and flag them, then create all new fields using the type and entity from the workbook, writing the result (CREATED, SKIPPED, or ERROR) into the result column

When the training session is Thursday and the fields need to exist before then, describe the full provisioning operation in one prompt.

Try It

Get the 7-day free trial of SheetXAI and open your next CRM configuration workbook — then ask it to provision the custom fields in Nutshell directly. You can also bulk-import contacts, bulk-tag leads after a scoring exercise, or pull open pipeline data for a QBR.

Stop memorizing formulas.
Tell your spreadsheet what to do.

Join 4,000+ professionals saving hours every week with SheetXAI.

Learn more