The Scenario
You run support operations. Three weeks ago, a database migration went sideways and created a wave of customer issues. Your team collected them the only way they could at the time — a Google Sheet with 80 rows, each containing a contact email, a description of the problem, and a priority level. The incident is resolved, but those 80 issues still need to become Intercom tickets so they can be tracked, assigned, and closed properly.
Nobody has created them yet because the idea of doing 80 manual ticket entries is quietly being avoided by everyone.
The bad version:
- Open Intercom, find the contact by email, open their profile, click "New conversation", set the type to Ticket, paste the description from the sheet, set priority, save.
- Do this 79 more times.
- Realize 12 contacts from the sheet do not exist in Intercom yet and have to be created first before the tickets can be attached.
There is no version of this that takes less than two hours.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the issue rows and creates a corresponding Intercom ticket for each one, writing the ticket ID back so you have an audit trail.
Create an Intercom ticket for each row in this sheet — column A is contact email, column B is ticket subject, column C is description, column D is priority — write the new ticket ID into column E.
What You Get
- One Intercom ticket created per row, attached to the contact matching the email in column A.
- Ticket subject, description, and priority set from columns B, C, and D respectively.
- New ticket ID written to column E for each row so you can link the sheet row back to the ticket.
- If a contact does not exist, an error message is written to column E for that row so you know which ones need manual follow-up.
What If the Data Is Not Quite Ready
Priority values in the sheet do not match Intercom's expected format
The sheet uses "P1", "P2", "P3" but Intercom expects "urgent", "high", "medium".
Before creating tickets, remap column D: replace "P1" with "urgent", "P2" with "high", "P3" with "medium" — then create the Intercom ticket for each row and write the ticket ID to column E.
Some rows are missing a subject line
The description is there but the subject field is blank for about 15 rows.
Create Intercom tickets from this sheet — if column B is blank, use the first 60 characters of column C as the subject — write the ticket ID or error to column E.
Issues are split across two tabs from different incident phases
Phase 1 issues are in the "Initial Impact" tab, Phase 2 in the "Ongoing Issues" tab.
Create Intercom tickets from both the "Initial Impact" and "Ongoing Issues" tabs — email in column A, subject in column B, description in column C, priority in column D in each tab — write the new ticket ID to column E in each respective tab.
Remap priorities, fill missing subjects, create tickets, and log results in one prompt
You want the full operation done cleanly without multiple passes.
In this sheet, remap column D (P1 to urgent, P2 to high, P3 to medium), fill blank subjects with the first 60 characters of column C, then create an Intercom ticket for each row using email/subject/description/priority, and write the ticket ID or error status to column E.
One prompt — all the cleanup and all the creation together.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet with a backlog of customer issues — ask it to create the Intercom tickets in one operation. For tracking those tickets after they are created, see the spoke on exporting the ticket backlog and the Intercom hub overview.