source: gs3-installations/thewillow/trunk/sites/thewillow/collect/community-contributions/prepare/DOWNLOAD-PUBLIC-GSHEET-AS-XSLX--THEWILLOW.sh@ 37634

#!/bin/bash

download_sheets_separately=0

gsheet_docid="1dBRRs7gqD46q21oDErw83NMK-9jY_DmuCvrzODDcgJI"

output_filename_root="Willow Archive Directory"

echo ""
echo "****"
echo "* The following wget call works if the document is publicly accessible"
echo "* "
echo "* If authentication is needed, then setup up rclone and copy using that"
echo "****"
echo ""

echo "Sleeping for 5 secs before running command"
sleep 5
echo ""

if [ $download_sheets_separately = 1 ] ; then

    #information_sheet="gid=969758927"
    directory_sheet="gid=1389522865"
    #objecttype_sheet="gid=0"
    #theme_sheet="gid=459198218"

    echo "Downloading sheet 'directory':"
    
    wget --no-check-certificate \
     -O "${output_filename_root}-directorysheet.xlsx" \
     https://docs.google.com/spreadsheets/d/1j6_xry6OfLrdBkXeYZA8NTLCZwf-jr5DHlpGwAONLyY/export?$directory_sheet&format=xlsx
    
else
    echo ""
    echo "Downloading full spreadsheet:"
    echo "  https://docs.google.com/spreadsheets/d/$gsheet_docid/export?format=xlsx&id=$gsheet_docid"
    echo ""
    
    wget --no-check-certificate \
     -O "${output_filename_root}.xlsx" \
     "https://docs.google.com/spreadsheets/d/$gsheet_docid/export?format=xlsx&id=$gsheet_docid"

    echo ""
    echo "----"
    echo "Testing the file type of the downloaded file => expected to be 'xlxs'"
    echo "----"
    
    # echo file "${output_filename_root}.xlsx"
    echo "  " `file "${output_filename_root}.xlsx"`
    echo "----"
    echo ""
    
fi