# omeshwarsgit/rightchoice-sync architecture

> Architecture diagram of the GitHub repository omeshwarsgit/rightchoice-sync, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-10-05). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/omeshwarsgit/rightchoice-sync
- Repository: https://github.com/omeshwarsgit/rightchoice-sync

## Overview

rightchoice-sync exports yesterday’s reviews from RightChoice and appends them to a Google Sheets tab. The documented handoff is a CSV file that a downstream step can pick up; the repository contains separate export and upload scripts, but no shown orchestrator connecting them. The README provides no further capability details, and the workflow file was not sampled, so scheduling and automatic invocation are not represented.

Main entry points: [`export_rightchoice_reviews.py`](https://github.com/omeshwarsgit/rightchoice-sync/blob/main/export_rightchoice_reviews.py) (Review CSV exporter), [`upload_to_sheets.py`](https://github.com/omeshwarsgit/rightchoice-sync/blob/main/upload_to_sheets.py) (Sheet appender)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_export["Review export"]
  node_exporter["Review CSV exporter"]
  node_csv["Reviews CSV"]
end

subgraph group_upload["Sheets upload"]
  node_uploader["Sheet appender"]
end

node_operator(("Workflow operator"))
node_rightchoice{{"RightChoice dashboard"}}
node_google[("Google Sheets")]

node_operator -.->|"runs export"| node_exporter
node_exporter -->|"logs in, filters, exports"| node_rightchoice
node_exporter -->|"saves CSV"| node_csv
node_operator -.->|"runs upload"| node_uploader
node_uploader -->|"reads rows"| node_csv
node_uploader -->|"appends rows"| node_google

click node_exporter "https://github.com/omeshwarsgit/rightchoice-sync/blob/main/export_rightchoice_reviews.py"
click node_uploader "https://github.com/omeshwarsgit/rightchoice-sync/blob/main/upload_to_sheets.py"

classDef toneNeutral fill:#f8fafc,stroke:#334155,stroke-width:1.5px,color:#0f172a
classDef toneBlue fill:#dbeafe,stroke:#2563eb,stroke-width:1.5px,color:#172554
classDef toneAmber fill:#fef3c7,stroke:#d97706,stroke-width:1.5px,color:#78350f
classDef toneMint fill:#dcfce7,stroke:#16a34a,stroke-width:1.5px,color:#14532d
classDef toneRose fill:#ffe4e6,stroke:#e11d48,stroke-width:1.5px,color:#881337
classDef toneIndigo fill:#e0e7ff,stroke:#4f46e5,stroke-width:1.5px,color:#312e81
classDef toneTeal fill:#ccfbf1,stroke:#0f766e,stroke-width:1.5px,color:#134e4a
class node_exporter,node_csv toneBlue
class node_uploader,node_google toneAmber
class node_operator,node_rightchoice toneIndigo
```

## Components

### Review export

- [Review CSV exporter](https://github.com/omeshwarsgit/rightchoice-sync/blob/main/export_rightchoice_reviews.py): `export_rightchoice_reviews.py`
- **Reviews CSV**

### Sheets upload

- [Sheet appender](https://github.com/omeshwarsgit/rightchoice-sync/blob/main/upload_to_sheets.py): `upload_to_sheets.py`

### Other components

- **Workflow operator**
- **RightChoice dashboard**
- **Google Sheets**

## Connections

- Workflow operator → Review CSV exporter: runs export
- Review CSV exporter → RightChoice dashboard: logs in, filters, exports (evidence: `export_rightchoice_reviews.py`)
- Review CSV exporter → Reviews CSV: saves CSV (evidence: `export_rightchoice_reviews.py`)
- Workflow operator → Sheet appender: runs upload
- Sheet appender → Reviews CSV: reads rows (evidence: `upload_to_sheets.py`)
- Sheet appender → Google Sheets: appends rows (evidence: `upload_to_sheets.py`)
