Web Applications Stack Exchange is a question and answer site for power users of web applications. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am working on using Google Spreadsheets as a gradebook. I am attempting to display only a student's grade, not an entire classes. I am integrating this into my wordpress site. The function I want to use will grab the logged in user's email and then look up that email in the spreadsheet and display Column A and whatever column their email is in.

I found the following code, which I think is a start. I can use a PHP function to get the user email address (rather than a search string) but this only displays the row the email is in. How can I get it to display only the column?

Here is the pastepin of the code I have been playing with:

Original code

New code

share|improve this question
Why don't you work with Google Sites in combination with Google Apps Script? These two with Google Spreadsheets are very powerful! You can make student dependant pages, elimination all this. – Jacob Jan Tuinstra Apr 13 '13 at 8:47
I have used Google Sites before, but am not too familiar with Google Apps Script. I still prefer Wordpress, because it is more powerful and I am very familiar with it. Nevertheless, could you point me in the right direction in terms of the Google Apps Script? – Acornrevolution Apr 13 '13 at 22:47
In your select statement, you pick column A, B, C. If you filter on A, it will show A, B and C. If you select C, and filter on A, it will show only C. – Jacob Jan Tuinstra Apr 14 '13 at 19:47
In Google Sites, you can make site pages by using a template. Those pages can be restricted. Down the line you can easily embed a Spreadsheet that could have the same restriction. See following g+ page: plus.google.com/u/0/communities/112780694700423616523 -- Good luck. – Jacob Jan Tuinstra Apr 14 '13 at 19:51

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.