The Scenario
You are a Square merchant who just received a batch of chargeback notices. You have 8 open disputes in your Square account. Each one has a response deadline. Miss the deadline and the dispute is automatically decided against you.
You need a Google Sheet with every open dispute — ID, amount, state, reason, and evidence due date — so you can prioritize responses and make sure nothing slips through before the deadlines hit.
The manual version:
- Log into Square's Dashboard
- Go to the Disputes section
- Read the first dispute: ID, amount, state, reason, due date
- Switch to your sheet, type it in
- Go back, read the second dispute
- Eight disputes. Eight round trips. One mistake and you miss a deadline.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet that queries all open Square disputes and writes every detail to the sheet, sorted by the deadline that is closest.
Open the SheetXAI sidebar and type:
List all open Square disputes and write each dispute's ID, amount, currency, state, reason, and evidence-due date into this sheet. Sort by evidence-due date ascending so the most urgent disputes are at the top.
SheetXAI calls Square's disputes endpoint, filters to open disputes, and writes every record to the sheet sorted by due date. The one you need to respond to first is at the top.
What You Get
A dispute tracker with every open case:
- Dispute ID — the Square reference for responding via the dashboard or API
- Amount — the disputed amount
- Currency — ISO code
- State — EVIDENCE_REQUIRED, PROCESSING, WAITING_THIRD_PARTY, etc.
- Reason — the cardholder's stated reason for the dispute (CUSTOMER_REQUESTS_CANCEL, NO_KNOWLEDGE, etc.)
- Evidence-due date — sorted ascending so the most urgent case is first
Nothing falls through. SheetXAI retrieves all open disputes — not just the ones visible on one screen of the Square dashboard — and puts them in deadline order.
Once the tracker is in the sheet, you can add a "Response submitted" column and work through each case systematically.
What If the Data Is Not Quite Ready
Dispute trackers have real-world complications. SheetXAI handles them in the same prompt.
When you want to flag disputes by urgency
The due dates are there, but you want a clear "days remaining" column for triage.
List all open Square disputes. Write dispute ID, amount, state, reason, and evidence-due date into this sheet. Add a column called "Days Remaining" showing how many days remain until the evidence deadline. Sort by Days Remaining ascending.
When you also want to flag disputes by reason type
Some reasons (like fraud) require different evidence than others (like item not received). You want the reason categorized.
List all open Square disputes. Write ID, amount, state, reason, evidence-due date, and days remaining into this sheet. In a "Category" column, write "Fraud" for NO_KNOWLEDGE and CUSTOMER_NOT_PRESENT reasons, "Service" for CUSTOMER_REQUESTS_CANCEL and CUSTOMER_DISSATISFIED, and "Other" for everything else.
When you want only disputes above a certain threshold
You have 15 open disputes but only want to prioritize the ones above $100.
List all open Square disputes where the disputed amount is $100 or more. Write ID, amount, state, reason, and evidence-due date into this sheet. Sort by amount descending.
When you need to pull disputes, assess urgency, and generate a response action plan in one shot
Your team needs not just the list but a clear next-action column so they know who should respond to what.
List all open Square disputes. Write ID, amount, state, reason, evidence-due date, and days remaining into this sheet. Add an "Action" column: write "Respond today" if 3 days or fewer remain, "Respond this week" if 4 to 7 days remain, "Monitor" if more than 7 days remain. Sort by Days Remaining ascending.
The pattern: the dispute list is most useful when it tells your team exactly what to do next, not just what exists.
Try It
Get the 7-day free trial of SheetXAI and pull your open Square disputes into a tracker before the next deadline. The Square integration is included in every SheetXAI plan. For related workflows, see how to export Square payment history for reconciliation or the Square in Google Sheets overview.