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. **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. **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. **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. **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 Google Sheets (New/Updated Row Trigger):** - Locate the 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 `YOUR_SPREADSHEET_ID`** with the ID of your Google Sheet. You can find this ID in the Google Sheets 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. 4. **Configure Shorten URL (HTTP Request - Bitly):** - Locate the Shorten URL (HTTP Request - Bitly) node. - **Method:** Set to `POST`. - **URL:** `https://api-ssl.bitly.com/v4/shorten` - **Headers:** - Add `Authorization` with value `Bearer YOUR_BITLY_ACCESS_TOKEN`. (You'll need to generate a Generic Access Token from your Bitly account settings > Generic Access Token). - Add `Content-Type` with value `application/json`. - **Body:** Select `Raw` and `JSON`. - In the JSON body, enter: `{long_url: {{ $json["Property Link"] }}}`. **Ensure `Property Link` exactly matches your Google Sheet column header for the original URL.** - **Response Format:** Set to `JSON`. 5. **Configure Generate QR Code (HTTP Request - QR Code API):** - Locate the Generate QR Code (HTTP Request - QR Code API) node. - **Method:** Set to `GET`. - **URL:** `https://api.qrserver.com/v1/create-qr-code/?size=150x150&data={{ encodeURIComponent($(1. Shorten URL (HTTP Request - Bitly)).item.json.link) }}` - Here, `{{ $(1. Shorten URL (HTTP Request - Bitly)).item.json.link }}` refers to the output of the previous Bitly node. - You can adjust `size=150x150` as needed. - `encodeURIComponent` is important to handle special characters in the URL. - **Response Format:** Set to `Binary`. (This API directly returns the image, but we just need its URL which is in the `url` property of the response). 6. **Configure Update Google Sheet (Update Row):** - Locate the Update Google Sheet (Update Row) node. - **Credentials:** Select the same Google Sheets OAuth2 credential as in step 3. - **Spreadsheet ID:** Use the same `YOUR_SPREADSHEET_ID`. - **Sheet Name:** Use the same `YOUR_SHEET_NAME_E.G._Listings`. - **Key Column:** Set this to a unique identifier for your rows, e.g., `Property ID` (assuming you have one in your sheet). - **Key Column Value:** `={{ $json["Property ID"] }}`. **Make sure this matches your unique ID column from the Google Sheet.** - **Update Columns:** - Add an entry: - **Column:** `Short URL` (exact name of your short URL column in Google Sheet)

Platform

n8n

Category

Marketing

Price

Free

Creator

Marth

• stickyNote
• httpRequest
• googleSheets
• googleSheetsTrigger