Create documents with data from an API, Google Sheets or JSON
You no longer need to paste numbers by hand inside the HTML. I LOVE HTML connects a data source and creates the document with the information already in place.
Three possible sources
- API: give the endpoint address and I LOVE HTML fetches the data when building the document.
- Google Sheets: point to the spreadsheet and use its rows and columns as content. Great if your numbers already live in a shared sheet.
- JSON: upload or paste a JSON file with the structure you already have.
What it's for in practice
- Monthly reports that always come out with the current numbers, no rework
- Dashboards for sales, traffic or operations fed by your own API
- Catalogs and price tables that live in a spreadsheet and become a good-looking page
- Proposals with values calculated from the client's data
How to do it
- In the dashboard, choose to create a document from a data source.
- Pick the type: API, Google Sheets or JSON.
- Enter the address (or upload the file) and check the data preview.
- Publish. The document gets a link like any other, with password, expiry and QR code if you want.
Since the document is regular HTML once created, everything else still applies: version history, read analytics, PDF and folder sharing.
Tips
- Make sure the API is publicly reachable or that access has been configured, otherwise the data won't arrive.
- In spreadsheets, keep the first row as the header: it makes mapping the fields easier.
- Need to update? Edit or reload the data and the link stays the same.