<aside>
💬 For workflow setup or customization, contact [email protected] or visit paoloronco.it.
</aside>
Workflow resources
<aside>
📦
Gumroad →
Template files.
</aside>
<aside>
💻
GitHub →
Source files.
</aside>
Quick overview
This workflow converts recent WordPress posts into multilingual voiceovers using Google Cloud Text-to-Speech and Google Translate, managing job status and audio publishing through a Google Sheets queue.
How it works
- Triggered daily at 22:00 or manually to start the workflow.
- Load configuration settings including languages, Google Sheets IDs, and Cloud Run URLs.
- Fetch WordPress posts published within the configured lookback period.
- Extract readable text and generate a content fingerprint for each post.
- Read the current processing queue from Google Sheets.
- Compare posts with the queue to identify new, changed, or failed jobs and update the queue accordingly.
- Select pending and retryable jobs from the queue, respecting concurrency limits.
- Acquire a run lock in the queue to prevent concurrent executions.
- Loop over selected jobs, marking each as processing.
- Fetch the current full article content for each job.
- Build the speech text, generate deterministic audio filenames, and check if audio already exists.
- If audio exists, skip generation; otherwise, translate text if needed and send TTS requests to the Cloud Run service.
- Verify the generated audio file's existence and size.
- Read the WordPress language page to update.