Content creation Automation

(The project is been edited and cut shorter) This gig is about creating a social media content automatically based on the input from a google sheet. The content can be either an infographic or a very short video like 6 to 10 seconds. Have a good read of my requirements and I look forward to your detailed proposal. Below are my requirements: Purpose: To develop an automation to create social media content, in either an infographic or a short video Scope : The system must support content generation, image generation and storage.

1. Campaign Input • Google sheet will have the campaign details, which act as a central input • Accept fields such as campaign title, product name, messaging, pricing and CTAs. • Store data in a structured repository (Google Sheets or equivalent).
2. Automated Content Generation • Generate two platform-specific posts: Facebook, Instagram. • Use an AI model to produce captions suitable for each platform. • Return generated captions into the repository(google sheet). • Track time of generation for audit.
3. Image Generation • Generate one campaign image or short video using an AI vision model. • Upload the generated image to a media storage service/google drive • Store metadata such as resolution and generation time.
4. Status Tracking • Maintain a status column for each campaign. • Automatically update status from “Draft” to “Ready for Review” after content and image generation. • Store timestamps for each status change.
5. Error Handling • If any step fails, mark the campaign status as “Error”. • Log error description and the failing module. • Allow manual retry without regenerating content.
6. Configuration • All API keys must be stored securely. • Provide a configuration panel for keys, platform selectors and template management.

PS. If your proposal is not clear or not addressing the needs, I won't be able to respond.

Budget: USD 50 (Fixed Price)

Proposals: 21 freelancers have applied