Description:
I’m looking for a U.S.-based automation engineer to build a small but important workflow. I already have refined AI prompt files (saved as .txt files in a OneDrive folder). Each file represents a product category and contains the logic for competitor pricing analysis. Right now, I manually drag these files into Claude/Copilot to generate reports.
I want this fully automated.
What I need built:
A serverless automation that:
• Connects to a specific OneDrive folder
• Reads every .txt file inside that folder (each file = one category)
• Sends the content of each file to Claude via API
• Captures the AI output
• Formats each category’s output into a clean report
• Emails me a combined report every Monday at 6am PST
• Automatically includes new .txt files added to the folder (no code changes required)
• Includes full code, documentation, and deployment into my AWS/Cloudflare environment
Important notes:
• No scraping required — the AI prompt already handles competitor lookups
• No NetSuite access required for this project
• This is a paid test project; if successful, there will be ongoing automation work (AP automation, purchasing automation, inventory adjustment → auto‑PO logic, etc.)
• U.S.-based freelancers only (due to security and communication requirements)
Ideal experience:
• Serverless automation (Cloudflare Workers, AWS Lambda, etc.)
• AI API integration (Claude, OpenAI, etc.)
• OneDrive / Microsoft Graph API
• Automated email delivery
• Internal tools and workflow automation
• Fast, practical, and comfortable working with prompt‑driven logic
Deliverables:
• Fully working automation
• Deployment into my environment
• Documentation for setup, environment variables, and maintenance
• A clean weekly email report generated from all .txt files in the OneDrive folder
Timeline:
This should be a 48–72 hour project for the right person.