The Scenario
Every quarter you run a revenue reconciliation. The deliverable is simple: the Q4 Revenue dataset in Databox gets replaced with fresh, audited data pulled from the finance sheet. The board dashboard reflects the final numbers. Nothing carries over from Q3.
The process is not simple. The old dataset has to be deleted first — Databox doesn't support in-place replacement for custom datasets. Then a new one has to be created with the same primary key structure. Then 300 rows from the Q4Revenue sheet have to be pushed in, formatted exactly the way Databox expects, with deal_id as the primary key.
You've done this before. It took an hour and a half last quarter because the delete step in the Databox UI requires you to navigate three levels deep into Data Manager, the recreate step requires you to manually re-enter the schema fields, and the push step requires either the API or a manual import — both of which have their own formatting requirements.
The bad version:
- Navigate to Databox Data Manager, find the 'Q3 Revenue' dataset, confirm the delete through two confirmation dialogs.
- Manually re-enter the schema for the new 'Q4 Revenue' dataset — field by field, including the primary key, data types, and display names.
- Export the Q4Revenue sheet as a CSV, clean out any Excel formatting artifacts (currency symbols, comma-separated thousands), and attempt the import.
- Discover that 12 rows have deal_ids that contain a leading apostrophe from a Google Sheets formatting quirk, which makes them unique strings instead of integers, and the push rejects them.
Quarter-end has enough moving parts without this.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the Q4Revenue sheet, deletes the old Databox dataset, recreates it with the correct schema, and pushes all 300 rows — including stripping any formatting quirks that would fail the validator.
Open the SheetXAI sidebar and paste this:
Delete the existing dataset named 'Q3 Revenue' from my Databox account, create a new dataset 'Q4 Revenue' with primary key 'deal_id', then push all rows from the Q4Revenue sheet to it — strip any leading apostrophes or text formatting from the deal_id column first.
SheetXAI confirms the delete, creates the new dataset with deal_id as the primary key, cleans the deal_id column, and pushes all 300 rows as a batch. Row-level status is written back to column G of the Q4Revenue sheet.
What You Get
- Confirmation that the old 'Q3 Revenue' dataset was deleted, including its dataset ID.
- A new 'Q4 Revenue' dataset created with deal_id as the primary key, confirmed with the new dataset ID.
- All 300 rows pushed, with a success count in the sidebar and any skipped rows logged with reasons.
- The deal_id column cleaned of leading apostrophes before the push — no silent type mismatches.
What If the Data Is Not Quite Ready
The Q4 sheet has rows marked "draft" that shouldn't go to Databox yet
Preliminary deals that haven't closed. They're in the sheet but not in the reconciliation.
Delete the Databox dataset named 'Q3 Revenue', create a new dataset 'Q4 Revenue' with primary key 'deal_id', filter the Q4Revenue sheet to only rows where column F (status) equals 'closed', then push the filtered rows to the new dataset.
The revenue column uses mixed currency symbols from different regional teams
Some rows have "$" amounts, others are "€" with European decimal formatting.
In the Q4Revenue sheet, normalize the revenue column (column D) by stripping currency symbols and converting European decimal formatting (period as thousands separator, comma as decimal) to standard US format, then delete Databox dataset 'Q3 Revenue', create 'Q4 Revenue' with primary key 'deal_id', and push all 300 rows.
The Q4 data lives in two tabs — one for enterprise deals, one for SMB
Both need to land in the same Databox dataset.
Join the EnterpriseQ4 tab and SMBQ4 tab on deal_id, write the merged result to a ReconciliationFinal tab, then delete Databox dataset 'Q3 Revenue', create 'Q4 Revenue' with primary key 'deal_id', and push all merged rows from ReconciliationFinal.
You want to archive Q3 before deleting it — create a backup dataset first
Finance policy requires a snapshot before any delete.
Create a new Databox dataset called 'Q3 Revenue — Archived' under the same data source, push all current rows from the Q3Revenue sheet to it as a backup, then delete the original 'Q3 Revenue' dataset, create 'Q4 Revenue' with primary key 'deal_id', and push all rows from the Q4Revenue sheet.
One prompt handles the archive, the delete, the recreate, and the refresh — so the audit trail exists and the dashboard is current.
Try It
Get the 7-day free trial of SheetXAI and open your quarter-end revenue sheet, then ask it to handle the delete-and-repopulate cycle against your Databox account. You can also see how to initialize a Databox data source from a spreadsheet schema or view the full Databox integration overview.