| How do I send an auto-response email to someone who fills out my Google docs form? | i.a.nixon | 5/9/11 2:16 AM | I have created a Google docs form and would like an automated email to be send to the responder, as soon as they press 'submit'. Anyone got an idea? |
| Re: How do I send an auto-response email to someone who fills out my Google docs form? | yachadhoo | 5/10/11 7:41 PM | Sure...I just played around with this and got it to work. :) 1) On the spreadsheet where the form submissions populate, put this formula in a cell in row one in a column to the right of all data being populated by the form, say cell X1: =indirect( |
| Re: How do I send an auto-response email to someone who fills out my Google docs form? | Gill | 5/11/11 3:59 AM | Thank you! |
| Re: How do I send an auto-response email to someone who fills out my Google docs form? | samiam344 | 5/13/11 11:35 PM | I tried to run this on my spreadsheet but get an error Cannot call method "getRange" of null. (line 7). i was able to get email address to appear in J1. here is what i am running |
| Re: How do I send an auto-response email to someone who fills out my Google docs form? | yachadhoo | 5/14/11 5:23 AM | samiam344,You line 7 is:var email = sheet.Range(1,10,1,1).getValue(); Instead, as in the example, try:var email = sheet.getRange(1,10,1,1).getValue(); Also, make sure that there is a valid email in J1 when you attempt to run this script. In fact, |
| Re: How do I send an auto-response email to someone who fills out my Google docs form? | yachadhoo | 5/14/11 8:35 AM | Ok, I modified my original script1) Added instructions2) Added a test to verify if the email submitted is of a valid format, and now it only sends an email if the email address is of a valid format3) Added a confirmation notice into the Column where |
| Re: How do I send an auto-response email to someone who fills out my Google docs form? | zabethel | 5/14/11 3:18 PM | Thanks. I got this to work. From the first set of instructions I got the same line 7 error message until I realized I had put my document name in as the sheet name. *face palm* |
| Re: How do I send an auto-response email to someone who fills out my Google docs form? | Teresa C. | 5/16/11 2:37 PM | @yachadhoo, thanks for helping out here! |
| Re: How do I send an auto-response email to someone who fills out my Google docs form? | yachadhoo | 5/17/11 4:08 PM | No problem. ;) For anybody who happens upon this thread by way of a search... In response to another similar question, I just modified the above script to send a personal email to YOU based on a particular response to one of the questions on the for |
| Re: How do I send an auto-response email to someone who fills out my Google docs form? | bartagreda | 5/19/11 8:15 AM | @yachadhoo HI I added your script to my excel sheet. I know that the inderect function is working because everytime my spreadsheet gets updated it changes but the concern is its not emailing. i made sure the trigger is confiugred but the notificatoin |
| Re: How do I send an auto-response email to someone who fills out my Google docs form? | yachadhoo | 5/19/11 2:06 PM | bartagreda,You skipped the step in bold, in my instructions: |
| Re: How do I send an auto-response email to someone who fills out my Google docs form? | yachadhoo | 5/19/11 2:11 PM | Here is the comment-free version of the script that you can copy and paste: |
| Re: How do I send an auto-response email to someone who fills out my Google docs form? | samiam344 | 5/21/11 1:58 PM | Finally got it to work thanks. |
| Re: How do I send an auto-response email to someone who fills out my Google docs form? | lmt125 | 5/25/11 10:09 AM | Hi, this script looks great. I am trying to add it to my form but it is not sending an email nor populating anything like Email Sent etc...here is what I put in the script...Also the Formula =indirect(E,counta(A:A1)) I am putting in column M which is |
| Re: How do I send an auto-response email to someone who fills out my Google docs form? | lmt125 | 5/25/11 11:25 AM | Ok, I got it to return the email address on the form...but not much else...doesn't seem complicated. |
| Re: How do I send an auto-response email to someone who fills out my Google docs form? | yachadhoo | 5/25/11 1:15 PM | lmt125, You changed a few things in the script that were not suppose to be changed. I am thinking that my instructions must not be very clear. Therefore, I am writing them again from scratch, for the sake of others who happen upon this thread. They |
| Re: How do I send an auto-response email to someone who fills out my Google docs form? | yachadhoo | 5/25/11 4:35 PM | OK, here is a simple version for anybody interested in automatically sending a customizable form completion email to someone who fills out your form. Please follow the instructions exactly as written: 1) Select and copy the entire script below. Sel |
| Re: How do I send an auto-response email to someone who fills out my Google docs form? | lmt125 | 5/26/11 4:41 AM | Thank you...I'll try this in about an hour when I'm by my computer and let you know...thanks for your help. |
| Re: How do I send an auto-response email to someone who fills out my Google docs form? | lmt125 | 5/26/11 5:42 AM | Great, it sends the email...the only question is on the spreadsheet where I put the formula =indirect(E &counta(A1:A)) I put this in M2, am i supposed to put in M1? How will it copy to the rest of the cells...I get the email address there, not "Email |
| Re: How do I send an auto-response email to someone who fills out my Google docs form? | yachadhoo | 5/26/11 7:15 AM | lmt125, If you followed the instructions in the post 3 above this one, you no longer need the indirect function at all. You can safely delete it from M2 altogether. If you want the "Email Sent" message to appear in Column M, then add the following |
| Re: How do I send an auto-response email to someone who fills out my Google docs form? | HappyJess | 5/26/11 7:55 AM | Yachadhoo - I knew absolutely nothing about scripts before I read this thread. You've really helped me A TON, and made my job a whole lot easier. Thanks so much! Here is a new problem for you though: I set up three separate scripts for the same fo |
| Re: How do I send an auto-response email to someone who fills out my Google docs form? | lmt125 | 5/26/11 8:32 AM | Yachadoo, Thanks so much for all your help...am very new to html and I just copy and paste, but was able to add spaces and links to my confirmation email...learning little by little! |
| Re: How do I send an auto-response email to someone who fills out my Google docs form? | yachadhoo | 5/26/11 8:48 AM | "Any suggestions?" -HappyJess Well, I am not sure how you have set this up, exactly... Because the examples I have provided in this thread were designed to avoid this very problem you seem to be having. If you want to share the spreadsheet, I'd b |
| Re: How do I send an auto-response email to someone who fills out my Google docs form? | yachadhoo | 5/26/11 8:50 AM | "Thanks so much for all your help...am very new to html and I just copy and paste, but was able to add spaces and links to my confirmation email...learning little by little!" -lmt125 No problem...and be encouraged: I am fairly new to all of this, |
| Re: How do I send an auto-response email to someone who fills out my Google docs form? | raulpino | 5/31/11 12:02 PM | Teresa: I have used the instructions at the top of this page. Created the script, changed the variables to fit my spreadsheet, but I get "invalid email" every time I submit a test. I'm a missing something when using the regular expression? can I jus |
| Re: How do I send an auto-response email to someone who fills out my Google docs form? | yachadhoo | 5/31/11 12:12 PM | raulpino, Instead of using the instructions at the top of the page, try using the following. This is a simplified version with easier to understand and more explicit instructions. ;) = = = = = = 1) Select and copy the entire script below. S |
| Re: How do I send an auto-response email to someone who fills out my Google docs form? | raulpino | 5/31/11 12:54 PM | Thanks! It worked. Now that I see the email being sent, is there a way to assign the email to come from a different user, or different domain alias? |
| Re: How do I send an auto-response email to someone who fills out my Google docs form? | yachadhoo | 5/31/11 1:09 PM | = = = The email will always come from the email address registered to the account a user is logged into when writing/saving a script. I don't know of any way to change this. So, if you want it to come from a different user or company email, then yo |
| Re: How do I send an auto-response email to someone who fills out my Google docs form? | raulpino | 5/31/11 1:46 PM | Thanks, yachadhoo. I am waiting or my MX records on the secondary domain to finish validating so that I can have a different user/domain send the auto-reply email. Thanks again for your help. |
| Re: How do I send an auto-response email to someone who fills out my Google docs form? | lmt125 | 6/1/11 6:36 AM | What if I also want it to send me an email with the data the person input to the form? How can I do that? |
| Re: How do I send an auto-response email to someone who fills out my Google docs form? | Yirba | 6/3/11 4:33 PM | @lmt125: This is fairly straightforward. 1. Go to Google Docs - Home <http://docs.google.com/> 2. You should see a list of your documents, including your form. Click on the link for your form to open it in spreadsheet (results) view. 3. In the top-r |
| Re: How do I send an auto-response email to someone who fills out my Google docs form? | lmt125 | 6/4/11 5:30 AM | Yirba, thanks for your response but someone else helped me with a script that sends the person who filled out a form a confirmation email ac/dc it sends me an email with the details the person filled out...let me know I can cot the script on to here |
| Re: How do I send an auto-response email to someone who fills out my Google docs form? | raulpino | 6/4/11 8:39 AM | Lmt125: Can you please do so? I was wondering if this was possible. I would appreciate it! |
| Re: How do I send an auto-response email to someone who fills out my Google docs form? | lmt125 | 6/6/11 6:00 AM | Things to change are in bold...make a second sheet in the form that says Email and in there put the auto response things you want it to send also put Body Line 1 etc next to what you write in the Email example A1 says Hello B1 says Body Line 1 for su |
| Re: How do I send an auto-response email to someone who fills out my Google docs form? | dlund100 | 6/9/11 6:36 AM | Imt125 - Thank you for putting up this script. I was looking for something very similiar! I am needing a script that will email the newly submitted data to an email address included in the form. I was able to use yachadoo's script to get an autom |
| Re: How do I send an auto-response email to someone who fills out my Google docs form? | Denis de Castro | 6/9/11 8:14 AM | @ dlund100, could I recommend the work of Henrique Abreu on this ? Available at http://sites.google.com/site/formemailer/form-emailer. Other lighter-weight emailers are available in the script templates (Insert>Script...>Gallery) |
| Re: How do I send an auto-response email to someone who fills out my Google docs form? | yachadhoo | 6/9/11 11:32 AM | dlund100,I am very much a beginner in scripts compared to Henrique Abreu, so the reference that Denis refers to might be of much more value. However, it might not be easy to adapt Henrique's scripts for your purposes. However, if you were able to fo |
| Re: How do I send an auto-response email to someone who fills out my Google docs form? | NHGoldenEye | 6/20/11 10:18 AM | ok so i have the following code but all i get is the header data and not the actual submitted data? what am i missing... all i want is the form data submitted to my email address.. |
| Re: How do I send an auto-response email to someone who fills out my Google docs form? | lmt125 | 6/20/11 11:58 AM | NHGoldenEye, The last line MailApp.sendEmail I don't think you were supposed to change that... |
| Re: How do I send an auto-response email to someone who fills out my Google docs form? | lmt125 | 6/20/11 12:00 PM | You're also missing this: //Send mail to Admin or yourself |
| Re: How do I send an auto-response email to someone who fills out my Google docs form? | lmt125 | 6/20/11 12:02 PM | Also this is sending a confirmation email to the person that responded which is what the second sheet of Email if for...I think you just need to put this code to have it just send you the response info... |
| Re: How do I send an auto-response email to someone who fills out my Google docs form? | NHGoldenEye | 6/20/11 12:15 PM | yea i dont need to send a copy to the submitter just myself/admin so i removed that unneeded portion. I changed the VAR's to hard coded because i didnt need to manipulate them as variables , just use the raw data. |
| Re: How do I send an auto-response email to someone who fills out my Google docs form? | NHGoldenEye | 6/20/11 12:17 PM | i think the issue has to do with the loop and the 'subMittedData' seams that this VAR is not populated correctly because the data i get back says "undefined" |
| Re: How do I send an auto-response email to someone who fills out my Google docs form? | lmt125 | 6/20/11 12:23 PM | I don't know what to tell you...it works perfect for me... |
| Re: How do I send an auto-response email to someone who fills out my Google docs form? | NHGoldenEye | 6/20/11 12:54 PM | i tried the code from above, changed the right elements and it still did not work... :( |
| Re: How do I send an auto-response email to someone who fills out my Google docs form? | lmt125 | 6/20/11 1:05 PM | Why don't you contact this guy...he wrote the script for my form...really nice...https://sites.google.com/site/appsscripttutorial/contact-me |