Automation Enhancement for WordPress Blog

I'm seeking an automation expert to upgrade the current automation system for our blog-based website.

Currently, we provide a title, focus keyword, and image links in a Google Sheet, and the automation creates a blog in WordPress.

Here's what I need:
- Incorporate a download button linking to media files (e.g. videos, images) from Dropbox.
- Implementing alt text for images.
- Integrating a meta description, SEO title, slug, and tags.
- Complete SEO optimization for the entire blog post, not just the new elements.

Ideal skills and experience for the job include:
- Proficiency in WordPress and Google Sheets.
- Strong background in SEO.
- Previous experience with automation processes.
- Knowledge of handling media files and understanding of alt text requirements.
- Familiarity with Dropbox link integration.

The goal is to improve the functionality of our existing automation and enhance our blog's SEO performance.