need a super dev to build a end to end system for our publishing, a lot of what we have already but in silos SO I NEED A a fully integrated system that automates pulling data from Google Calendar, enriching it with external data (like paper titles and content), and preparing the final database for AI PYTHON CODE to generate questions and blurbs, LINKING TO INFORMIG USERS, AND A ZAP EMAIL SYSTEM
must be skilled in: WordPress and google apis python chatgpt/openai Use Railway.app, where it runs automatically on a schedule or triggers based on events. Dockerized Container Event-Based Triggers: Have the agent respond automatically to changes in the Google Sheet.
able to turn around the project in 3 days.
Example Workflow STEP 1: AUTOMATIC PULL FROM CALENDAR NEXT WEEKS INTERVIEWS - email addresses, dates, zoom details for the next week - Google api
STEP 2: Database Sheets Population: MANUAL Populate the database with new interviews details, including title of interview, raw content
STEP 3: Run python code/open ai integration in code - we have a working version here Enrich fields (subject, institution, country) using automated parsing. Generate blurbs and questions for each interview using GPT.
STEP 4: Automatically send interview questions via email.
STEP 5: Once editing completed, these rows will be manually inputted with embed code and they are good to go.
STEP 6: Daily Automation (Monday-Friday): Publish 16 posts daily based on the enriched data.
STEP 7: AUTOMATION GENERATUES URL, AND ENTERS EMAIL CHAIN UPDATING VIA SHEETS/ZAP
STEP 8: Reporting and Validation: Generate reports on published content and flag any data enrichment issues.
