How to Automatically Create QR Codes from Google Sheets

Manually creating QR codes for hundreds of products, event attendees, or inventory items is tedious and error-prone. What if adding a row to your spreadsheet automatically generated a unique QR code?

With QR Code Maker and Zapier, you can turn any Google Sheet into a QR code generator.

When to Use Spreadsheet Automation

This workflow solves real problems across industries:

Product Catalogs - Add a new product to your inventory sheet, get a QR code linking to its product page automatically.

Event Management - When attendees register and appear in your spreadsheet, generate unique check-in QR codes.

Inventory & Assets - Create scannable labels for equipment, packages, or locations directly from your asset database.

Real Estate Listings - New property in your sheet? Automatic QR code linking to the listing page.

HR & Onboarding - Generate employee contact card QR codes when new team members join.

Marketing Campaigns - Bulk create campaign-specific tracking URLs with unique QR codes.

1000s

of QR codes

What You'll Need

Before starting, make sure you have:

• QR Code Maker account with a paid plan (for dynamic QR codes)
• Google account with access to Google Sheets
• Zapier account (free tier works, but has task limits)
• 10 minutes to set everything up

Step-by-Step Setup

Step 1: Prepare Your Google Sheet

Create a spreadsheet with these columns:

Example data:

Pro tips for your sheet:

• Use consistent naming conventions: "PRODUCT-001", "EVENT-BADGE-042"
• Keep the URL column clean - no extra spaces or formatting
• Leave the QR Code URL column empty - we'll fill it automatically

Step 2: Create Your Zap

1. Log into Zapier and click Create Zap
2. Search for Google Sheets as your trigger app
3. Select New Spreadsheet Row as the trigger event
4. Connect your Google account if not already connected
5. Select your spreadsheet and worksheet
6. Test the trigger to confirm Zapier can read your data

Step 3: Add QR Code Maker Action

1. Click the + to add an action
2. Search for QR Code Maker
3. Select Create URL QR Code as the action
4. Connect your QR Code Maker account via OAuth

Step 4: Map Your Fields

This is where the magic happens. Map your spreadsheet columns to QR code fields:

Important: Use descriptive names so you can identify codes later. Consider including a prefix like "SHEET-" to distinguish auto-generated codes.

Step 5: Write QR Code URL Back to Sheet

This step updates your spreadsheet with the generated QR code URL:

1. Add another action: Google Sheets > Update Spreadsheet Row
2. Select the same spreadsheet and worksheet
3. For the Row field, select the row ID from the trigger
4. Map the QR Code URL field to Column D

Now when a QR code is created, its URL appears in your spreadsheet automatically.

Step 6: Test and Activate

1. Add a test row to your spreadsheet
2. In Zapier, click Test step for each action
3. Verify the QR code appears in your QR Code Maker dashboard
4. Confirm the QR code URL is written back to your sheet
5. Turn on your Zap

Handling Different QR Code Types

The basic workflow creates URL QR codes, but you can generate other types too.

vCard QR Codes (Contact Cards)

Perfect for employee directories or networking events.

Spreadsheet columns: | Name | Email | Phone | Job Title | Company |

Zap action: Create vCard QR Code

Map fields:

• First Name, Last Name from Name column
• Email, Phone, Title, Organization from respective columns

WiFi QR Codes

For guest networks or office locations.

Spreadsheet columns: | Location | Network Name | Password | Security Type |

Zap action: Create WiFi QR Code

Map fields:

• SSID from Network Name
• Password from Password column
• Security (WPA, WPA2, WEP) from Security Type

Email QR Codes

For support contacts or feedback forms.

Spreadsheet columns: | Name | Email Address | Subject Line | Body Template |

Zap action: Create Email QR Code

Map fields:

• To address, Subject, Body from respective columns

Advanced: Writing Back Multiple Fields

Want more than just the QR code URL in your sheet? Update multiple columns:

Example expanded columns:

In your update step, map:

• QR Code URL = Tracking URL from QR Code Maker
• QR Image = Image URL (for embedding in documents)
• Created Date = Use Zapier's Formatter to add timestamp

Tips for Bulk QR Code Creation

Organizing Your Codes

Keep your QR Code Maker dashboard tidy:

• Create folders for different spreadsheet sources
• Use naming prefixes: "INVENTORY-", "EVENT-", "PRODUCT-"
• Include the source sheet name in the QR code name

Avoiding Duplicates

Prevent creating the same QR code twice:

• Add a Zapier filter: only proceed if QR Code URL column is empty
• Use unique identifiers in your spreadsheet (product SKU, attendee ID)
• Check for existing codes before creation

Handling Rate Limits

For large spreadsheets:

• Zapier processes rows sequentially, not all at once
• Large batches (500+ rows) may take 15-30 minutes
• For 1,000+ codes at once, consider our API for faster processing
• Stagger uploads to avoid hitting Zapier task limits

Error Handling

Common issues and fixes:

• Invalid URL format - Ensure URLs include https://
• Empty required fields - Add Zapier filters to skip incomplete rows
• Duplicate names - Append row numbers or timestamps to names

Real-World Examples

Example 1: Product Catalog

Scenario: E-commerce store with 500 products

Spreadsheet structure:

Workflow:

1. Marketing adds new products to the sheet
2. Zap creates QR code linking to product page
3. QR code URL written back for printing on packaging
4. Scan analytics track which products get most engagement

Result: Every product has a trackable QR code without manual creation.

Example 2: Event Registration

Scenario: Conference with 2,000 attendees

Spreadsheet structure:

Workflow:

1. Registration form populates the sheet
2. Zap creates QR code linking to attendee's LinkedIn
3. QR code URL used to print networking badges
4. Attendees scan each other's badges to connect

Result: Networking badges created automatically for every registrant.

Example 3: Inventory Labels

Scenario: Warehouse with 10,000 assets

Spreadsheet structure:

Workflow:

1. New assets added to inventory sheet
2. Zap creates QR code linking to asset detail page
3. Labels printed with QR codes for each asset
4. Warehouse staff scan to view maintenance history, location

Result: Every asset tagged with a scannable, trackable label.

Combining with Scan Notifications

Once your QR codes are created, add scan tracking:

1. Set up a second Zap: QR Code Scanned > Update Google Sheet Row
2. Log each scan with timestamp, location, device info
3. Build real-time analytics directly in your spreadsheet

Now your sheet becomes both the source and the analytics destination.

What's Next?

After automating QR code creation:

• Track performance - Get notified when QR codes are scanned
• Celebrate milestones - Trigger actions at 100, 500, 1,000 scans
• Explore all integrations - QR Code Maker + Zapier guide

Frequently Asked Questions