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 a Google Sheet with the full field specification ready. 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 you've been using 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 Google Sheet. It reads the field specification sheet and, through its built-in Nutshell integration, creates all eight custom fields in one operation.
Open SheetXAI in the sidebar and ask:
Create Nutshell custom fields for each row in this sheet where column A is field name, column B is field type (Text, Currency, Date), and column C is the entity type (accounts or contacts)
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 — no capitalization changes, no automatic formatting.
- 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 in your sheet have inconsistent formatting
Before creating custom fields, normalize the field names in column A to title case and trim any leading or trailing whitespace — then create all eight Nutshell custom fields with the cleaned names
Some fields already exist in Nutshell and should be skipped
Check each field name in column A against existing Nutshell custom fields before creating — skip any that already exist and write ALREADY EXISTS in the result column for those rows; create only the new ones
You need fields created for a third entity type beyond accounts and contacts
Create Nutshell custom fields for all rows in this sheet — use column C to determine the entity type (accounts, contacts, or leads) — flag any rows where column C contains an unsupported entity type
Full provisioning run with validation in one shot
Normalize field names in column A to title case, check each against existing Nutshell custom fields, skip duplicates and flag them, then create all new fields using the type from column B and entity from column C, and write the result (CREATED, SKIPPED, or ERROR) into column D
When the training session is Thursday and the fields need to exist before then, describe the full provisioning operation — the normalization, the dedup check, the creation — in one prompt.
Try It
Get the 7-day free trial of SheetXAI and open your next CRM configuration sheet — 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 using the same approach.