1. **WordPress Automation**: I need help automating the posting of daily WordPress posts from Google Sheets. The posts will need to utilize a few standardized custom fields. The ideal candidate will have experience with:
- Interfacing with WordPress - MySQL - Handling custom fields - Google Sheets API - Prefect and cron jobs
A key part of this task will be exporting the URL of each posted post back to the same Google Sheet.
2. **Automated Workflow System**: I am also looking for help setting up an automated workflow system for two creative projects. These projects use a suite of platforms including Prefect, Elevenlabs, Canva, and Flourish. The first project involves data visualisation, and the second, which is more complex and not immediately needed, is an explainer project using data from Google Sheets.
Experience with the following would be beneficial:
- Prefect for workflow automation - Elevenlabs and Canva for creative content - Flourish for data visualisation - Google Sheets for data sourcing
Please reach out if you have the relevant experience and skills
