I get information emailed to me from web forms (i.e. name, phone number) that I would like automatically logged into a Google Docs Spreadsheet.
I'm basically looking for a script for Google Spreadsheet that can scan my email account (say every 60 seconds) for new messages - check the message body for information (i.e. name, phone number) - and log the data into the corresponding columns of an ongoing spreadsheet.
Also have this script send out an email to the email address listed in the message body - addressing the person by name (e.g. Hello Jon, thank you for vising our site...)?