X-Git-Url: https://code.communitydata.science/coldcallbot-discord.git/blobdiff_plain/92e65de7715056ee39c923e1d51fb8c777e64afd..3c9c64edc856e6c8656614b5106b1f3f67704621:/download_student_info.py?ds=sidebyside

diff --git a/download_student_info.py b/download_student_info.py
new file mode 100755
index 0000000..0b6a98f
--- /dev/null
+++ b/download_student_info.py
@@ -0,0 +1,15 @@
+#!/usr/bin/env python3
+
+import json
+import subprocess
+
+with open("configuration.json", 'r') as config_file:
+    config = json.loads(config_file.read())
+
+base_url = 'https://docs.google.com/spreadsheets/d/{id}/export?gid={gid}&format=tsv'
+
+student_info_url = base_url.format(id=config["student_info_gsheet_id"], gid=config["student_info_gsheet_gid"])
+subprocess.run(["wget", url, "-O", config["student_info_file"]], check=True)
+
+optout_url = base_url.format(id=config["optout_info_gsheet_id"], gid=config["output_info_gsheet_gid"])
+subprocess.run(["wget", optout_url, "-O", config["optout_file"]], check=True)