# mofo-allhands-event-app-data-processor

**Repository Path**: mirrors_mozilla/mofo-allhands-event-app-data-processor

## Basic Information

- **Project Name**: mofo-allhands-event-app-data-processor
- **Description**: a Python script that fetches data from a Google spreadsheet, transforms to JSON, then commits a data file to a GitHub repo.
- **Primary Language**: Unknown
- **License**: MIT
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2020-08-22
- **Last Updated**: 2026-04-04

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# MoFo All-hands Schedule App Data Processor

This script is designed as a data processor helper for [mofo-allhands repo](https://github.com/mozilla/mofo-allhands). If you want to use this script as is make sure your Google Spreasheet is based on the [Google spreadsheet template we designed](https://docs.google.com/spreadsheets/d/1TEn1AYjLUSXagxJGhOiNPbDdPxsqJsSmeI-_4pvS41U/edit#gid=1546802594).

This Schedule App Data Processor script handles the following tasks

1. takes data from a Google spreadsheet,
2. and converts it to a JSON array where each object has keys corresponding to the 
  spreadsheet column names,
3. then stores that JSON locally and/or automatically commits it to a GitHub 
  repo (your schedule app repo, e.g., [MoFo All-hands schedule app](https://github.com/m ozilla/mofo- allhands)).

## To run the script

1. Create a Python virtual environment and install all the required packages. See 
[create a Python virtual environment docs](https://github.com/mozilla/mofo-allhands-event-app-data-processor/blob/master/docs/REQUIREMENTS.md#create-a-python-virtual-environment) for instructions.
2. Get API creds from GitHub and Google. See [authentication docs](https://github.com/mozilla/mofo-allhands-event-app-data-processor/blob/master/docs/REQUIREMENTS.md#authentication) for instructions.
3. Share your Google Spreadsheet with the Google Service Account that you created in Step 2.
4. Set values for [environment variables](https://github.com/mozilla/mofo-allhands-event-app-data-processor/blob/master/docs/REQUIREMENTS.md#environment-variables) and run `source your-file-name.env`
5. Running `update_schedule()` will execute [these methods](https://github.com/mozilla/mofo-allhands-event-app-data-processor/blob/master/docs/REQUIREMENTS.md#primary-methods-of-the-script) in succession. You can trigger it from the command line: **`python update_schedule.py`**