The Scenario
It is the third week of July. Your finance analyst needs to reconcile this quarter's Nutshell quotes and invoices against the accounting system — 60-odd records, each with a linked lead, an amount, a status, and a date. The source of truth is Nutshell. The reconciliation happens in a Google Sheet. Getting the two connected is, as usual, not a built-in feature.
The bad version:
- You navigate to Nutshell's quotes section, set the date filter for Q2, and export a CSV.
- The CSV has 18 columns, three of which you need. You delete the others and reformat the dates.
- You do the same for invoices, get a second CSV, and now you're merging two exports in a sheet while the finance analyst pings you asking for an ETA.
The reconciliation is straightforward. The data collection is what keeps getting in the way.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the sheet and, through its built-in Nutshell integration, pulls quotes and invoice data directly — no CSV export, no column pruning, no reformatting.
Open SheetXAI in the sidebar and ask:
List all Nutshell quotes from this quarter and write quote ID, linked lead description, amount, status, and creation date into columns A through E of this sheet
What You Get
- One row per quote with quote ID, linked lead description, amount, status, and creation date in the columns you specified.
- Dates in ISO format, amounts as numeric values — ready for reconciliation formulas without reformatting.
- Row count written below the last data row so the analyst can confirm completeness.
- No extra columns, no merged cells, no formatting that breaks downstream lookups.
What If the Data Is Not Quite Ready
You need invoices alongside quotes in the same sheet
Fetch all Nutshell invoices from the current quarter and add them below the quotes in this sheet with invoice ID, linked lead, total amount, payment status, and issue date — add a Type column as column F marking each row as Quote or Invoice
You need to filter to a specific status
List all Nutshell quotes from this quarter where status is Accepted or Sent — write quote ID, linked lead description, amount, status, and creation date into columns A through E
The accounting system uses a different quarter definition
Fetch all Nutshell quotes where the creation date falls between April 1 and June 30, 2026 — write quote ID, linked lead, amount, status, and date into this sheet
Full reconciliation export in one shot
Fetch all Nutshell quotes and invoices created between April 1 and June 30, 2026 — write them into this sheet with a Type column, include quote/invoice ID, linked lead description, amount, status, and date — sort by creation date ascending and add a total-amount row at the bottom
When the finance team needs the reconciliation export ready before close, describe the full pull — the date range, the combined quote-and-invoice view, the totals row — in one prompt.
Try It
Get the 7-day free trial of SheetXAI and open your next reconciliation sheet — then ask it to pull the Nutshell quotes and invoices directly. You can also export the full open pipeline for a QBR, build a revenue forecast by close month, or pull a won/lost conversion report by rep using the same approach.