I would like to create a Google Spreadsheet and reference a cell(-range) from that spreadsheet in a Google Document.

Basically, I want the spreadsheet to be a variable holder where I can input data to the fields I want, and the document displays this data in a format that looks better. Very much like creating a report to display my data.

How would this be accomplished?

p.s. I know how to reference a cell from one spreadsheet to another, this is NOT what I want. I want to reference a cell(-range) from a spreadsheet but I want to have the reference in a document.

  • 2
    That's not possible. The only way to do that, is to use Google Apps Script. Jun 25 '14 at 21:15
  • I tagged it [google-drive] because there wasn't a [google-scripts] a [google-docs] nor a [google-spreadsheet]. Is there a more effective tag I should have used? I'm new to the webapps stackexchange group. Jun 26 '14 at 13:15
  • @pnuts I don't even see your original comment that I responded to?! I forget the ping (@) thing, gotta start remembering that one... Jul 11 '14 at 19:53

As was stated in a comment, "That's not possible. The only way to do that, is to use Google Apps Script"

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.