Building a CustomGPT(?) to Cross-Check Pharmacy Reports in Airtable or OpenAI?

Community
1

Hi everyone, I’m looking for some advice on how to build a customGPT or something similar that can cross-reference reports from our pharmacy system (PioneerRX) and then notify the relevant person when discrepancies are found.
The tools I have at my disposal are: Airtable, Gmail, Google Drive, OpenAI platform, ChatGPT, Make

I have 2 files that I receive on a daily basis per mail in a pdf format

Use Case:
We manage medications and patients via PioneerRX, which sends us 2 daily reports of prescriptions that are “waiting to be filled” & “compounds filled” (think of this in the e-commerce business as “ready to ship” and “fulfilled”).

The goal is to have a GPT that can:

  1. Compare Records: Cross-reference the daily reports
  2. Identify Discrepancies: If a record appears in both the “waiting to fill” report and a “filled” log (Compounding Fill/Production Log), or if a record is missing, the system should flag it.
  3. Send Notifications: Notify a team member via email if discrepancies are found.

How I Plan to Implement This:
Report intake: reports are being sent to gmail from a specific email address with 2 different subjects (each report has its own subject, same sender)

File Format: Currently PDF
File Storage:Hopefully it can be directly sent to the AI model for cross reference checking.
Logging:I need to track discrepancies and actions taken in a separate Airtable table (e.g., Date, RX number).
Email Alerts: If there is anything tagged as not delivered, but it shows as delivered, it needs to send an email alert.

Where I Need Guidance:
I’m currently trying to implement this using Make to manage file ingestion and routing, but things aren’t quite working as expected. I could really use some direction on how to get this process on the right track. Any advice or suggestions to help me get started or rethink my approach would be incredibly helpful.

Thanks in advance for anything that might spark the right idea!

2

You’ll probably want to host a server for this and use the API instead of creating a GPT on ChatGPT. I’d probably start by reading the entire documentation. Sounds boring but after you are done you’ll most likely have a better idea on how to build what you are looking for.

1 Like