The Scenario
The data engineering lead who set up your ASIN Data API destinations left the company three months ago. You've inherited a Notion doc that lists ten delivery targets — but when you log into the dashboard, you count thirty. Some have names like "test-s3-backup-v3." At least two point to a GCS bucket that no longer exists. You need a clean inventory before your team adds any new destinations, because nobody can agree on which ones are actually live and which are orphans from a project that shipped two years ago.
The bad version:
- Click through the ASIN Data API destinations list one by one, reading off destination names, types, and enabled statuses while copying each into a fresh Excel worksheet.
- For each destination, click into the detail view to get the bucket name and path, then navigate back to the list and find your place again.
- Repeat 30 times, hoping the page doesn't reload and lose your scroll position, then manually add a column flagging which ones look stale based on naming conventions you're guessing at.
Nobody hired you to be a dashboard transcription service. The audit needs to go to the team lead by end of week, and you have two other projects running at the same time.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads your worksheets, understands the structure, and through its built-in ASIN Data API integration it can list all configured destinations and write them into your workbook without any dashboard clicking.
Here's the prompt for this task:
Pull all ASIN Data API destinations into the Excel 'DestinationAudit' sheet with columns: name, enabled, storage type, bucket, and last updated. Mark disabled destinations in column F.
What You Get
- Column A: Destination name as configured in ASIN Data API
- Column B: Enabled status — true or false
- Column C: Storage type — S3, GCS, or other
- Column D: Bucket name and path
- Column E: Last updated timestamp
- Column F: "DISABLED" label for any destination where enabled is false, blank otherwise
What If the Data Is Not Quite Ready
You want a stale-detection flag based on creation date
Pull all ASIN Data API destinations into the DestinationAudit sheet — columns: name, type, enabled, bucket, created. In column F, write "stale" for any destination that is disabled AND was created before 2024-01-01. Leave column F blank for enabled destinations.
You want to cross-reference against an approved bucket list
List all ASIN Data API destinations into columns A (name), B (type), C (enabled), D (bucket), E (created) in the DestinationAudit sheet. Check column D against the approved bucket names in the ApprovedBuckets sheet column A. Write "approved" or "unknown" in column F.
You want a type breakdown alongside the raw list
Pull all ASIN Data API destinations into the DestinationAudit sheet, columns A–E (name, type, enabled, bucket, created). Then write a summary in column H: count of S3, GCS, and other destination types, one label and count per row.
Full audit with categorization and executive summary in one shot
Pull all ASIN Data API destinations into DestinationAudit columns A (name), B (type), C (enabled), D (bucket), E (created). Categorize each in column F: "active" if enabled is true, "stale" if disabled and created before 2024-01-01, "review" if disabled and created after. Write a count of active, stale, and review destinations in H1:H3 with labels in G1:G3.
The pattern: pull, categorize, and summarize in one prompt — you don't stage those as three separate operations.
Try It
Get the 7-day free trial of SheetXAI and open an Excel workbook, then ask it to list all your ASIN Data API destinations and flag the disabled ones for review. For request-level collection auditing, see Audit ASIN Data API Collection Requests in an Excel workbook — and the full ASIN Data API overview covers all four connection methods.