Generate PDF invoices from Google Sheets with PDF.co
This workflow automatically pulls invoice rows from Google Sheets and generates a PDF invoice using a PDF.co template. Perfect for small businesses that manage invoices in Sheets but need professional, ready-to-send P...
Template notes
This workflow automatically pulls invoice rows from Google Sheets and generates a PDF invoice using a PDF.co template. Perfect for small businesses that manage invoices in Sheets but need professional, ready-to-send PDFs.
---
⚙️ Setup Instructions
1️⃣ Connect Google Sheets 1. Copy this [Invoice Template Sheet](https://docs.google.com/spreadsheets/d/1a6QBIQkr7RsZtUZBi87NwhwgTbnr5hQl4JZOkr3F1U/edit?usp=drivesdk) into your own Drive 2. In n8n → Credentials → New → Google Sheets (OAuth2) - Log in with your Google account and save 3. In the workflow, select your Spreadsheet ID and Worksheet (Sheet1) in the Google Sheets node
---
2️⃣ Connect PDF.co 1. Create a free account at [PDF.co](https://pdf.co/) 2. Copy your API Key from the dashboard 3. In n8n → Credentials → New → PDF.co API - Paste your API Key → Save 4. In the PDF.co node, select your credential and choose the HTML Template to PDF operation
---
3️⃣ Create Your PDF.co HTML Template 1. In your [PDF.co dashboard](https://app.pdf.co/), go to Templates → New Template 2. Paste in the HTML from the template section below 3. Save the template and copy its Template ID 4. Replace the templateId in the workflow with your new ID