Step-by-step guide
How to make an invoice from a Google Sheets row and send it as a PDF
Your orders are in Google Sheets, and the invoice is typed by hand every time: copy the name, copy the items, work out the tax, write the amount in words. In this guide the order row turns itself into a designed PDF invoice with your logo, sent with the alert on WhatsApp or Telegram to the person in charge.
Sheet Pulse team ·
First: prepare the sheet
A good invoice starts with a tidy sheet. You don't need to change how you work, but make sure everything you want on the invoice is in clear columns:
Order number
A column with the order number on every row. If an order has several items, each item is a row with the same order number.
Customer
The name, and the phone or address if you want them on the invoice.
Items
Item name, quantity and unit price, in separate columns.
Status
A column such as “Status” that changes to “Confirmed”, so the invoice goes out with the alert.
Second: design the invoice once
Your business details
Name, logo, colour, address, phone, tax number and payment QR code, entered once in Sheet Pulse.
Document type
Invoice, quote, proforma invoice or delivery receipt as an A4 PDF, or a certificate as an image.
Tax and numbering
Set the tax rate and a numbering prefix such as INV-2026, and invoices number themselves: INV-2026-0001, then 0002.
Language
An Arabic invoice from right to left, or an English one, with the amount written in words.
Preview on a real row
See the invoice with a real row's numbers from your sheet, and send yourself a test copy before turning it on.
Third: attach the invoice to the alert
Make a rule such as “status becomes Confirmed” in the orders tab, and choose who gets the message: the accountant, the rep named in the row, or the packing team's group. Then attach the invoice template to the rule. From now on, every order that becomes “Confirmed” has its PDF invoice arrive with the alert on WhatsApp or Telegram.
🧾 Order confirmed: 4521 · invoice attached
Customer: Al Rayan Est.
Items: 3
Total incl. tax: 2,875
📎 INV-2026-0137.pdf
Open the sheet
12:30
The amount in Arabic words, with no formula
One of the hardest parts of an Arabic invoice is writing the amount in words. In Google Sheets that takes long formulas or typing by hand. In Sheet Pulse the document writes it by itself, in Arabic or English, from the number in the row.
An order's items on one invoice
Rows that share an order number are gathered into one invoice.
PDF or image
Invoices as A4 PDFs, certificates as images that open on any phone.
The message still goes out
If the file can't be made for any reason, the message still goes out and the app tells you what happened.
A tidy invoice sheet: four small habits
- Write the order number the same way on all its rows, with no extra spaces, so its items are gathered on one invoice.
- Keep quantities and prices as numbers only, without the currency symbol in the same cell.
- One item per row; don't put two items in one cell.
- Let the status column change last: when it becomes “Confirmed”, the order's details are complete.
With these habits every invoice comes out right the first time, and the accountant and the customer trust its numbers.
Examples from real businesses
Online stores
Each confirmed order's invoice reaches the packing team with the alert.
Distribution and reps
The order's invoice reaches the rep to hand to the trader before leaving.
Accounts and collections
Each payment's invoice reaches the accountant with its number and tax.
Training centres
Each trainee who passes gets a certificate image sent to the coordinator.
Questions about invoices from Google Sheets
Do I need an invoice template in Google Sheets?
No. The design is done once in Sheet Pulse, and the sheet stays as it is: order rows with their columns.
My order has several items. How does the invoice gather them?
Write each item on a row with the same order number, and rows that share the number are gathered into one invoice.
Can I add my tax number and a payment QR code?
Yes. The tax number and payment QR code are part of your business details, entered once, and you set the tax rate.
Who is the invoice sent to?
To the rule's recipients: the accountant, the rep named in the row, or the team's group, on WhatsApp or Telegram.
Can I see the invoice before turning it on?
Yes. A live preview on a real row from your sheet, and a button that sends you a test copy.
Read next
- PDF invoices on WhatsApp from Google SheetsThe whole feature: invoices, certificates, design and numbering.
- Late payment alertsLate invoices and big amounts to the person in charge.
- How to get a WhatsApp message when a cell changesYour first alert in five steps.
- Google Sheets WhatsApp alertsEverything Sheet Pulse does, on one page.
Your next invoice writes itself
Message our sales team on WhatsApp and we will set up your invoice template with you, on your own sheet.