Age Cohort Validation Using Google Sheets API & REDCap

Overview

This project automates the process of fetching participant age data from REDCap, validating age cohorts, and highlighting any mismatches. It consists of two key components:

1. Downloading and Updating Participant Age Data using the Google Sheets API & REDCap API.
2. Validating and Highlighting Mismatched Age Cohorts in an Excel file.

Features

• Fetches participant age data from REDCap using the REDCap API.
• Compares age values against the assigned cohort based on participant ID.
• Flags participants with incorrect age assignments for quality control.
• Exports data to an Excel file with automated highlighting (green for correct, red for mismatched).

---

Installation & Setup

1. Prerequisites

Ensure you have Python 3.x installed along with the required libraries:

pip install requests pandas openpyxl