Academy ↓
Hey there stranger!
Troubleshooting Bitly in a Google Sheet Script
About this Tutorial
Video Transcript
So first off, the number one problem is if you, um, on this data DB or database tab, if you change the unique code at any moment, the prior unique code link will not work. So if I, um, I'll, I'll. Show you an example here. This one works perfectly fine. We'll make sure it adds a click to here. There it is. Four.
Right? And if I want to for some reason add a period, right? Better sheets.co. Um, I actually should have, so this doesn't work. So I guess you don't, can't use any dots. Um, let's just change it to better sheets and we click over here anytime now.
There it is. So our script is there and that works. Now
see, it's redirecting and. it works. Oh my God, it's so slow. Sorry. So that works, right? So what if I copy this link? So now this link is with better sheets as the code, but if I add CO right now and I use the other link, the Better Sheets without the.co. , this is going to be what happens. Error can't read property zero.
So, um, this may be fixed in the code. Um, I might add like a message here that says like, if there's an error, blah, blah, go. Hey, there's an error. Sorry about that. W let this person know, or you might be able to add, uh, what I might do here. Is, I might also add like a, a email functionality that says, like pings me and says like, Hey, somebody tried to use a link that it, they weren't supposed to check it out.
This is the information I might add. Stuff like that. Um, uh, I won't do it right now, but like that, those could be some ways around it. Like if there's an error, just give the user, here's an error. There's a real error. And like, not this, like give them a message, like a nice html or direct them somewhere. Um,
But yeah, just double check that your codes are all the same and you, you're not changing them consistently and you're not using those pass links somewhere else. So the other thing you might want to do is you might wanna change the tabs names for some reason, right? Like this settings tab, you might already have a settings tab, and you don't want to use like B one for this.
So you can go into the code yourself for when you copy it on your. and I'll show you where to change things. So if you want to change the settings tab, just change the name here as well. So whatever you change the settings name to go into the code and change it here. This is on right now, it's on line 14.
Um, again, you can get to the code by going to Tools Script editor, uh, right there and you'll be able to get to, uh, Uh, right now it's on line 14, but we'll, it'll, I'll say this, change this if you change the settings tab name. Now, if you wanna change the DB name, you have to scroll down a little bit more, and right now it's on line 33.
And it says, change this. If you change the DB tab name. So you might wanna name this actually database. You might want to name this, uh, your URLs or links, something that's more descriptive for your team or yourself. If DB doesn't work for you, just change DB right here and change and obviously whatever, change it to whatever you change.
DB tab two. Um, the other thing is if you have a settings tab already on a sheet and you're just trying to add. Um, sort of link tracking to that sheet. And for some reason you already, you, you're using B one for, for something, and you have to move down where you're checking for it for this, um, this url, right?
Uh, here's what you do, here's where you go and change that. So right in, where is it? Um,
What do you have to change it?
This is actually really funny. Do you have to change it anywhere? One second. Oh yeah, here it is. Okay, so let me add this, uh, change this if you need to change the B one location on setting steps. So again, if you want to change settings name, change it here, but this get range one comma two, that is B one.
So the one is rope, so it's row. Uh, and column two. So the two is B and the B one, the one of B one is one. So you name this, uh, you can name this, you can actually do B one here, or, um, in this case I just did one, two. Um, if you want to change it to C three, it'll be three. Three. If you wanna change it to a four five, it'll be row five, so five one.
So you just have to know. Right here is where we get the, um, that URL of the web app. Um, so it's one comma two for B one and just change that to whatever it is, wherever you want to get that URL from. Um, so I'm saving that. And now you will be able to, uh, you'll have this, um, here. So change this if you need to change the B one location and settings.
So those are a few of the things that you might run. If you run into any other issues, feel free to email me. You can reply to gum road emails that you've been sent. You can just email me@andrewkefiapproved.com. Uh, you can also note, um, reply in the Loom video that you're watching this on. I'm more than happy to reply there, especially publicly if you are having an issue.
Other people might be having an issue and I wanna let other people know how to fix that. It is, or let them know it's fixed if I have to go into the code. But yeah, I would also love to see how you want to expand this. Please ask, uh, for things like if you want that error handling, uh, I might be able to add that in later this week or if anyone needs it.
Also, you might not run into any errors, and you might love this and you might use it for another use case. Um, in that case, please enjoy. Have a great one.
Courses
Sheet Stories / Video Notes + ADDED: Email Notifications
00:00:00
Fast FAQS
ChatGPT Clone in Google Sheets Part 2
Create an Internal Google Sheets Add-on
Why Different Cell References in AI Integration in Sheets?
Show Sheet Tabs Based on Edit
Add Title Case to Google Sheets
Getting Started Coding in Apps Script
How to Power Testimonials with Google Forms and Sheets
Seek Errors When Coding Apps Script
Think Like a Programmer: Develop The Mindset of an Apps Script Coder
ChatGPT Clone in Google Sheets Part 1
Embed a Number in a Website from a Google Sheet
Create Navigation Like A Book or Presentation
Add Click Tracking To Your Google Sheets | Bitly in a Google Sheet
00:29:08
Hold a Giveaway Raffle in a Google Sheet
Quickstart Tutorial OpenAI API in Google Sheets
Capture Emails from Website Form to a Google Sheet (Without Zapier)
Embed a Headline in a Website from Google Sheets
Create a new Spreadsheet from just a Name in a Sheet.
00:05:21
Bjarne Asks: Can I show the Last Time of the Last Edit in a sheet?
00:05:43
Email Yourself a Cell from a Google Sheet, Every Day
OpenSea Data Inside Sheets
Create an Email Campaign Stats Calculator
00:35:13
Twitter App Clone in a Google Sheet
Dylan Asks: How to Automatically Delete Rows If Cell Contains Value
Highlight Row as You Move Your Cell Selection
Create a Timer with Apps Script
LinkTree in a Google Sheet
00:11:22
Password Protecting Data In a Google Sheet
Automatic Weekly Backup of Google Sheets
Create a CPM Custom Function (Create Better Calculators!)
Move Entire Row when a Cell is changed to "Yes" - The $75,000 Google Script
00:12:29
What Can You Automate in Google Sheets? Every single trigger available to Google Sheet users
Sync Two Tabs Without ImportRange()
Google Sheets Stories? No! But we'll add timestamped video notes to your google sheets.
00:00:00
Password Protecting Data In a Google Sheet Part 2 The Basics
Benoit Asks: How to Convert Case
00:07:35
Learn to Code in Google Sheets, For Programmers
Add a Checkbox to Turn on Dark Mode
00:05:10
Write Your First Script
00:08:31
Find Keywords in Any Column. Create quick search dropdown to find keywords
00:09:37
Basic CRM - Add a Powerful Script To Move Row Based on Status
How To Improve: 1,000 Business ideas: Business Idea Generator
00:11:20
Let's Make a Bookmarklet!
00:12:37
Troubleshooting Bitly in a Google Sheet Script
00:07:07
Unique Features - Design a Better Dashboard Part 2
00:04:13
How To Set Up Stripe Webhook to Google Sheets with Google Script
00:22:10
How to Edit a Macro
00:08:22
Sheet Stories / Video Notes + Clear 24 Hour Old Videos
00:35:10
Add A Timestamp to Task Lists (without Now Formula)
00:07:44
Make your Custom Functions Like Native Functions | Custom Function Autocomplete
00:17:58
Create a Changelog Between 2 Cells Custom Function | To learn Double For Loop
00:23:26
New Syntax for WhatChanged Formula in Google Script
00:07:14
How to Record Macros
00:06:20
2 Ways to Delete Lines Quickly (CAREFUL, it's a script!)
00:09:53
Deep Inside Dark Habits Google Script
00:18:54
How to Trigger Macros Daily
00:06:58
5 Ways to Create Coupon Codes | Create UUIDs
Create a Radio Button From Checkboxes Using Google Apps Script
00:15:01