Academy ↓
Hey there stranger!
Let's Make a Bookmarklet!
About this Tutorial
Video Transcript
You're gonna get the form url, then you're gonna get the entry numbers. I'll show you how to do that with the Chrome spec tool. You'll edit the JavaScript code that I provided and you made a bookmarklet. Let's do it. New sheet. So sheet new and typically some use cases that this bookmark is good for is collecting URL in information.
That's what we're gonna do. So typically gather 10, 20, 3000 websites, maybe write a little ion about that, right? Every single week I use zip.
Created lists of things like a hun a hundred top X or a hundred top y top companies. And I'll find their website and I'll want to copy and paste their website. And so typically let's just call this bookmarklet. So typically you'll have a row url. You'll have maybe the company name or something like that, and maybe a description, right?
And your boss or someone or might yourself, you might wanna fill this out and you're gonna come back and you're be, you're coming here and you're copying and pasting three. Things, every time you're filling out a row and say you're like an SEO search for seo, you're looking for SEO companies, I don't know, agent in Dallas.
And you, oh my God, there's gonna be so many, right? Dallas SEO geek and here there's even lists of them, right? Top 29 SEO companies. And you're gonna go grab, URLs and companies and you're gonna have to find, you're gonna have, do a lot of copying and pasting, but what you can do as well, let me find out if there's any.
This is probably a really bad example to this before. So let's look at this. Yeah, and so you've visited way, I'm gonna just throw them. In another call and you're like, oh, okay, three agency. Okay, put Laurel in here, thrive. This is already taking me a long time and I don't wanna do this. Like I don't wanna be sitting here and copy and pasting this when I really should be like looking at this agency.
Vista great, I'm spending time copying and pasting io Vista when we can make a bookmarklet and get this information really quickly. So what bookmarklet, so up here you can see I have actually a few of them, because I use this often, they are bookmarks. But instead I'm gonna do control. I'm gonna show you this, I'm gonna edit.
Instead of a url. What it is it's a JavaScript code and it's one line of JavaScript. It literally starts JavaScript colon, and then it has some code in it. And you can see here this is https docs.google/forms, right? And so what that does is, actually I can show you this was here, I'll show you from my newsletter.
I'll put it. This is a same thing. Click it goes to this url, which is the form, and look at it fills in the URL for me, thrive in an literally, all I have to do is clean that up a little and now I can write some notes. Right now. How do we do this? That saved a lot of time. How do we make this? We need the code.
Let me share with you the code. You might be using this here. I actually had some other use cases here written down. If you wanna research competitors. I curated a newsletter with this. You might wanna collect YouTube videos. Very quickly. You wanna go through search for them over a certain period of time.
You're copying and pasting YouTube videos, links, you're copy and pasting titles. Some stats, like you can save a lot of time by just going to the YouTube link and clicking this. So let me show you the code. It looks like this. JavaScript colon, window, location dot, hrf, and then a whole bunch of other stuff.
But let me break it down for you. Okay. So first off, we just wanna tell the, tell it like it's not a url, it's JavaScript. This window location, HF just says where this window. Window meaning your browser is, where is, what is the URL that it's on? That's all it's saying. Or, and what we're doing is we're saying let's switch that to the form.
So really just switch it right. That's what equals is. Before that, what we're gonna do is when we append to this normal form, if we just go to the form, it's the form, right? And we need to fill it out still. But if we append this, Question mark. U S P equals PP underscore url. It means we are pre-populating it.
This PP stands for pre-populating it. So what we wanna do is pre-populate it with some two things. One, we wanna populate it with the URL we're on, and we wanna use the title of the website also. Okay, so window location eight, right? That was just like where we are in this one we're saying. This is where we want to go, but in this one, we're just grabbing where we are now and we're gonna put it to entry 9 7 99.
I'll show you how to find this. We're saying first put the URL here and whatever the title of the document of the webpage we are on. What is the title of the webpage? Put that in form. This form form entry here. That's it. It's just taking those two numbers. Those two entries and pre-populating them to this form.
Pretty simple, right? So all we need to do is get the form url. We need to find out the entry for each of the two that we want to fill out, right? And so what do we do? Let's go do that. So let's create a new form instead of this, right? We want to, I think it's insert form. Let's create it.
Alright, it's gonna take a second. We're still here. It's just gonna take a second to create. Ooh, that is a big picture. Me. We don't wanna speed it up, we just want to get a short answer. We want, let's say u URL girl. Sure. Copy that. We don't want u url, we want company, and we don't care about data validation.
Please. Let's back. Short answer let's say description or notes. You can say whatever you want here. Say, call it description and keep that as a paragraph. Cool. That's it. That's all we need in the form. And we're gonna send, and all we need is this link here, right? View, form. Form. And right up to this question mark to me.
Take this code and I'm gonna, Put it down here. Take this url. Go to the URL right here. Up until this question mark, right up until this question mark, and I'm gonna re do it. Take out this I'll you, this U S P I wanna keep that U S P or u S P equals P U R. I wanna keep that, but the other one I didn't want.
Okay, so I got this new url. Now I need to find the entry. So what I wanna do is I went to, with that, I want to go to the public let's say preview. And this is gonna get a little complicated. All I'm gonna do is control click, or right click inspect, right on the url, inspect, and it's open up this Sidebar.
And if you notice, actually we can't even see it here, but if you command F entry, there it is. So now we see this entry. We just control F or command F search for entry. If we click on this, we see this answer is this entry number. So we double click on it and we. Use a formula. So we want that to be actually Euro url.
So we paste that command, shift command V to command to paste it as that. And then we want to get the company ones. Let's look at the next entry. See, there's, if you look at the number of entries when we did the command F, it's only three cuz there's three. Entries here. So we get the next one. It's company.
Let's do that co copy. We're gonna check it too, right? We're not gonna just assume this is correct. We are gonna check it. So that's all we needed, right? We have the url, we have the two entries that we need. Now we're gonna copy this and what we can do is we can bookmark any page we want. So we just do command D.
I'm gonna say Test book, far Click and let's see. Far done. What I can also do is take this URL if it's actually far down here, right? And I can drag it up here, but I can also, let me just delete that. I can also take this URL and drag it down here and I can make it there. And what I do is I control click edit, and in this URL, command A and paste our JavaScript.
Nice save. And all it says is bookmark, right? So let edit that. So let me do that again. So I'm gonna grab that. I'm gonna edit, I'm gonna take the url, delete it, paste hours. I'm gonna call it test book. Mark it. Okay. Save it. And now where, whenever we go to say this thrive. Let's go back here. I can just click this Bookmarklet.
And let's see what happens. Thrive Agency is in the url, digital Thrive Internet Marketing Agency. I can write anything I want there. Submit. Let me go over here. IO Vista. Click on the test booklet. Io Vistas is in the url. They, this is interesting. They don't have the company name here, so I just need to type it here.
IO Vista. Submit. Now, where do those go? I'm gonna back to my here, I'll move my picture. Oh, I have so many pictures, but it's on this tab here form responses. And here they are. And I have them all. And now that's way quicker to grab all that information than copy and pasting it in. That's it. That's how you create a book market.
Click. Thanks for watching.
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
Find "Entry Number" for Bookmarklet
00:07:26
Create a Vote Button from Google Sites to Google Sheets
Let's Make a Bookmarklet!
00:12:37
Redirect a Domain to a Google Sheet
00:01:57
How to Download a Sheet as a CSV with a URL only
00:04:22
Embed Email Form and Name Form into Website to Google Sheets
Add NPS to Your Google Site
Add Tasks to Google Tasks From Google Sheets
Create an Internal Google Sheets Add-on
How To Export Your Beautiful Sheets to PDF
00:04:06