Need a customized project? We build it to your exact requirements.Contact us on WhatsApp

Free Invoice Generator with Auto Numbering – Google Sheets

FREE025 Billing & Invoicing Premium Plan Weekly Plan VIP Premium Plan
❤️
Need a Custom Business Solution?
Connect with us on WhatsApp to discuss your requirements. Our team will design and develop a tailored software solution aligned with your business workflow, operational needs, and growth objectives.
How to Create a Professional Invoice Generator Software with Google Sheets and Google Apps Script
You get
  • Google Sheet link
  • Source code file
  • Resale rights
  • Edit rights
  • Setup guide
  • AI setup help

Key Features

Invoice number continuing from the last one used Numbers never repeating a previous invoice Item dropdown built from your own item sheet Custom item typed in when it is not on the list Quantity and price multiplied automatically Tax added into the invoice total As many line items as an invoice needs Customer name address and city on the invoice Saved invoice reopened by searching its number Reopened invoice edited and added to Invoice number not found message Show data listing every saved invoice Print the invoice for the customer Embeds into Blogger WordPress or your own site

Description

FREE025 is a standalone invoice generator — no login, no dashboard, just the invoice. Enter the customer, pick the items, print it or save it. What makes it worth having over a spreadsheet template is that it remembers: numbers never repeat, items come from your own list, and a saved invoice can be found again by its number.

Numbers that carry on

The invoice number continues from the last one used. If your last invoice was 1200, the next is 1201. You are never handed a number that already exists, which is the failure mode that makes reconciling a year's invoices painful.

Items from your own list

The item dropdown is built from the items you keep in the sheet, so regular products are two clicks rather than retyped. Anything one-off can still be typed in as a custom line. Quantity times price calculates itself, tax goes on top, and you add as many lines as the job needs.

Finding an invoice again

Type an invoice number and the saved invoice reopens — you can then add to it or correct it rather than starting over. A number that does not exist returns an invoice number not found message. Show Data lists everything you have issued, so the whole history is one click away.

Printing and placing it

Print produces the customer's copy. The deployed app embeds into Blogger, WordPress or your own site, and the CSS is yours if the layout should carry your branding.

Which invoice file to pick

This one has no login — anyone with the link can raise an invoice. The other invoice file in this catalogue puts a registration and login in front of the same job, at the cost of a longer two-deployment setup.

Requirements

  • A Google account with Drive and Sheets
  • Your own copy of the provided spreadsheet
  • Your regular items listed in the item sheet
  • Run the script once and grant the permissions
  • Deploy as a web app and share or embed the link

What's Included

  • Complete Apps Script code already inside the sheet
  • Google Sheet with the invoice and item tabs
  • Invoice form with customer details
  • Automatic invoice numbering from the last used
  • Item dropdown fed from your item sheet
  • Custom line item entry
  • Quantity and price calculation with tax
  • Search to reopen a saved invoice by number
  • Show data listing every saved invoice
  • Print output for the customer copy
  • Embed steps for Blogger WordPress or your own site
  • Step-by-step video walkthrough of the full build
  • Free support from the developer

Item Details

Versionv1.0
PublishedAug 22, 2025
PlatformGoogle Apps Script
DatabaseGoogle Sheets
CategoryBilling & Invoicing
Tagsinvoice generator google sheets freeinvoice number generator google sheetsautomatic invoice generator google sheetsgoogle sheets invoice generator templatefree invoice software for small businessinvoice generator google apps scriptbilling software in google sheetsembed invoice generator wordpress
VideoWatch walkthrough
LicenseRegular License
Subscription Verification Required
This is a free file. Subscribe to our YouTube channel to unlock the source code + Google Sheet. One click — no payment. Google only confirms you are subscribed.
Verify Now
Free download

Subscribe & Unlock Source Code

Subscribe on YouTube, then verify with one click. No payment, no card. Google is used only to confirm your subscription.

What you get

  • Code.gs + HTML filesThe complete Apps Script project
  • Google SheetYour own copy with the data
  • Setup guideInstall steps from start to finish

Not subscribed yet? Subscribe to our channel

Browse More Free Files
Custom development

Need this customized for your business?

Extra modules, your branding, integrations or reports built on top of this file. You get a clear quote and timeline before any work starts, and support after delivery.

400+Projects delivered
91+Countries served

20–30% advance to start · Clear quote before work begins · Support after delivery

What we customize

  • Features & functionsNew features, changes to existing scripts, custom formulas and automations
  • API & integrationsWhatsApp, payment gateways, CRM and more
  • Design & UI changesYour branding, layout redesign, dark mode, mobile layout
  • Full custom projectsDashboards, billing, inventory, CRM, built from scratch
Free
Source Code File

People choose these

Paid picks from the same category

How to Create ISP Billing Software in PHP MySQL with Claude Code Fable 5.1 How to Create ISP Billing Software in PHP MySQL with Claude Code Fable 5.1 266 views this month PHP How to Build an ISP Billing System: Automated WhatsApp & Call Features How to Build an ISP Billing System: Automated WhatsApp & Call Features 169 views this month Apps Script How to Create an Invoice Web App Using Google Sheets and Apps Script | B34 How to Create an Invoice Web App Using Google Sheets and Apps Script | B34 45 views this month Apps Script

Reviews & Feedback

What buyers and YouTube viewers say about this project.

Sort
@iamclixkers4388 via YouTube
Masya Allah, thank you sir.
1 like on YouTube
@curiositeinformatique via YouTube
Merçi beacoup tu es vraiment genial! Bon travail!
1 like on YouTube
@hellogarvv via YouTube
Make video on student fee due and paid in monthly fee in sheet
1 like on YouTube
@amardutta-z8i via YouTube
GOLD JEWELLERY SHOP
@vishwabalachandar via YouTube
ReferenceError: $ is not defined (line 74, file "invoice")
@vishwabalachandar via YouTube
ReferenceError: $ is not defined (line 74, file "invoice") How to solve this problem
@Mr._lalandas via YouTube
Sir ek data entry sheet video create kijiye jisme multiple sheets me work kre
@UploadFile-jf7qg via YouTube
Can I have the results file please?
@abdul__vlogger-u2r via YouTube
Source code free hai kya
@makelifeeasy1917 via YouTube
one more thing dear, make product as dropdown. and show the buying rate when you chose product.
@sathishkumarc1342 via YouTube
Source Code not getting
@daulatvishwakarma2492 via YouTube
thanx brother -- very usefull
@ahmedfizah7408 via YouTube
Cannot the html file be in the appscript instead of visual basic?
@bohidarbohidar via YouTube
love you bro from india
@zohairdilawar116 via YouTube
Thank you Mohamed bhai , i will request u to please teach how to do the following 1. Link this to ur login form 2. After the login form should come the list of invoices and when clicked should open the invoice for editing 3. Add logo to invoice 4. Auto email in pdf