How to format my spreadsheet properly to work with FormEmailer?

[WhoSoLovesUs?]

Hi,

Due to the lack of documentation and examples, I don't yet know how to format my spreadsheet so that the script can find my data.

I could really use a hand.

See my example format – also here is a link to my sample spreadsheet: http://goo.gl/YEBZLk

Here are the default settings, at this point not useful:

I just don't know how to proceed at all.

For completeness, I'll mention that I'd like the resulting email to look something like this (see below); the underlined text represents that it is dynamic.

I recognize that my end goal will probably require some customization of the script, but it's probably helpful if I include this for reference:

Hi John,

Here's your followup from our July 25, 2014 session.

The following items will require action on your part:

Photos

Increase to 30 by August 31, 2014

Photo Quality

Improve lighting by August 31, 2014

I'll be sure to touch base with you to see how you're making out regarding these items :)

Kind Regards,

MyCo. 

Thanks :)

[Henrique Abreu]

The sheet with data to be merged must have a simple layout, that is: headers on the first row (line 1), starting on the first column (A) and data filled on normally, with no blank lines, etc.

Just like it is when you set a Google Form to put the answers on a spreadsheet.

Henrique Abreu

--
You received this message because you are subscribed to the Google Groups "FormEmailer" group.
To unsubscribe from this group and stop receiving emails from it, send an email to formemailer...@googlegroups.com.
To post to this group, send email to forme...@googlegroups.com.
Visit this group at http://groups.google.com/group/formemailer.
For more options, visit https://groups.google.com/d/optout.

[WhoSoLovesUs?]

Thanks, that's the info I was looking for :)

I'll have to see if I can format this according to my needs; I might have to play around with Google Forms to see what they resulting data looks like