#!/usr/bin/env bash

# Download the file
URL_BASE="https://docs.google.com/spreadsheets/d/1XuQ-bEgW0Tmj5XON5komtZxtFlkP_VE_vIgLyVtFUUE/gviz/tq?tqx=out:csv&sheet=Row+"
ROWS="A B C D E F G H I L M O P Q R S T"

mkdir -p data

for i in $ROWS; do 
    I=$(echo $i | tr '[:upper:]' '[:lower:]')
    echo "row $I..."
    curl -s -o "data/row_$I.csv" "$URL_BASE$i"
done