Automated Data Capture & Pharma Summaries

I’m building a small knowledge base for pharmacists and need two closely-linked tasks handled together.

First, I want to automate the collection of pharmacy-relevant data—drug monographs, dosing tables, recent guideline updates, and comparable sources you recommend—because I don’t yet have any in-house spreadsheets or databases. You’ll choose and configure the most efficient automated input method, whether that’s a web-scraper, API pulls, or another workflow that keeps manual keystrokes to a minimum and lets me refresh the data on demand.

Once the raw information is flowing, I need concise research summaries written for each drug or topic captured. These should read like quick reference notes for clinicians: evidence level, key trial outcomes, common dosing, contraindications, and takeaway points, all grounded in primary literature. A pharmacy background (study or professional) is essential so the phrasing stays accurate and clinically relevant.

Deliverables
• A working, documented automation script or tool that imports the agreed data sets into CSV or Google Sheets
• Five sample research summaries (≈300–400 words each) formatted in clear subsections (Mechanism, Evidence, Dosing, Clinical Pearls)
• A brief guide showing how to run or modify the data pull and how the summaries should be structured going forward

I’ll review the script for reliability and skim the summaries for clinical accuracy before approving. Looking forward to pairing efficient data capture with sharp, pharmacist-level insight.