AI Automation Expert Needed: Make.com + OpenAI Engine for PDF Invoice Data & SECR Reporting
Worldwide
I am looking for a talented AI Automation Engineer to build a working Minimum Viable Product (MVP) pipeline inside Make.com (formerly Integromat). The system will automate the extraction of energy data from unstructured utility bills and dynamically format it into a UK SECR-compliant output text block.I already have the logic mapped out; I just need a technical expert to build the secure routing and file handling. The Workflow Steps You Will Build: 1. Trigger: Monitor a designated Google Drive folder for newly uploaded utility invoices (PDFs/Images). 2. File Handling: Securely pass the file data/stream directly into OpenAI (using gpt-4o) so that privacy permissions do not block the vision model from reading the file. 3. Data Extraction: Use structured JSON outputs from OpenAI to accurately capture: Supplier Name, Account Holder Name, Billing Period End Date, and Total Energy Consumed (in kWh). 4. Calculations & Logic: * Segregate the data by energy type (Electricity = Scope 2, Gas/Fuel = Scope 1). -- Apply a simple multiplication formula using the standard UK Government Greenhouse Gas (GHG) Conversion Factors to turn kWh into metric tonnes of $CO_2e$. 5. Final Action: Take the final calculated carbon metrics and write them into a pre-formatted, compliance-ready text summary inside a Google Sheet row or a Google Doc template (matching SECR guidelines). Requirements: Proven experience building production-ready workflows in Make.com. Deep understanding of handling files/buffers inside Make.com to pass to the OpenAI/Anthropic APIs. Experience with JSON structure formatting.High attention to detail regarding data accuracy and error handling.
$150.00
Fixed-price- IntermediateExperience Level
- Remote Job
- One-time projectProject Type
Skills and Expertise
Activity on this job
- Proposals:20 to 50
- Last viewed by client:3 days ago
- Hires:1
- Interviewing:0
- Invites sent:0
- Unanswered invites:0
About the client
- GBRLytham St. Annes11:34 PM
- 1 hire, 1 active
- Energy & UtilitiesIndividual client
Explore similar jobs on Upwork
How it works
Create your free profileHighlight your skills and experience, show your portfolio, and set your ideal pay rate.
Work the way you wantApply for jobs, create easy-to-by projects, or access exclusive opportunities that come to you.
Get paid securelyFrom contract to payment, we help you work safely and get paid securely.
About Upwork
- 4.9/5(Average rating of clients by professionals)
- G2 2021#1 freelance platform
- 49,000+Signed contract every week
- $2.3BFreelancers earned on Upwork in 2020
Find the best freelance jobs
Growing your career is as easy as creating a free profile and finding work like this that fits your skills.
Trusted by