exporting variables to be read in a Google docs spreadsheet

I have been struggling with this all day.  Wow.  Thanks folks for all the files, sharing, collaboration, examples, helping, etc.  It made a big difference, but I missed one step somewhere along the line and finally figured out what was wrong.

Here is my 2 cents, for what it's worth now, on why mine didn't work.  Maybe it will help the next person along this path.

I had my folder where the Google Form and Google Spreadsheet set open to Public, but the form/spreadsheet themselves were not.  Without ensuring their share properties are public access as well, the variables from the course won't get written into the spreadsheet.