I've come across multiple people wanting to inject a template (HTML, PDF, DOCX) with a spreadsheet's row's values.
For examples:
e-com store with the product names and descriptions in g-docs and wanting to create static-webpages for each product).
I want to write a pdf letter to all employees with their name and employee id and job title using a template.
Questions:
Hi @KevinColemanInc
You'd probably call this something like a "Sheets as CMS" (content management system) or "Sheets as Data Source"
Based on a quick search, here are some examples of apps that seem to offer sheets-as-an-API solutions:
Can't speak to any of these, as I haven't used them. A few examples come to mind, some of which are on display on the sites:
sheetsu.com didn't work.
The Sheets to API still requires a dev to connect the dots.
I'm just imaging a tool that a landlord could use to create contracts for all of their tenants, or a company to generate contracts for all of their employees, or a shopify owner to generate pretty HTML descriptions of all of their products.