Manual JSON Import

Back to Scraper View Collected Cards

How to Use Manual JSON Import

  1. Select an issuer from the dropdown below
  2. Review database status - see how many cards already exist
  3. Copy the generated prompt - includes exclusion list
  4. Paste into AI tool - ChatGPT, Claude, or Google Gemini
  5. Copy JSON response from the AI
  6. Paste JSON into the textarea below
  7. Click "Import Cards" to save to database

Works with any AI that has web access

Step 1: Select Issuer
18
In Database
Database Status for American Express

18 cards already in database. The prompt below includes these cards in the exclusion list to avoid duplicates.

View Existing Cards
Step 2: Copy This Prompt 18 cards excluded 
Act as a data extraction specialist. Extract ALL available "Personal Credit Cards" from American Express (USA).

[IMPORTANT RULES]
- Extract ALL personal credit cards available on the website
- If there are no NEW cards (all cards already in database), return an empty array []
- Do NOT repeat cards from the exclusion list below
- Only include cards that are currently available and active in 2026


[CARDS ALREADY IN DATABASE - DO NOT INCLUDE THESE]
The following 18 cards are already saved in the database:
- Blue Cash Everyday® Card from American Express (ID: blue-cash-everyday)
- Blue Cash Preferred® Card from American Express (ID: blue-cash-preferred)
- The Platinum Card® from American Express (ID: platinum-card)
- American Express® Gold Card (ID: gold-card)
- Green Card from American Express (ID: green-card)
- Delta SkyMiles® Gold American Express Card (ID: delta-skymiles-gold)
- Delta SkyMiles® Platinum American Express Card (ID: delta-skymiles-platinum)
- Delta SkyMiles® Reserve American Express Card (ID: delta-skymiles-reserve)
- Hilton Honors American Express Card (ID: hilton-honors)
- Hilton Honors American Express Surpass® Card (ID: hilton-honors-surpass)
- Hilton Honors Aspire Card from American Express (ID: hilton-honors-aspire)
- Marriott Bonvoy Bevy™ American Express® Card (ID: marriott-bonvoy-bevy)
- Marriott Bonvoy Brilliant® American Express® Card (ID: marriott-bonvoy-brilliant)
- The Amex EveryDay® Preferred Credit Card from American Express (ID: amex-everyday-preferred)
- The Amex EveryDay® Credit Card from American Express (ID: amex-everyday)
- The American Express® Cash Magnet® Card (ID: cash-magnet)
- Charles Schwab Investor Card from American Express (ID: charles-schwab-investor-card)
- Morgan Stanley Credit Card from American Express (ID: morgan-stanley-credit-card)

IMPORTANT: Only return cards that are NOT in the above list!


[TARGET WEBSITE]
https://www.americanexpress.com/us/credit-cards/

[OUTPUT FORMAT]
Return a JSON array of objects. Each object must follow this exact schema:
{
  "CardName": (string, full official name of the card),
  "CardId": (string, unique URL-friendly slug like "blue-cash-preferred"),
  "Issuer": "American Express",
  "ApplyNowUrl": (string, direct application link starting with https://),
  "PricingUrl": (string, terms/rates/disclosure page link starting with https://)
}

[INSTRUCTIONS]
1. Use absolute URLs (must start with https://)
2. Make CardId lowercase with hyphens, no spaces or special characters
3. If PricingUrl not found, use the card's main detail page URL
4. Return ONLY the JSON array, no markdown code blocks, no explanations
5. Do NOT include business credit cards

Return ONLY the JSON array.
This prompt includes a list of cards already in your database to avoid duplicates. Paste this into ChatGPT, Claude, Google Gemini, or any AI tool that has web access.
ChatGPT Claude Gemini Any AI
Step 3: Paste JSON Response
Paste the JSON array response from the AI. You can paste with or without markdown code fences (```json). The textarea will auto-format your JSON when you paste it.
Waiting for JSON input...
Example JSON Format

This is what the AI should return. Each card object must have these 5 fields: 

[
  {
    "CardName": "Delta SkyMiles® Blue American Express Card",
    "CardId": "delta-skymiles-blue",
    "Issuer": "American Express",
    "ApplyNowUrl": "https://www.americanexpress.com/us/credit-cards/card/delta-skymiles-blue-american-express-card/",
    "PricingUrl": "https://www.americanexpress.com/us/credit-cards/card/delta-skymiles-blue-american-express-card/"
  },
  {
    "CardName": "Hilton Honors American Express Aspire Card",
    "CardId": "hilton-honors-aspire-card",
    "Issuer": "American Express",
    "ApplyNowUrl": "https://www.americanexpress.com/us/credit-cards/card/hilton-honors-aspire/",
    "PricingUrl": "https://www.americanexpress.com/us/credit-cards/card/hilton-honors-aspire/"
  },
  {
    "CardName": "The Platinum Card® for Goldman Sachs",
    "CardId": "platinum-card-goldman-sachs",
    "Issuer": "American Express",
    "ApplyNowUrl": "https://www.americanexpress.com/us/credit-cards/card/platinum-card-goldman-sachs/",
    "PricingUrl": "https://www.americanexpress.com/us/credit-cards/card/platinum-card-goldman-sachs/"
  }
]
Tips & Tricks
Best Practices:
  • Use AI tools with web access (ChatGPT Plus, Claude Pro, Gemini Advanced)
  • Copy the ENTIRE prompt including exclusion list
  • Ask AI to "verify the URLs are correct" if uncertain
  • You can manually edit the JSON before importing
  • Duplicates are automatically skipped
Common Issues:
  • AI returns incomplete data: Re-run the prompt
  • JSON parsing error: Check for missing commas or quotes
  • Duplicate cards: They'll be automatically skipped
  • Invalid URLs: Make sure they start with https://
  • CardId format: Must be lowercase-with-hyphens