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 Google Sheet.
- 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 Google Sheet. It reads your sheet, understands the structure, and through its built-in ASIN Data API integration it can list all configured destinations and write them into your sheet without any dashboard clicking.
Here's the prompt for this task:
List all ASIN Data API destinations and write destination name, type (S3, GCS, etc.), enabled status, bucket/path, and creation date into this sheet starting at row 2, one row per destination.
What You Get
- Column A: Destination name as configured in ASIN Data API
- Column B: Storage type — S3, GCS, or other
- Column C: Enabled status — true or false
- Column D: Bucket name and path
- Column E: Creation date
- Every destination pulled in one pass, with nothing transcribed by hand
What If the Data Is Not Quite Ready
You want disabled destinations flagged immediately
Pull all ASIN Data API destinations into this sheet — columns: name, type, enabled, bucket, created. Then mark column F "DISABLED" for any row where column C is false, leave it blank for enabled destinations.
You want to cross-check against a list of approved buckets
List all ASIN Data API destinations into columns A (name), B (type), C (enabled), D (bucket), E (created). Then check column D against the approved bucket names in column H. Write "approved" or "unknown" in column F for each row.
You want a count of destinations by storage type
Pull all ASIN Data API destinations into columns A–E (name, type, enabled, bucket, created). Then in column G, write a summary: count of S3 destinations, count of GCS destinations, count of other types — one label and count per row.
Full audit with stale detection and summary in one shot
Pull all ASIN Data API destinations into columns A (name), B (type), C (enabled), D (bucket), E (created). Mark column F "stale" for any destination that is disabled AND was created before 2024-01-01. Mark F "review" for disabled destinations created after that date. Leave F blank for enabled destinations. Write a count of stale, review, and active destinations in H1:H3.
The pattern: pull, flag, and summarize in one prompt — no separate passes for each step.
Try It
Get the 7-day free trial of SheetXAI and open a Google Sheet, ask it to list all your ASIN Data API destinations and flag the disabled ones. For auditing request-level data from your collections, see Audit ASIN Data API Collection Requests in a Google Sheet — and the full ASIN Data API overview has the complete picture.