1

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
  • Welcome to Web Applications. Short answer: It's not possible. If you need further help, please show what you tried, add a brief description of your search efforts as is suggested in How to Ask.
    – Rubén
    Aug 24, 2021 at 0:34

1 Answer 1

0

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 that you have read and understand our privacy policy and code of conduct.

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