WordPress Auto-Content Scheduler
Automatically parse spreadsheet uploads (Excel/CSV) and sequential ZIP images to schedule articles with complete Yoast SEO Pro support and featured image sideloading.
by Ronaldo Nazeer · github.com/ronaldonasr23-glitch/articles-bulk-share-wordpress-plugin- · website
Install
No release zip yet. The repository archive installs, but the folder name will carry the branch suffix and updates will not flow:
wp plugin install https://github.com/ronaldonasr23-glitch/articles-bulk-share-wordpress-plugin-/archive/refs/heads/main.zipReadme
WordPress Auto-Content Scheduler
A modern, high-fidelity WordPress plugin to bulk upload spreadsheets (Excel/CSV) and sequentially-numbered ZIP archives of images to dynamically schedule articles. Built with full Yoast SEO Pro metadata integrations, Generative Engine Optimization (GEO) summary cards, and multi-language support.
Author: Ronaldo Nazeer
Repository: https://github.com/ronaldonasr23-glitch/Articles-bulk-Share-wordpress-plugin-.git
Key Features
- Bulk Spreadsheet Upload: Parse
.xlsxand.csvarticles using a robust spreadsheet reader (PhpSpreadsheet). - Sequential Image Sideloading: Recursively matches and extracts sequentially-numbered images (e.g.
1.jpg,02.png) inside uploaded ZIP archives and sets them as featured images. - Asynchronous Batch Processor: sequential AJAX looper processing prevents script timeout issues on large uploads.
- Interactive Progress Bars: Live client-to-server upload percentage trackers and scheduling indicators.
- Yoast SEO Pro Integrations: Writes focus keywords, meta descriptions, OpenGraph parameters, Twitter cards, and keyphrase synonyms (
_yoast_wpseo_focuskw_synonyms) directly to the database. - Instant Traffic-Light Scores (Green Dots): Backend evaluation engine calculates and assigns SEO (
_yoast_wpseo_linkdex) and Readability (_yoast_wpseo_content_score) scores to display green dots inside the WordPress Admin Columns immediately. - Generative Engine Optimization (GEO): Prepends styled "AI Summary & Key Takeaways" boxes optimized for Google SGE, Gemini, and ChatGPT citation crawlers.
- Dynamic Translation & Multi-Language Support:
- Automatically detects active translation networks from Polylang, WPML, and TranslatePress.
- Programmatically registers scheduled posts under selected languages (
pll_set_post_languageandwpml_set_element_language_detailshooks). - Smoothly falls back to the native site locale for standard websites.
Directory Structure
articles-share-scheduler/
├── articles-share-scheduler.php # Main entry & bootloader
├── composer.json # Dependencies
├── composer.lock # Dependency lock file
├── README.md # Documentation
├── assets/
│ ├── css/
│ │ └── admin-style.css # Premium glassmorphic dark stylesheet
│ ├── js/
│ │ └── admin-script.js # Ajax batch and drag-and-drop controller
│ └── templates/
│ └── articles-template.csv # Downloadable sample template
├── includes/
│ ├── class-articles-scheduler.php # Core logic and endpoints
│ └── class-articles-scheduler-admin.php # Admin dashboard structure
└── vendor/ # Autoloaded dependencies
Spreadsheet Template Columns
| Column | Header | Description | Example |
|---|---|---|---|
| A | Title | The article's main heading | My Content Strategy Guide |
| B | Content | Typographic body copy (HTML tags like <h1>, <p> supported) |
<h1>Intro</h1><p>Body copy...</p> |
| C | Focus_Keyword | Primary target search keyword for Yoast | content strategy |
| D | Meta_Description | Custom snippet for search engine previews | A comprehensive guide on content strategy... |
| E | Keyphrase_Synonyms | Comma-separated alternative keyphrases (Yoast Premium) | writing guide, blogging tips |
| F | AI_Summary | Bulleted takeaways ensembling SGE/AI citation points | - Key bullet points help AI engines parse... |
| G | Schema_Type | Structured Schema markup type for indexers | TechArticle or FAQPage |
Note: A downloadable template (articles-template.csv) is enqueued directly inside the dashboard settings.
ZIP Images Mapping
Images inside the ZIP archive must be named sequentially corresponding to the row numbers of the spreadsheet (excluding headers).
- Row 2 (Article 1) matches image
1.jpg(or1.png,01.jpg, etc.) - Row 3 (Article 2) matches image
2.jpg - The matching engine supports all standard extensions (
.jpg,.jpeg,.png,.gif,.webp) and checks recursively even if directories are nested inside the ZIP.
Installation & Setup
- Clone or download this repository:
git clone https://github.com/ronaldonasr23-glitch/Articles-bulk-Share-wordpress-plugin-.git - Place the folder inside your WordPress plugins directory:
wp-content/plugins/. - Run Composer inside the folder to install dependencies:
composer install --ignore-platform-reqs --optimize-autoloader - Log into your WordPress admin panel, go to Plugins, and click Activate under WordPress Auto-Content Scheduler.
- Navigate to the new Content Scheduler menu on the left to begin scheduling content.