I have just found your Digital Inspiration website and have just started to learn Google Apps Script.
I’m wondering if you can help me by pointing me at any examples of Google Apps Scripts that I could modify to do what I want.
I can first summarize this in one abstract statement – "use google apps script to generate an automatic response based on a well defined string in the content of a gmail message"
That’s the basic question. Here is the background on what I am doing and the reason I want to do the abstract statement above.
I have a specific problem that I am trying to solve. Let me describe the entire process I currently use to approve subscriptions to a Yahoo Group that I run (Unfortunately Yahoo Groups doesn’t support what I need to do, and so I’m looking to use some automated mail responder software add on to gmail to help me).
I regularly get email messages in my gmail inbox from people subscribing to a Yahoo Groups discussion list. Before I approve their subscription, I need to send them a questionnaire. Right now, I read every incoming subscription request, pick out their email message from the body of the subscription approval request I get from Yahoo, and compose a form letter which contains the questionnaire and send the message. When I get a response, if they qualify to be part of the discussion, I can then approve the subscription.
The is the step I wish to automate is the one where I get a message from Yahoo Groups asking me to approve the subscription. This message is not from the person subscribing, but rather from Yahoo. The email I need to send the questionnaire to is in the body of the incoming message and is on a line, such as:
Email address: abc.xyz <abc>
Right now, I pick out "abc.xyz <abc>" by hand and then compose a message to that address with a canned response which includes the questionnaire.
So if you can point me toward any existing scripts that do similar things I am a good enough programmer that I can figure out what to do.