---
title: Create Tradable Bits Landing Trackers Automatically in Google Sheets
description: This guide will walk you through how to quickly create a Tradable Bits Landing Tracker using just a Google sheet.
---
[Skip to content](https://resources.tradablebits.com/support/create-tradable-bits-landing-trackers-in-google-sheets#main-content)
English
Show submenu for translations
![tradable-bits-long-logo-for-download.png\]](https://resources.tradablebits.com/hs-fs/hubfs/tradable-bits-long-logo-for-download.png?height=40&name=tradable-bits-long-logo-for-download.png)
Open main navigation
Close main navigation
- English
Show submenu for translations
How can we help?
- There are no suggestions because the search field is empty.
1. [Resources](https://resources.tradablebits.com/support?hsLang=en)
2. [Trackers](https://resources.tradablebits.com/support/trackers?hsLang=en)
# Create Tradable Bits Landing Trackers Automatically in Google Sheets
## This guide will walk you through how to quickly create a Tradable Bits Landing Tracker using just a Google sheet.
Landing Trackers are an integral part of tracking not only your clicks, but also your ROI if you have your Tradable Bits Sales Pixel setup as well. They can tell you which social ads, email campaigns, even engagement contests are leading to the most ticket sales.
If you use Google Sheets to create UTMs or to track all of your links this help doc will allow you to continue this process and teach you how to integrate the automated creation of Landing Trackers into your sheets as well.
**1)** Create a new Google Sheet, or if you already have a link sheet, create a new copy of your Google Sheet (some of the older ones won't work with the custom Tracker script)
**2)** Within your Google Sheet, click **Extensions\>Apps Scripts** from the navigation bar at the top of your sheet
**3)** Name the script **TBits Script**. Now you're going to go grab the script you need
**4)** Go to [https://tradablebits.com/developers/tracker](https://tradablebits.com/developers/tracker)
**5)** Copy the script on this page and paste it into your Apps Script Extension
**6)** Replace the Xs in the script with your own Tradable Bits Public API Key
- Retrieve your Public API Key by clicking on your account details in the top right and navigating to **Security & Access \> API Keys**
- Copy your Public API Key and paste in to replace the **X**s in the script
**7)** If you have a **virtual** **domain** setup on your account replace 'tradablebits .com' next to 'virtual domain' in the script with your virtual domain URL
**8)** Click the **Save Project to Drive** button to the left of **Run** in the top bar
****
**Still need assistance? Please reach out to your Customer Success Team or contact [support@tradablebits.com](mailto:support@tradablebits.com)**
- [Getting started](https://resources.tradablebits.com/support/getting-started?hsLang=en)
- [Account](https://resources.tradablebits.com/support/account?hsLang=en#main-content)
- [Account Admin](https://resources.tradablebits.com/support/account?hsLang=en#account-admin)
- [Security & Data Practices](https://resources.tradablebits.com/support/account?hsLang=en#security-data-practices)
- [Engagement Campaigns](https://resources.tradablebits.com/support/engagement-campaigns?hsLang=en#main-content)
- [Campaign Basics](https://resources.tradablebits.com/support/engagement-campaigns?hsLang=en#campaign-basics)
- [Campaign Setup & Configuration](https://resources.tradablebits.com/support/engagement-campaigns?hsLang=en#campaign-setup-configuration)
- [Campaign Styling & Design](https://resources.tradablebits.com/support/engagement-campaigns?hsLang=en#campaign-styling-design)
- [Lead Generation Campaigns](https://resources.tradablebits.com/support/engagement-campaigns?hsLang=en#lead-generation-campaigns)
- [User-Generated Content Campaigns](https://resources.tradablebits.com/support/engagement-campaigns?hsLang=en#user-generated-content-campaigns)
- [Music Campaigns](https://resources.tradablebits.com/support/engagement-campaigns?hsLang=en#music-campaigns)
- [Quiz Campaigns](https://resources.tradablebits.com/support/engagement-campaigns?hsLang=en#quiz-campaigns)
- [Events/Ticketing Campaigns](https://resources.tradablebits.com/support/engagement-campaigns?hsLang=en#events-ticketing-campaigns)
- [Game Campaigns](https://resources.tradablebits.com/support/engagement-campaigns?hsLang=en#game-campaigns)
- [Voting/Polling Campaigns](https://resources.tradablebits.com/support/engagement-campaigns?hsLang=en#voting-polling-campaigns)
- [Prize Giveaway Campaigns](https://resources.tradablebits.com/support/engagement-campaigns?hsLang=en#prize-giveaway-campaigns)
- [Incentivize Campaigns](https://resources.tradablebits.com/support/engagement-campaigns?hsLang=en#incentivize-campaigns)
- [Best Practices for Campaigns](https://resources.tradablebits.com/support/engagement-campaigns?hsLang=en#best-practices-for-campaigns)
- [Campaign Reporting](https://resources.tradablebits.com/support/engagement-campaigns?hsLang=en#campaign-reporting)
- [User-Generated Content (UGC)](https://resources.tradablebits.com/support/user-generated-content-ugc?hsLang=en)
- [Fan CRM](https://resources.tradablebits.com/support/fan-crm?hsLang=en#main-content)
- [Tags](https://resources.tradablebits.com/support/fan-crm?hsLang=en#tags)
- [Filters](https://resources.tradablebits.com/support/fan-crm?hsLang=en#filters)
- [Exports](https://resources.tradablebits.com/support/fan-crm?hsLang=en#exports)
- [Fan Profiles](https://resources.tradablebits.com/support/fan-crm?hsLang=en#fan-profiles)
- [Sales](https://resources.tradablebits.com/support/sales?hsLang=en#main-content)
- [Data Library](https://resources.tradablebits.com/support/sales?hsLang=en#data-library)
- [Trackers](https://resources.tradablebits.com/support/trackers?hsLang=en)
- [Idols](https://resources.tradablebits.com/support/idols?hsLang=en)
- [Integrations](https://resources.tradablebits.com/support/integrations?hsLang=en#main-content)
- [Outgoing Integrations](https://resources.tradablebits.com/support/integrations?hsLang=en#outgoing-integrations)
- [Incoming Integrations](https://resources.tradablebits.com/support/integrations?hsLang=en#incoming-integrations)
- [Salesforce Marketing Cloud](https://resources.tradablebits.com/support/integrations?hsLang=en#salesforce-marketing-cloud)
- [Ads](https://resources.tradablebits.com/support/ads?hsLang=en#main-content)
- [Meta (Facebook & Instagram)](https://resources.tradablebits.com/support/ads?hsLang=en#meta-facebook-instagram)
- [Google Ads](https://resources.tradablebits.com/support/ads?hsLang=en#google-ads)
- [Snapchat](https://resources.tradablebits.com/support/ads?hsLang=en#snapchat)
- [TikTok](https://resources.tradablebits.com/support/ads?hsLang=en#tiktok)
- [Spotify & Reddit](https://resources.tradablebits.com/support/ads?hsLang=en#spotify-reddit)
- [Messaging](https://resources.tradablebits.com/support/messaging?hsLang=en#main-content)
- [SMS](https://resources.tradablebits.com/support/messaging?hsLang=en#sms)
- [Email](https://resources.tradablebits.com/support/messaging?hsLang=en#email)
- [Push Notifications](https://resources.tradablebits.com/support/messaging?hsLang=en#push-notifications)
- [Instagram](https://resources.tradablebits.com/support/messaging?hsLang=en#instagram)
- [Automations](https://resources.tradablebits.com/support/messaging?hsLang=en#automations)
- [Custom Networks](https://resources.tradablebits.com/support/messaging?hsLang=en#custom-networks)
- [Octane](https://resources.tradablebits.com/support/octane?hsLang=en)
- [FAQs](https://resources.tradablebits.com/support/faqs?hsLang=en)
[](https://tradablebits.com/)
Copyright © 2026, Tradable Bits