5
2 Comments

Google Sheets -> [docs|pdfs|webpages|email]

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:

  1. How do you describe such a service? (notice how the title is not great).
  2. How would you build this or use a service that does this?
on October 4, 2020
  1. 2

    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:

    • Price / Inventory lists
    • Contact lists
    • Placeholder -> Final Copy
    1. 2

      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.