The Scenario
You're the dev team lead. You want to create fifty bugs in Leiga from a workbook, but the import can't start until you know exactly what fields the 'Bug' issue type requires — and which ones are optional. The Leiga schema isn't something you have memorized. You could dig through the API documentation, or you could ask the person who set up the Leiga workspace, who is on vacation until next week.
The bad version has already cost you an hour:
The bad version:
- Open the Leiga API documentation, search for the issue type schema endpoint, and try to parse the JSON response structure for the 'Bug' type.
- Copy field names into your worksheet one by one, noting which are marked required, which accept text vs. select vs. date types.
- Discover two fields have been renamed in your workspace's configuration and the documentation doesn't reflect that.
Designing an import template is supposed to take fifteen minutes, not a morning. The fifty issues aren't even the hard part yet.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the issue type identifier from your worksheet, fetches the full custom field schema from Leiga through its built-in integration, and maps every field — name, type, required or optional — into your workbook as a column header row.
Retrieve the full custom field schema for Leiga issue type 'Feature Request' and turn it into a column header row in this Excel sheet so I can use it as a bulk-import template
What You Get
- A header row with one column per field in the issue type schema
- Field names exactly as Leiga returns them — no manual transcription
- Every field included — standard and custom — so your import template has the right columns from the start
What If the Data Is Not Quite Ready
You want a vertical field list rather than a header row
Fetch the Leiga issue schema for the issue type ID in cell A1 and list every field name, its type, and whether it is required in columns A–C of a new 'Schema' sheet
You need schemas for multiple issue types side by side
Fetch the Leiga issue schemas for the issue type IDs in cells A1, B1, and C1. Write each schema as a separate block in the 'Schema' sheet — label each block with the issue type ID it belongs to
You want to filter to required fields only for a minimal import template
Fetch the Leiga issue schema for the issue type in cell A1, filter to only the required fields, and write their names as a column header row in the 'Import Template' sheet
Build the full import-ready template in one prompt
Fetch the Leiga issue schema for the issue type ID in cell A1. Write all field names as a header row in the 'Import Template' sheet. In the row below the headers, write the field type for each column. Mark any required field headers in bold using a note in the row below: write 'REQUIRED' under required fields and 'OPTIONAL' under optional ones.
Schema fetched, typed, annotated, and ready for fifty rows of bulk input.
Try It
Get the 7-day free trial of SheetXAI and open the Excel workbook you're using to design your Leiga bulk-import — paste the issue type ID into A1 and ask it to write the full schema as a column header row. Also see how to compile sprint issue details once your import is done or the full Leiga integration hub.