I'm trying to populate an invoice. I have a Google Spreadsheets that calculates hours per project, and I want to bring that into a Google Docs. Despite much searching, I have found no way to do this.
I thought IMPORTRANGE
would work as a new equation, but no luck.
How do you enter a formula into a Google Docs?
Best Answer
The following piece of code will create a Google Document and will insert a dynamic text, as a paragraph, into the newly created document. All is done from within a Google Spreadsheet.
Code
Add
The code in your Google Spreadsheet, under Tools>Script editor. Press the bug button to authenticate the code and all is set to go.
Example
I've created an example file for you: create Google Document with text