Provide an outline of a perl script that connects to the Google Spreadsheets API and scans through the first column of a worksheet.