<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

  1. Triggered daily at 22:00 or manually to start the workflow.
  2. Load configuration settings including languages, Google Sheets IDs, and Cloud Run URLs.
  3. Fetch WordPress posts published within the configured lookback period.
  4. Extract readable text and generate a content fingerprint for each post.
  5. Read the current processing queue from Google Sheets.
  6. Compare posts with the queue to identify new, changed, or failed jobs and update the queue accordingly.
  7. Select pending and retryable jobs from the queue, respecting concurrency limits.
  8. Acquire a run lock in the queue to prevent concurrent executions.
  9. Loop over selected jobs, marking each as processing.
  10. Fetch the current full article content for each job.
  11. Build the speech text, generate deterministic audio filenames, and check if audio already exists.
  12. If audio exists, skip generation; otherwise, translate text if needed and send TTS requests to the Cloud Run service.
  13. Verify the generated audio file's existence and size.
  14. Read the WordPress language page to update.