Skip to content
For Companies in Egypt 🇪🇬Request an on-site engineer visit for turnkey setup & direct supportBook a visit
Sheet Pulse

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

  1. Your business details

    Name, logo, colour, address, phone, tax number and payment QR code, entered once in Sheet Pulse.

  2. Document type

    Invoice, quote, proforma invoice or delivery receipt as an A4 PDF, or a certificate as an image.

  3. Tax and numbering

    Set the tax rate and a numbering prefix such as INV-2026, and invoices number themselves: INV-2026-0001, then 0002.

  4. Language

    An Arabic invoice from right to left, or an English one, with the amount written in words.

  5. 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.

Sheet Pulse

🧾 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 invoice gathered the order's three items from its rows, worked out the tax and wrote the amount in words.

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.

All frequently asked questions

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.