The Scenario
You're a marketing operations manager who just took over a Laposta account that has five mailing lists built by three different people over two years. Before you clean up the schema, you need to know what's actually there: every custom field on every list, with its name, type, required flag, and default value.
The Laposta UI shows custom fields one list at a time. You have five lists.
The bad version:
- Open Laposta list one, go to Settings, scroll to Custom Fields, write down each field
- Switch to list two, repeat
- Do this five times, copying into a growing spreadsheet and hoping you got the types right
- Realize you noted field four on list three as required when it's actually optional — go back and check
The schema cleanup is supposed to start next week. You can't plan which fields to rename or remove until you know what's there, and you can't afford to spend three hours on reconnaissance.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet. It calls the Laposta custom fields API for each list in your account and writes the complete inventory to a single tab, with every field labeled clearly.
For every mailing list in my Laposta account, fetch all custom fields and write them to Sheet1 with columns: list name, field name, field type, required (yes/no), default value
What You Get
- One row per custom field across all five lists
- List name in column A, field name in column B, type in column C
- Required flag as yes or no in column D, default value in column E (blank if none set)
- Lists with no custom fields contribute zero rows
- Total field count per list available in the SheetXAI sidebar on request
What If the Data Is Not Quite Ready
You want a count of how many lists each field name appears on
Pull all custom fields from all Laposta lists into Sheet1: list name, field name, field type, required; add column E counting how many lists in the account have a field with the same name
You want to flag fields that exist on some lists but not others
Fetch all custom fields from all Laposta lists, identify field names that appear on at least one list but not all five, and write those to Sheet2 with columns: field name, lists it appears on, lists it is missing from
You only need the fields from one specific list to start
Pull all fields from Laposta list Newsletter-EU and paste them into Sheet1 so I can review which ones to rename or remove — include field name, type, required flag, and default value
Full schema audit with rename candidates flagged in one shot
Fetch all custom fields across all Laposta lists into Sheet1: list name, field name, field type, required, default value; in column F write RENAME CANDIDATE if the field name contains underscores or is all lowercase; sort by list name then field name
The schema cleanup begins with accurate information instead of a half-finished spreadsheet assembled across five browser tabs.
Try It
Get the 7-day free trial of SheetXAI and open a blank Google Sheet, then ask it to inventory all custom fields across your Laposta account. You can follow up by asking it to create standardized replacement fields on lists where the schema is inconsistent.