Google Sheets Integration Guide

Learn how to generate professional invoices directly from your Google Sheets in minutes.

Video walkthrough

Prefer to watch instead of read? This short video shows the exact setup from spreadsheet to finished invoice.

Create Your Spreadsheet

Create a new Google Sheet with the following column headers. Each column represents a parameter that will be passed to the invoice template.

Column	Description	Example
templateNumber	Invoice template ID (1–50)	2
supplier	Your company details	Acme Corp, 123 Business St, New York, NY
customer	Client details	Client Inc, 456 Client Ave, Boston, MA
issueDate	Invoice issue date	2024-01-15
dueDate	Payment due date	2024-02-15
bankAccount	Bank account for payment	123456789/0100
description	Item or service description	Web Development Services
quantity	Number of units	40
price	Price per unit	75.00
invoiceNumber	Unique invoice identifier (required)	INV-2024-001
comment	Additional notes (optional)	Thank you for your business!
currency	Three-letter ISO code for display/formatting	USD
link	Formula output (URL to the invoice)	Generated automatically

Add the URL Generation Formula

In a new column (e.g., column L), add this formula to generate invoice URLs. Replace yourdomain.com with your actual domain, or use localhost:3000 for testing.

=CONCATENATE(
  "https://yourdomain.com/invoice/",$A2,
  "?invoiceNumber=",ENCODEURL($J2),
  "&supplier=",ENCODEURL($B2),
  "&customer=",ENCODEURL($C2),
  "&issueDate=",ENCODEURL($D2),
  "&dueDate=",ENCODEURL($E2),
  "&bankAccount=",ENCODEURL($F2),
  "&description=",ENCODEURL($G2),
  "&quantity=",$H2,
  "&price=",$I2,
  "&comment=",ENCODEURL($K2),
  "&currency=",ENCODEURL($L2)
)

Important Note

The sample assumes columns are ordered as shown above (Template number in A, supplier in B, … currency in L, and the formula in M). Adjust the references if your sheet uses a different structure.

Fill in Your Data

Enter your invoice data in each row. The URL formula will automatically update to generate a unique link for each invoice.

Example Row:

templateNumber:2

supplier:Acme Corp, 123 Business St, New York, NY 10001

customer:Tech Solutions Inc, 456 Tech Blvd, San Francisco, CA 94105

issueDate:2024-01-15

dueDate:2024-02-15

bankAccount:1234567890

description:Consulting Services - January 2024

quantity:40

price:150.00

invoiceNumber:INV-2024-001

comment:Payment due within 30 days. Thank you!

currency:USD

View & Download Your Invoices

Click on any generated URL to view your invoice. The invoice will be displayed in the browser with the template you selected. You can then:

Click "Download PDF" to save the invoice as a PDF file
Share the URL directly with clients for easy access
Print the invoice directly from your browser

Pro Tips

Use Named Ranges

Create named ranges in Google Sheets for better formula readability and easier maintenance.

Try Different Templates

Change the template number (1-50) to see different invoice designs. Find the one that matches your brand best.

Bookmark Your Favorite Templates

Save template URLs with sample data to quickly test and preview different designs.

Automate with Apps Script

Use Google Apps Script to automatically send invoice links via email when you create new rows.

Ready to Get Started?

Browse our template gallery to find the perfect design for your business.

View All Templates