Automate property link shortening & QR code generation with Google Sheets and Bitly

How It Works ⚙️

This workflow automatically takes a long property URL from your Google Sheet, shortens it, generates a QR code, and then updates your sheet with the new links.

1. 0. Google Sheets (New/Updated Row Trigger): 🚀 The workflow starts by constantly monitoring a specified Google Sheet. It triggers when a new property listing row is added, or when an existing row's "Property Link" column is updated. 2. 1. Shorten URL (HTTP Request - Bitly): 🌐 This node takes the long property URL from the Google Sheet. It then makes an API call to a URL shortening service (like Bitly) to generate a much shorter, shareable URL. 3. 2. Generate QR Code (HTTP Request - QR Code API): 📱 Using the shortened URL from the previous step, this node makes another API call to a QR code generation service. It generates an image link for a QR code that, when scanned, directs users to your property. 4. 3. Update Google Sheet (Update Row): ✅ Finally, this node takes the newly generated short URL and the QR code image link and writes them back into the corresponding row in your Google Sheet. This centralizes all the necessary links for your property listings.

How to Set Up 🛠️

Follow these steps carefully to get your "Property Link Shortener & QR Code Generator" workflow up and running in n8n:

1. Import Workflow JSON: Open your n8n instance. Click on 'Workflows' in the left sidebar. Click the '+' button or 'New' to create a new workflow. Click the '...' (More Options) icon in the top right. Select 'Import from JSON' and paste the entire JSON code for this workflow.

2. Prepare your Google Sheet: Create a Google Sheet with columns for your property listings. Crucially, ensure you have a column for the original long property URL (e.g., Property Link), a column for the shortened URL (e.g., Short URL), a column for the QR code image URL (e.g., QR Code URL), and a unique identifier for each row (e.g., Property ID).

3. Configure 0. Google Sheets (New/Updated Row Trigger): Locate the '0. Google Sheets (New/Updated Row Trigger)' node. Credentials: Select your existing Google Sheets OAuth2 credential or click 'Create New' to set one up. Spreadsheet ID: Replace YOURSPREADSHEETID with the ID of your Google Sheet. You can find this ID in the Google Sheet's URL. Sheet Name: Enter the exact name of the sheet (tab) within your spreadsheet (e.g., Listings or Properties). Trigger On: Choose Updated Row and select the column where your original long property link is located (e.g., Property Link). This ensures the workflow runs when you add or update a property link.