if i created a form for people to simply submit their email address, how could i send an automated email reply back with an attachment I have stored in google drive? nothing i am doing is working in scripts. any suggestions would be helpful! thanks!
@@BetterSheets thanks for the response. I am trying to automatically send a pdf i have stored on drive to the emails when they come in, but nothing is happening. any thoughts? I could copy/paste the code if it helps
@@PillarsofthePast101 try using just a URL of pdf format. bettersheets.co/tutorials/export-your-google-sheets-to-pdf-with-a-url.export-your-google-sheets-to-pdf-with-a-url
Hi, tried your script and it works on my end. Would like to know how if I want the listing of the columns in the email follow the arrangement of the columns in Sheets
Yeah I am trying to follow a long and you are too fast I have no idea where you got your info from because it is not connecting to my sheet or my contact form it is kind of frustrating. I don't know what I am doing wrong. I created a sheet for no reason because it did not work just to see this I am frustrated
the trigger will be added via the Trigger section of Apps Script and you just need to select the function to run, and then the trigger which is on form submit
@SkykingErnest, you don't need to comment if you do not find the video useful. That means the video was not meant for you. The video was awesome @BetterSheets.
Hello, for the select event source in trigger "from sheet" isn't listed.
Is your apps script inside a google sheet?
HI, do i just type in the email of who it goes to i.e i own the sheet but want it to go to another email
Yes
@@BetterSheets not working? ive copied the script off the screen but my experience is limited. do you have a copy?
if i created a form for people to simply submit their email address, how could i send an automated email reply back with an attachment I have stored in google drive? nothing i am doing is working in scripts. any suggestions would be helpful! thanks!
You will need to trigger using installable trigger on form submit.
@@BetterSheets thanks for the response. I am trying to automatically send a pdf i have stored on drive to the emails when they come in, but nothing is happening. any thoughts? I could copy/paste the code if it helps
@@PillarsofthePast101 try using just a URL of pdf format.
bettersheets.co/tutorials/export-your-google-sheets-to-pdf-with-a-url.export-your-google-sheets-to-pdf-with-a-url
Hi, tried your script and it works on my end. Would like to know how if I want the listing of the columns in the email follow the arrangement of the columns in Sheets
It depends on what you mean by arrangement. Please elaborate more and I'd be happy to answer!
where can I get the script?
i keep getting that the e.namedValues are not define error I don' tknow what I am doing wrong. Might be something connecting to the damned thing
Members at BetterSheets.co get scripts and sheets with every video.
Are you testing it in apps script? If so you will have empty variables.
Yeah I am trying to follow a long and you are too fast I have no idea where you got your info from because it is not connecting to my sheet or my contact form it is kind of frustrating. I don't know what I am doing wrong. I created a sheet for no reason because it did not work just to see this I am frustrated
I can't seem to get it to say spreasheet in the trigger part is that a problem because I am trying
I can't help you much without knowing what errors you may be getting.
the trigger will be added via the Trigger section of Apps Script and you just need to select the function to run, and then the trigger which is on form submit
No good explanation from this video you made
Are you looking for something else?
@SkykingErnest, you don't need to comment if you do not find the video useful. That means the video was not meant for you. The video was awesome @BetterSheets.