Auto-generate personalized Google Docs from a template
Build a workflow triggered by a form collecting the recipient's details. Copy a designated Google Docs template into a shared Drive folder, then replace named ranges/placeholders with the form values via the Google Docs API. Name the new doc meaningfully, set sharing as needed, and return the link. Handle missing fields, API errors, and avoid overwriting existing docs. Output the generated document URL.
What this prompt builds
Copy a Google Docs template into a shared folder and fill it with form responses automatically.
The problem
Producing personalized documents like welcome packets by copy-pasting into a template is slow and inconsistent at any volume. Small mistakes slip into documents that represent the company.
Solution and impact
This workflow copies a Google Docs template to a shared folder and populates named ranges with data from a form. Polished, personalized documents are generated instantly and uniformly.