The Scenario
You are a CRM admin and you just got a message from the head of sales: "Did someone delete a batch of contacts last week? My outreach list is short by about 80 names." You check the Bigin audit log — it shows deletions but not which records. The recycle bin still has them, but only for 30 days, and it has already been a week.
You need a full list of recently deleted Bigin Contact records in a spreadsheet so you can figure out what happened, who deleted them, and whether any need to be restored.
The bad version:
- Navigate to the Bigin recycle bin, which shows records one page at a time — 20 per page.
- Note down the record name and deletion date for each one, switching between the bin view and your sheet, four pages of 20 records.
- Realize the recycle bin does not show the email address of deleted contacts — you would need to restore each one to check.
The recycle bin UI is designed for individual record recovery, not for batch audit. Getting 80 deleted records into a spreadsheet through the UI is not a realistic option.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It calls the Bigin API to retrieve recently deleted records and writes them into your sheet — all at once, with the fields you need for the audit.
Get all recently deleted records from the Bigin Contacts module and list them in this sheet with their ID, name, email, and deletion date
What You Get
- Every recently deleted Bigin Contact record written into your sheet, one per row, with ID, name, email, and deletion date.
- The deletion date lets you narrow down which records disappeared in the window the sales lead is asking about.
- The record IDs give you the reference you need if any records need to be restored through Bigin's recycle bin.
What If the Data Is Not Quite Ready
You want to filter the export to only show records deleted in a specific date range
Get all recently deleted Bigin Contacts deleted between 2026-05-07 and 2026-05-11. List each record's ID, name, email, company, and deletion date in this sheet.
You also want to know which user deleted each record
Export all recently deleted Bigin Contacts into this sheet — columns: Record ID, Full Name, Email, Company, Deletion Date, Deleted By (user name). Sort by Deletion Date descending.
You want to cross-reference the deleted records against an active outreach sheet
Get all recently deleted Bigin Contacts and write their ID, name, and email into this sheet. Then, for each email, check whether it also appears in the "Outreach" tab in column B — if it does, write "ON OUTREACH LIST" in column D.
Full audit export with cross-reference in one shot
Export all recently deleted Bigin Contacts deleted in the last 14 days — columns: Record ID, Full Name, Email, Company, Deletion Date, Deleted By. Sort by Deletion Date descending. For each email, check whether it appears in the "Outreach" tab column B and write "ON LIST" or "NOT ON LIST" in column G.
One prompt gives you the full deletion audit ready for the sales lead conversation.
Try It
Get the 7-day free trial of SheetXAI and open a blank Google Sheet, then ask SheetXAI to export all recently deleted Bigin Contacts for audit. To prevent future accidental deletions, see the spoke on bulk-deleting records with a safety check.