Spaces:
Running
Running
- 1.52 kB initial commit
- 220 Bytes Help me build a web-based outreach automation tool for the Missionary Bridges Conference, taking place in Paris in October. The goal of the app is to identify and contact non-Catholic Christian or Evangelical churches across Europe (starting with France) to invite their leaders to the conference. Project Overview Build an app that does the following: Step 1: Church Discovery & Data Collection Create a script or module that: • Finds Christian/Evangelical (non-Catholic) churches in France and Europe via: o Public church directories (e.g., Evangelical Alliance listings, OpenChurch APIs, Google Maps APIs, or scrapers like Apify). • For each church, collect: o Church Name o Email address o Phone number o Website o Social media links o Contact person (pastor or leader) • Avoid Catholic churches in your filtering logic. Deliverable: A script or component that returns structured JSON or directly stores into a database. Step 2: Data Storage with Prisma • Set up a PostgreSQL database (or similar). • Define a schema in Prisma for: • model Church { • id String @id @default(cuid()) • name String • email String? • phone String? • website String? • facebook String? • instagram String? • contactName String? • country String • createdAt DateTime @default(now()) • } • Include logic to validate and prevent duplicates. Step 3: Email + WhatsApp/SMS Campaign • Build a backend module to: o Send personalized emails using an email API (e.g., SendGrid or Nodemailer). o Optional: Add multilingual email support (English + French). o Fallback options: WhatsApp messages via WhatsApp Business API SMS messages via Twilio or similar • Add a sample outreach message like: • Subject: Invitation to Missionary Bridges 2025 – Join Us in Paris • Body: Dear [Church Leader Name], we invite you to our upcoming international gathering of evangelical leaders this October in Paris... Step 4: Message Logging + Tracking • Track every message sent (email, SMS, WhatsApp) in a database. • Include status flags like: SENT, OPENED, FAILED, REPLIED. • Optionally integrate with email analytics (SendGrid stats, etc.). Step 5 : Dashboard • Add a dashboard (Next.js or React) to view church contacts, message status, and communication logs. • Use cron jobs or queues (e.g., Bull or Agenda) to space out bulk message sending. Output Requirements When writing code, return: • File structure • Code snippets (split logically: scraping, DB models, API, frontend) • Sample .env setup for environment variables • CLI or admin interface to manually trigger outreach steps Final Goal A deployable full-stack outreach platform that helps identify, manage, and contact non-Catholic Christian churches across Europe to invite them to the Missionary Bridges Conference in October. - Initial Deployment
- 37.2 kB Its looking good! please continue adding more funtionality to the app - Follow Up Deployment
- 388 Bytes initial commit