#!/bin/sh

#V[gIDƃXvbhV[gAPIL[̐ݒ
sheetID= [pV[gIDĉ]
apiKey= [apiKeyĉ]

#sheet̏̎擾
wget https://sheets.googleapis.com/v4/spreadsheets/${sheetID}/?key=${apiKey} -O sheetInfo.txt

#擾 sheet̏t@CrowCount܂܂Ăs:E擾ĐɃLXgAsƂ100sO̍s擾B
startIndex=`cat sheetInfo.txt | grep rowCount | awk -F: '{print int($2)-100}'`
endIndex=`cat sheetInfo.txt | grep rowCount | awk -F: '{print int($2)}'`

#ZTf[^̎擾F̃f[^AsIs܂łɓĂ
wget https://sheets.googleapis.com/v4/spreadsheets/${sheetID}/values/A${startIndex}:I${endIndex}?key=${apiKey} -O result.js 

#擾ZTf[^ŐṼf[^̎擾kml̐
python3 perseSensordataJson.py > latest.kml

#webT[oŎQƂĂtH_ɐkmlt@C̃Rs[
cp latest.kml /var/www/html/latest.kml 

