csvToSQL.sh

#!/bin/bash

#Save current configuration for IFS
OLDIFS=$IFS

curl -L "https://docs.google.com/spreadsheets/export?id=1sxIMF7H_ksLk34iFSgO8JFCbSHABlE_BPk3NNsdBOGo&exportFormat=csv&gid=0" -o ./DashSheet

#append newline at the end of csv file.
echo >> ./DashSheet

#Overwrite sql script
echo "use dash;" > ./insertSQL.sql

#Change separator temporarily to the comma
IFS=","

#Read line by line, each field into its own variabe, and parse into sql statements
while read f1 f2 f3 f4 f5 f6 f7 f8 f9 f10 f11 f12 f13 f14 f15 f16 f17
do
      echo "insert into trips (trip_date, start_weather, start_latitude, start_longitude, start_map, trip_score, trip_distance, engine_alerts, brake_alerts, accel_alerts, speed_alerts, sms_alerts, fuel_used, fuel_cost, end_weather, end_latitude, end_longitude, end_map)
	SELECT * FROM (SELECT curdate() as a, '$f1' as sw,'$f2' as b,'$f3' as c,'$f4' as d,'$f5' as e,'$f6' as f,'$f7' as g,'$f8' as h,'$f9' as i,'$f10' as j,'$f11' as k,'$f12' as l,'$f13' as m,'$f14' as ew,'$15' as n,'$f16' as o,'$f17' as p) as tmp WHERE (Select count(*) from trips where start_map='$f4') = '0';" >> ./insertSQL.sql
done < DashSheet #Read from csv file

IFS=$OLDIFS #Return to original configuration