AI Automation Expert Needed: Make.com + OpenAI Engine for PDF Invoice Data & SECR Reporting

Posted 6 days ago

Worldwide

Summary

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
  • Intermediate
    Experience Level
  • Remote Job
  • One-time project
    Project Type
Skills and Expertise
Mandatory skills
Make.com
Zapier
API Integration
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
Member since Jun 23, 2026
  • GBR
    Lytham St. Annes11:34 PM
  • 1 hire, 1 active
  • Energy & Utilities
    Individual client

Explore similar jobs on Upwork

Job Aggregation and Dashboard CreationHourly‐ Posted 8 months ago
Automation
Data Scraping
Data Extraction
API
UI/UX Prototyping
Web Scraping
Install and Integrate UTM Grabber PluginFixed-price‐ Posted 3 weeks ago
WordPress

How it works

  • Post a job icon
    Create your free profile
    Highlight your skills and experience, show your portfolio, and set your ideal pay rate.
  • Talent comes to you icon
    Work the way you want
    Apply for jobs, create easy-to-by projects, or access exclusive opportunities that come to you.
  • Payment simplified icon
    Get paid securely
    From contract to payment, we help you work safely and get paid securely.
Want to get started? Create a profile

About Upwork

  • Rating is 4.9 out of 5.
    4.9/5
    (Average rating of clients by professionals)
  • G2 2021
    #1 freelance platform
  • 49,000+
    Signed contract every week
  • $2.3B
    Freelancers 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

  • Microsoft Logo
  • Airbnb Logo
  • Bissell Logo
  • GoDaddy Logo