You can now build documents with data from an API, Google Sheets or JSON
We have just shipped a feature that changes the routine for anyone publishing reports regularly: the document can pull its information straight from the source.
What changed
Before, the path was: generate the HTML, paste the numbers by hand, publish. Now you can connect:
- An API, by giving the endpoint address
- A Google Sheets spreadsheet, using rows and columns as content
- A JSON file, uploaded or pasted
The document is created with that data already inside, and it stays regular HTML afterwards: same link, same version history, same read analytics, same PDF.
Where it helps most
- Monthly reports that always come out with the current numbers
- Sales or operations dashboards fed by your own API
- Catalogs and price tables that live in a spreadsheet
- Proposals with values calculated from the client's data
The step by step, with tips on field mapping and access caveats, is in Create documents with data from an API, Google Sheets or JSON.