Local Coffee Scout
Generator
Schema
Schema Manager
Define the columns and data-generation prompts for your output file. Changes are saved to your project's database.
Order
Active
Copywriter
Column Name
Generation Prompt
Output the business name of the coffee place. No other text.
Create a slug for the URL. Use the business name and the city. Use hyphens instead of spaces. e.g. 'ten-belles-paris'
Based on the full description in {{Spot - About The Spot}}, create a very short, punchy excerpt about the place. Use a maximum of 75 characters, strictly. Output only a single, plain-text sentence. Focus on the unique character of the coffee spot.
Based on the full description in {{Spot - About The Spot}}, create a compelling excerpt about the place. Use a maximum of 130 characters, strictly. Output only a single, plain-text sentence. Focus on the unique character of the coffee spot.
Based on the full description in {{Spot - About The Spot}}, create a concise summary of the place. Use a maximum of 200 characters, strictly. Output only a single, plain-text paragraph. Focus on the unique character of the coffee spot.
Output 'Visit Website'. No other text.
Output 'FALSE'.
Generate a ~175-word description of this specialty coffee place in HTML format. It must include an <h2> headline and subsequent <p> tags. Focus on the unique soul, vibe, and character. Mention any relevant coffee awards, certifications, or fame. Describe their coffee portfolio (blends, origins, methods), any award-winning coffees, key offerings (like food/pastries), and house specialties. Introduce the founders if they are prominent in the specialty coffee scene. The tone should be engaging and expert, suitable for a coffee blog.
Based on Google Maps and other review sites, provide an estimated average rating out of 5. Output a single number, e.g., '4.6'.
Categorize the spot. Is it primarily a 'Cafe', a 'Roastery', or both ('Roastery & Cafe')? Output either ‘coffee-roasters’ or ‘specialty-coffee-shops’.
Output the city name. Research the Number one Keyword I should rank for in the specialty coffee area. It should be the perfect balance between volume and keyword difficulty.
Output the Google Maps link for the location.
Output the full URL of the coffee shop's official website. If none, leave blank.
Output the full URL of the coffee shop's official Instagram profile. If none, leave blank.
Describe the character of the shop in 3-4 keywords. e.g., 'Minimalist, Bright, Focused, Tranquil' or 'Cozy, Rustic, Classic, Lively'. Feel free to reference from Spot - About the Spot.
Output the business phone number in international format. e.g., '+33 1 42 40 90 78'.
Output the full street address of the coffee shop. e.g., ‘43 High Street, Auckland Central, Auckland 1010’
Output the primary contact email for the coffee shop. If none, leave blank.
Output the typical opening hours for Monday-Friday in the format 'HH:MM - HH:MM'. E.g. ‘Mon - Fri: 7:00 AM - 3:00 PM’.
Output the opening hours for Saturday in the format 'HH:MM - HH:MM'. E.g. ‘Saturday: 8:00 AM - 3:00 PM’. If closed, output 'Closed'.
Output the opening hours for Sunday in the format 'HH:MM - HH:MM'. E.g. ‘Sunday: 8:00 AM - 3:00 PM’. If closed, output 'Closed'.
Does the spot roast its own coffee beans on-site or at their own facility? Output 'TRUE' or 'FALSE'.
Is there mention of ethical sourcing, direct trade, or close relationships with coffee producers on their website or materials? Output 'TRUE' or 'FALSE'.
Do they explicitly offer single-origin coffees on their menu? Output 'TRUE' or 'FALSE'.
Is there any mention of the shop or its baristas winning any coffee-related awards (e.g., Brewer's Cup, Latte Art)? Output 'TRUE' or 'FALSE'.
Do they feature rare micro-lots, competition lots, or frequently rotating seasonal beans? Output 'TRUE' or 'FALSE'.
Do they offer coffees with experimental processing methods like anaerobic, carbonic maceration, etc.? Output 'TRUE' or 'FALSE'.
Do they offer manual brewing methods like V60, Chemex, AeroPress, etc.? Output 'TRUE' or 'FALSE'.
Do they offer batch-brewed filter coffee? Output 'TRUE' or 'FALSE'.
Do they serve a standard menu of espresso-based drinks (espresso, latte, cappuccino, flat white)? Output 'TRUE' or 'FALSE'.
Do they offer a decaffeinated coffee option? Output 'TRUE' or 'FALSE'.
Do they offer oat milk or other plant-based alternatives? Output 'TRUE' or 'FALSE'.
Do they offer Cold Brew or Cold Drip coffee? Output 'TRUE' or 'FALSE'.
Does the shop offer public coffee classes, workshops, or tastings? Output 'TRUE' or 'FALSE'.
Can you buy bags of coffee beans at the physical location? Output 'TRUE' or 'FALSE'.
Do they have an online shop to buy their coffee beans? Output 'TRUE' or 'FALSE'.
Do they sell pastries, cakes, or other snacks? Output 'TRUE' or 'FALSE'.
Do they offer a substantial food menu beyond snacks, like brunch or lunch? Output 'TRUE' or 'FALSE'.
Is the environment suitable for working on a laptop? (e.g., has WiFi, adequate seating, allows laptops). Output 'TRUE' or 'FALSE'.
Does the coffee shop have outdoor seating available? Output 'TRUE' or 'FALSE'.
Are pets, particularly dogs, welcome inside or in the outdoor area? Output 'TRUE' or 'FALSE'.
Is there any mention of staff having professional certifications like Q-Grader or SCA diplomas? Output 'TRUE' or 'FALSE'.
If they sell beans online, do they offer international shipping? Output 'TRUE' or 'FALSE'.
Do they offer a recurring coffee bean subscription service? Output 'TRUE' or 'FALSE'.
Can you order coffee for takeaway? Output 'TRUE' or 'FALSE'.
Do they offer a discount for bringing your own cup, or have a loyalty program? Output 'TRUE' or 'FALSE'.
Does the shop host community events, throwdowns, or other coffee-related gatherings? Output 'TRUE' or 'FALSE'.
Summarize the full week's opening hours in a single text block. e.g., 'Mon-Fri: 08:30-17:00, Sat: 09:00-18:00, Sun: Closed'.
Save Schema