Qelv

Our own engineering. August 2023.

Google Sheets to PDF, on a service account

A team's records live in a spreadsheet because that is where the team works, but the document it hands over has to be a formatted PDF. This automation reads the worksheet through a service account and renders it with FPDF, so the sheet stays the working surface.

Workflow automation. Automate.

Worksheet rows read by a service account, rendered as PDF

Screens from this system are being added.

The situation

A team's records live in a spreadsheet because that is where the team works, but the document it hands over has to be a formatted PDF, assembled by hand each time.

What we built

  • Google Cloud and Google Sheets API connection with service-account access
  • Worksheet rows read through gspread, so the sheet stays the single working surface
  • Spreadsheet rows rendered into structured PDF output with FPDF

What changed

The sheet stayed the single working surface and the PDF assembled itself from it. Nobody copied rows into a document again.

Read next

Where to next

Have a problem in this shape?

Say so in a few sentences. The reply comes from the person who built this one.

We reply within two business days. If it is a fit, you get a one-page note on what to do first, before any sales call.