How to Get People to Fill in Google Forms Faster

0:00 I'm going to share with you today this really deep Google form trick from Google Sheets that will help you get people to fill out your Google forms faster, easier. Basically, it's taking a pre filled link, including their email address, and then sending that link to them. So, when you normally send a Google form , you're going to send this Google form , you're going to copy this link, and you're going to send it to everyone and say, Hey! Fill this out. Well, one way to get people's email addresses very easily is that you can go to settings and in responses you say collect email addresses . You can do verify if they are all in the same domain and they are going to sign in to Google or you can have a responder input here. But I'm going to show you an even easier way, especially if you're going Better Email Form on Google Sites How to Send Google Forms Entries Automatically with Apps Script Send Better Email When Google Form Filled Out OnlySheets

0:46 to be emailing everybody the form. Here we go. And that is the trick that I'm going to reveal today. So we're going to select do not collect, um, and make it super easy. So we're going to add a column here to the right called prefilled link. We're going to go up to more options and we're going to select this get prefilled link. Here we're going to put in any dummy email address and get link. We're going to copy this link. Let's go back to our sheet and look at this link. This link has the same URL as the form, but then it has this extra stuff. It says at and entry, and it has an entry number , equals dummy at gmail. com. You see this dummy at gmail. com. Now, anything we enter here, enter something at gmail. Send Better Email When Google Form Filled Out How to Validate Email Addresses for FREE in 17 Minutes Embed Email Form and Name Form into Website to Google Sheets Create an Embedded Email and Name Form on Google Sites to Google Sheets

1:35 com. Now I'm going to click this link. And see it, enter something at gmail. com. It entered it for me. So let's leave that. And all I have to do is enter someone's email address there. So how do we do this? We'll take this text, go to the beginning, we'll put equals, we'll put it in quotes, and then we'll do an ampersand, and wherever their email address is in our database, in our sheet, we're going to enter it there. So now each of these people I can email Emily with this pre filled link. I can email Sarah with this pre filled link, and when she opens this form, it will already be filled out for them. This is really cool. Why does this make people fill in sheets faster is because now instead of two answers , I only have one. Embed Email Form and Name Form into Website to Google Sheets Simply Email Yourself From a Google Sheet Embed Email Form and Name Form into Website to Google Sheets Create an Embedded Email and Name Form on Google Sites to Google Sheets

2:20 Fifty percent faster if it's only a couple questions like, what do you want for lunch? But also consider, even if you have 10, 12 more questions, having the first one filled in makes people fill it in much faster and easier, right? They don't have to even think about entering their email. It's done. Okay. Get onto the question. This is really cool. These prefilled links are really awesome. It's one of those things in Google sheets and Google forms that is a pretty deep cut, but I absolutely love it. I think it's incredibly useful for this kind of thing to gather information from people faster. If you're into using Google sheets to the maximum of your ability and you want to go further, consider subscribing here on YouTube to better sheets. Send Better Email When Google Form Filled Out How to Send Google Forms Entries Automatically with Apps Script Send Better Email When Google Form Filled Out Better Letters