Google Sheets & Docs Automation: Automatically fill placeholders in templates with data from spreadsheets?
problem I work a lot with Google Sheets, Docs and Forms and would like to automate a process: I have Google Docs templates with placeholders (e.g. {{Name}}, {{Address}}). I have Google Sheets tables with data (e.g. survey results, internal data). I want a script or function to automatically create a new document (Doc or PDF)…