I am looking to be able to set & display google spreadsheets data in a javascript/html page.

Basically, the way it would ideally perform is the equivalent of a VLOOKUP as it would have to match the activeUser e-mail and then retrieve and store the value from the corresponding column.

The data would be stored in the following way:

col1, row1: user1@test.com
col2, row1: 90%
col3, row1: 1

And the desirable result would be the script importing c1;r1 if c3;r2 contains 1. (This would have to work by matching the e-mail of the current user in the website and then find the column/row where it contains his data)

I'm basically a JavaScript noob and would really appreciate assistance if possible. Thanks to everyone and apologies if my question is something elementary.