Hey there stranger!
Sign up to get access.
About this Tutorial
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.
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.
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.
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.
Find "Entry Number" for Bookmarklet
Let's Make a Bookmarklet!
Redirect a Domain to a Google Sheet
How to Download a Sheet as a CSV with a URL only
How To Export Your Beautiful Sheets to PDF
Sheet Stories / Video Notes + ADDED: Email Notifications
ChatGPT Clone in Google Sheets Part 2
Why Different Cell References in AI Integration in Sheets?
Show Sheet Tabs Based on Edit
Add Title Case to Google Sheets
How to Power Testimonials with Google Forms and Sheets
Getting Started Coding in Apps Script
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
Hold a Giveaway Raffle in a Google Sheet
Embed a Headline in a Website from Google Sheets
Capture Emails from Website Form to a Google Sheet (Without Zapier)
Quickstart Tutorial OpenAI API in Google Sheets
Create a new Spreadsheet from just a Name in a Sheet.
Bjarne Asks: Can I show the Last Time of the Last Edit in a sheet?
Email Yourself a Cell from a Google Sheet, Every Day
OpenSea Data Inside Sheets
Create an Email Campaign Stats Calculator
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
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
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.
Password Protecting Data In a Google Sheet Part 2 The Basics
Benoit Asks: How to Convert Case
Learn to Code in Google Sheets, For Programmers
Add a Checkbox to Turn on Dark Mode
Write Your First Script
Find Keywords in Any Column. Create quick search dropdown to find keywords
Basic CRM - Add a Powerful Script To Move Row Based on Status
How To Improve: 1,000 Business ideas: Business Idea Generator
Let's Make a Bookmarklet!
Troubleshooting Bitly in a Google Sheet Script
Unique Features - Design a Better Dashboard Part 2
How To Set Up Stripe Webhook to Google Sheets with Google Script
How to Edit a Macro
Sheet Stories / Video Notes + Clear 24 Hour Old Videos
Add A Timestamp to Task Lists (without Now Formula)
Make your Custom Functions Like Native Functions | Custom Function Autocomplete
Create a Changelog Between 2 Cells Custom Function | To learn Double For Loop
New Syntax for WhatChanged Formula in Google Script
How to Record Macros
2 Ways to Delete Lines Quickly (CAREFUL, it's a script!)
Deep Inside Dark Habits Google Script
How to Trigger Macros Daily
5 Ways to Create Coupon Codes | Create UUIDs
Create a Radio Button From Checkboxes Using Google Apps Script