I want to fill in a sentence with blank spaces on Google Docs from information that I can provide from Google Sheets. Is this possible?

"For my student number X = [student_number], the required power is [motor_power] kW, and the SMALLEST motor that can meet the required transmitted power requirement has a rated speed of [motor_rpm] RPM."

I want to embed or link a cell from Google Sheets to autofill the [boxes] in Google Docs

Is this something that is possible?


1 Answer 1


As Ruben pointed out, there is no simple dynamic way to "autofill" the "boxes" in a Google Docs text document with data from a Google Sheet.

But it is fairly straightforward to do the same statically: use a mail merge utility such as AutoCrat. See the AutoCrat User's Guide for more info — you are probably looking for the Single Document output mode option.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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