This post shows how to refer to a range of cells when using EmbedCode[..., "GoogleDocs"]

It assumes you have read these two previous posts: http://community.wolfram.com/groups/-/m/t/388593 http://community.wolfram.com/groups/-/m/t/388578

First create the EmbedCode, as usual:

EmbedCode[ APIFunction[{"x" -> DelimitedSequence["Number"]}, N[Mean[#x]] &], "GoogleDocs"]

In this case, we are going to process a list of numbers, using DelimitedSequence["Number"] as the type. We use this list to calculate the Mean (numerically).

Copy and paste the generated code into the Google Docs script editor and save it.

Next, set up a spreadsheet with a column of numbers, for example:

In this case cell B13 holds the Wolfram Cloud call. You can specify the range as usual (in this case with B2:B11).

Hitting enter will cause the cloud evaluation to take place:

Note that updating any of the values in the range B2:B11 will cause a recomputation of the cloud evaluation as well.