Stats Bot

Slack bot for extracting legacy giving data from Elasticsearch

After building the distiller, we needed a simple method for creating a report before the visual dashboard was implemented. I created a Slack integration that generates a CSV of the giving data, by flattening the schema in Elasticsearch, so we could see each gift individually. The resulting CSV is then encrypted and uploaded into Slack. I built the app using NodeJS wrapped with Typescript for increased tooling. It’s hosted using AWS elastic container service.