behr-construction-ai-data

Behr Construction AI Data

A comprehensive repository for creating AI-optimized data systems with automated workflows, structured data generation, and multi-platform content distribution.

🚀 Quick Start

1. Copy this template to create a new repository for your client
2. Update client data in templates/client-data.xlsx
3. Configure GitHub Actions secrets (see Configuration)
4. Push changes to trigger automated workflows

📁 Repository Structure

├── .github/workflows/          # GitHub Actions workflows
│   ├── auto-ping-sitemap.yml       # Automated search engine ping upon new files submitted or updated workflow
│   └── generate-from-xlsx.yml  # Main processing workflow when client-data.xlsx is updated or submitted
|   └── auto-refresh.yml        # auto refreshes if sitemap hasn't been updated/updates and pings search engines every 28 days
├── docs/                      # Documentation
│   ├── comprehensive_readme.md
│   ├── configuration_templates.md
│   ├── deployment_instructions.md
│   ├── documentation_summary.md
│   ├── google_sheets_setup_guide.md
│   ├── testing_guide.md
│   └── troubleshooting_guide.md
├── templates/                 # Template files
│   ├── client-data.xlsx      # Main client data template
├── ai-content/               # Generated AI content
├── schemas/                  # JSON-LD schemas
├── generate_files_xlsx.py    # Enhanced file generation script
├── generate_sitemaps.py      # Sitemap generation script
├── requirements.txt          # Python dependencies
└── robots.txt                # Robot file directives to search engines

🔧 Configuration

Required GitHub Secrets

Set these in your repository settings under Settings > Secrets and variables > Actions:

• GH_TOKEN - Automatically provided by GitHub

Client Data Setup

1. Excel Method (Recommended):
   • Edit templates/client-data.xlsx
   • Use multiple sheets for different data types
   • Manual upload to templates folder with data or updates to trigger workflows

🤖 AI Features

• Structured Data Generation: Automatic JSON-LD schema creation
• LLM Training Files: Optimized content for AI crawlers
• FAQ Generation: Automated FAQ schema and content
• Sitemap Management: Dynamic sitemap generation and submission
• Multi-format Output: JSON, YAML, Markdown, and LLM formats

📊 Supported Data Types

• Organization information
• Services and products
• Locations and contact details
• FAQs and testimonials
• Licensing and certifications
• Custom schemas

🔄 Automated Workflows

Main Workflow (generate-from-xlsx.yml)

• Triggers on Excel file changes
• Generates all output formats
• Creates sitemaps

Auto-ping Workflow (auto-ping-sitemap.yml)

• Notifies search engines
• Maintains search engine visibility

📚 Documentation

Comprehensive guides are available in the docs/ directory:

• Deployment Instructions - Step-by-step setup
• Google Sheets Setup - Integration guide
• Testing Guide - Quality assurance
• Troubleshooting - Common issues
• Configuration Templates - Advanced setup

🛠️ Development

Local Setup

# Clone the repository
git clone https://github.com/DFYRANKINGS/client-ai-data-template.git
cd client-ai-data-template

# Install dependencies
pip install -r requirements.txt

# Run file generation
python generate_files_xlsx.py

# Generate sitemaps
python generate_sitemaps.py

Testing

# Run comprehensive tests
python -m pytest tests/

# Validate generated schemas
python validate_schemas.py

🔍 SEO & AI Optimization

• Schema.org compliance for rich snippets
• AI crawler optimization with structured training data
• Multi-platform compatibility (Google, Bing, AI assistants)
• Automated sitemap management with search engine notifications
• Performance monitoring and optimization

📈 Analytics & Monitoring

• GitHub Actions workflow monitoring
• Schema validation reports
• Sitemap submission tracking
• Performance metrics

🤝 Contributing

1. Fork the repository
2. Create a feature branch
3. Make your changes
4. Test thoroughly
5. Submit a pull request

📄 License

This template is provided as-is for client projects. Customize as needed for your specific requirements.

🆘 Support

• Check the Troubleshooting Guide
• Review Documentation
• Create an issue for bugs or feature requests

---

Template Version: 2.0
Last Updated: September 2024
Maintained by: DFYRANKINGS