“Guys today s video. I m going to show you how to embed a google google form to gmail so basically here. I have a google form and you have ways to share your phone. But if you want to embed it i frame to the gmail since the iframe is is not allowed in gmail so you have to find another way so google have a builder of functions in the form so you can send send a email to someone and with the form included in this email.
So this is a way you can do manually one by one okay so if you hit send you have got an email like the size like this okay. So this google form so this form is embedded in your email. But this is nora iframe is not a friend which have that code so this tip is nora i frame so i d like to show you how we can do it in the apps script okay so you can send an email with google form in your in your script. So here is the script file.
So basically i can sense a form email from this spreadsheet. Learning for doby. Okay here have a function to send form click on so enter. Email address.
So you can add a matter. People. Here. Just separate the emails by comma okay.
So click ok. So now the email has been sent and if you go to my boss. You have another email so so as you can see here this email is powered by apps script. So it s very similar so it s very similar to this one you just send it from from the forum yourself ok so there s a functioning.
Very similar okay so if you can use this in the apps free apps..
Script you can do much more in your program ok so you compare this to emails they re very similar so you can customize this this email ok let me show you how to do this in apps. Script as a new file. So you can you can do it in spreadsheet. You can also to link in google form or other google product in this example.
I ll show you how to treat in apps. Script let me close this one in the name it embedded google phone to gmail. Okay screaming editor let s go to the script editor you rename this project to pad it teach me now then zoom in a little bit so let s do some variables for you i rushed for a spreadsheet. Okay so as usual the first function is work on open function to pizza menu okay so dy.
Great menu name it script and add item. The caption message and form function will be sent for 13y. Okay. This first instant.
Let s hear this self cell function cell phone. So let s do a four got a variable for email is called email. Well so i will callicles email from the users forms and user. So i use browser top input okay.
Title will be send google form so this is a message for users so email addresses break. It by commas. A comma okay so part in here. I will say button even ui patterns.
I ll cancel all right so here. I m come to collect the email address and left foundation. Here. So if email is not equal to cancel and email index all at biggerson s their world.
So this is to make sure the valid email address is entered to the input box. Okay then we are to the send email. So mail app or send email. So this release six.
We are using email subject. Okay. The subject last object let s call this anybody male body body well empty and auctions. So the sausages will be so weapons to use html body.
That s called as create this team everyone for html buddy. So it will be hdl mail service create edit email from file. So to create html template from file. So the found name will be called template and value page.
And the cat content. So let s call this section on body here. And here we need to create a html file alright so name. It a template.
So we ll send them here alright..
So now. This is there is there is nothing in this body. So it will be a so i have something here in city. So let s just give a sentence makeup whore.
I asked script so save this and let s try to run this function okay okay okay setup stand for so there is running it is the first time so you have to authorize that s why you okay so in changing my dress okay so it s done i should get an email all right so this is an email since there is only one sentence in this html file. So in mind my body. I only have this powered by apps script. So next step.
I need to add the google form in this body. So let s go to so you go to any form. Okay any form and you be sent and here. It s just your email address.
Here and you have to check this so include the form in the email okay click send click this one so now i carry this one so this one s from google. Okay so you need to inspect this webpage. And you re going to find is a to dig. So here.
This tip is this is highlight okay. So this tip is will be present this google form you just need to copy this code so copy element. And then pass the code here in your in your html file. Okay and save it so you now you can try to run this function call right let s say join dysfunction.
So you click still..
Running you okay you have to add an email address all right so. It s done okay. Now you get an email like this. So.
We use another subject like embedded and bury people form which email tutorial so this one was sent from apps script all right so with this sentence here and with a google form in your email. Even when you re in my body. Okay so just a few lines of code. This is very simple.
But i think that this will be very useful for some users to like to embarrass. A group form tutor to the email body. So they can send someone they send the client for this form. Okay.
So i see that s it for this tutorial and and if you need to see the code you only need to so i will share this file to you and you will need to go to file and make a copy. Okay once you make a copy to your google drive you go to the tools scripts. A script editor and you you can find the codes. There alright you okay and that s it thanks for watching.
Thank you for watching all the articles on the topic GAS-019 Embed Google Form to Gmail . All shares of newyorkcityvoices.org are very good. We hope you are satisfied with the article. For any questions, please leave a comment below. Hopefully you guys support our website even more.
“This is Ashton from Shenzhen China.nnGmail: [email protected]: yunjia_feinTwitter: https://twitter.com/YunJiaFeinInstagram: https://www.instagram.com/polymusicnApps Script Support: https://goo.gl/forms/GhJC63annAtIsif72nnScript file:nhttps://drive.google.com/open?id=1waDBgadaF6UZ7F6r2r915bAPqoCl2Ag5VLHLnJ3pPE8”,