Make.com Backend Data Pipeline Specialist

Posted 8 hours ago

Worldwide

Summary

I am looking for an experienced Make.com specialist to build a 100% automated backend data pipeline for personal finance. The project involves integrating multiple APIs and automating data flows to ensure seamless data management. The ideal candidate will have a strong understanding of Make.com and its capabilities, as well as experience with API integration and data automation. Trigger (Fillout.com): A user completes a 3-page intake questionnaire on Fillout, processes a checkout payment via Stripe, and uploads a multi-page financial statement PDF (checking/savings transaction histories).Processing (OpenAI API): Make.com needs to capture this submission, grab the uploaded PDF file data, and pass it directly to the OpenAI API using the gpt-4o model (must be the native API connector module, not a generic assistant web-link). You will use a specific system prompt (provided upon hire) instructing the AI to analyze the raw transactions, categorize them, and extract structured data summary sheets.Delivery (Gmail): The text output generated by OpenAI must be mapped into a pre-formatted, clean HTML text email template and automatically sent back to the customer’s email address within 60 seconds of submission.Conditional Logic Gate (Data Routing): If a user selects a specific region from a dropdown menu AND inputs a financial metric value over a certain threshold, Make.com must simultaneously trigger an instant, formatted email alert summarizing the contact details to a separate partner email address.Strict Privacy & Security Requirements:You must configure the OpenAI API module to ensure that user data is explicitly passed dynamically and never cached, stored, or permitted to train public models.No internal databases or data stores (like Airtable or Make Data Stores) should retain the raw transaction history PDFs. Data must strictly flow through memory from the form to the email and immediately drop out of the cache.Clean error-handling must be implemented: If the API fails or a file cannot be parsed, an automated email must gracefully alert the admin.

  • $300.00

    Fixed-price
  • Intermediate
    Experience Level
  • Remote Job
  • Ongoing project
    Project Type
Skills and Expertise
Mandatory skills
Python
PHP
Nice-to-have skills
SQL
MySQL
Activity on this job
  • Proposals:20 to 50
  • Last viewed by client:3 hours ago
  • Interviewing:
    0
  • Invites sent:
    0
  • Unanswered invites:
    0
About the client
Member since Sep 18, 2024
  • United States
    8:02 AM
  • HR & Business Services
    Small company (2-9 people)

Explore similar jobs on Upwork

Application InstallationFixed-price‐ Posted 2 weeks ago
Android
Smartphone
Tablet
iPhone
Software Development
Spring Boot
Product Development
Software
Java
Angular Material
AWS Application

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