Generate Professional QR Codes with Google Sheets (No Coding Required!)

Tired of paying for QR code generators or giving your data to third-party services? Here’s how to build your own professional QR code generator using Google Sheets and Apps Script – completely free and under your control.

Why Build Your Own QR Code Generator?

Let’s be honest – QR codes are everywhere these days. From restaurant menus to business cards, they’ve become an essential part of modern marketing. But most QR code services either cost money, limit your usage, or require you to hand over your precious campaign data.

What if I told you that you could create a professional QR code generator that:

✅ Generates both digital and print-ready versions
✅ Tracks creation dates automatically
✅ Saves everything to your own Google Drive
✅ Costs absolutely nothing
✅ Takes less than 5 minutes to set up

Sound too good to be true? It’s not! Here’s how to do it.

The Magic of Google Apps Script

Google Apps Script is like having a personal developer that lives inside your Google Workspace. It can automate tasks, connect different Google services, and even talk to external APIs – all without you needing to know a single line of code.

For our QR code generator, we’ll use Apps Script to:

Read data from your Google Sheet
Generate QR codes using free APIs
Save the files directly to your Google Drive
Track when everything was created

Setting Up Your QR Code Factory

Step 1: Prepare Your Data

First, create a Google Sheet (or copy my sample):

Column A: Destination Name (e.g., “Homepage”, “Product Page”)
Column B: Placement (e.g., “Digital Placement”, “Print Materials”)
Column C: The URL you want the code to go to
Columns D-H: Any utms you need
Column I: Final URL for the QR Code
Column J: QR Code ID (unique identifiers like “DhHfests”)

Step 2: Install the Magic Script

Go to Extensions > Apps Script in your Google Sheet
If prompted, click “Enable Apps Script” (this is a one-time setup)
Delete the default code and paste in the QR generator script
Save the project and refresh your Google Sheet

Step 3: Generate Your QR Codes

Look for the new “QR Code Generator” menu in your Google Sheet. Click it and choose:

Authorize the app and permissions.
“Test Single QR Code” – Try it out first
“Generate 10 QR Codes” – Process your first batch
“Generate All QR Codes” – Go big and process everything

What You’ll Get

For each row in your sheet, you’ll automatically get two professional QR codes:

Digital Version (300×300 pixels, 72 DPI)

Perfect for websites, emails, and digital displays
Small file size, fast loading

Print Version (1250×1250 pixels, 300 DPI)

High-quality for business cards, flyers, and posters
Print-ready resolution

The Smart Features

Automatic Date Tracking

The system automatically adds two columns to your sheet:

Date Created: When the QR code was first generated
Date Last Modified: When it was last updated

Intelligent File Naming

Your files are named logically: Homepage_Digital Placement_DhHfests_digital.png

Reliable Generation

The script uses multiple QR code APIs with automatic fallbacks, so you’ll never be left hanging if one service is down.

Real-World Use Cases

Marketing Campaigns: Generate QR codes for different campaign elements and track which ones perform best.
Event Management: Create QR codes for different event materials – registration, feedback, social media.
Restaurant Menus: Generate QR codes for different menu sections or special promotions.
Real Estate: Create QR codes for property listings, virtual tours, or contact information.

Why This Approach Rocks

Complete Control: Your data never leaves your Google Workspace. No third-party services, no data sharing, no privacy concerns.
Cost Effective: Completely free to use. No monthly subscriptions or per-QR-code charges.
Scalable: Generate hundreds of QR codes in minutes without hitting usage limits.
Professional Quality: Both digital and print versions ensure you’re ready for any use case.
Easy Maintenance: Update URLs or regenerate QR codes anytime with a single click.

Getting Started

The best part? You can have this running in under 5 minutes. The script handles all the technical complexity while you focus on what matters – your campaigns and content.

Get the script here

Once you see how easy it is to generate professional QR codes with your own data, you’ll wonder why you ever paid for a service to do it.

Ready to build your own QR code generator? The script is ready to go, and your marketing campaigns are about to get a whole lot more efficient.

Happy QR coding! 🎯