want to SEND an email to a spreadsheet

[majorkong]

Hi all

I want to send an email to a spreadsheet so it can stimulate a apps
script but I don't see how to do it???? Here's the scenario


I get a formatted message from a broker telling me that a trade went
through ie BOUGHT 100 XYZ CORP @ $20 ACC 12345 2/17/2011
14:20 CST

I want to send it to a spreadsheet that will then parse the message
and populate a new row in the spreadsheet

NOW I know how to do the spreadsheet app if it was entered manually
BUT I can't see if I can send an email to a server side java
application script??

anyone know how to do this from EMAIL?


thanks

[Bob Larimer]

Wow.  I would also be interested in doing that, but I suspect it would be quite cumbersome especially when you try to factor in how to delineate each field from the next.  If you use a comma to delineate the fields, then the end user can not use a comma and if they do that will throw all the values off. 

 

 

Bob L

[majorkong]

gotta get over the first hurdle getting the email event then I will
get to the parsing bit :-) Very odd that I can send emails but can't
get them.

[George Savery]

I did a similar app using lotus domino (a mail server) using a visualb basic call.  Tha. App would recieve an email with attached excel. Ssheet it would then pull out info including images and create an order in a db. What i am driving at is that you may be better served using.a local mailserver (exchange ir domino) so your mail item gets delivered too an environment that can be accessed uing vb.  ... you could try using outlook accessing gmail via pop3 and see if it triggers outlooks new mail event...if it does then your on your way...
Regards
     george

On Fri, Feb 18, 2011 at 10:49 AM, Bob Larimer <bob.l...@gmail.com> wrote:

Wow.  I would also be interested in doing that, but I suspect it would be quite cumbersome especially when you try to factor in how to delineate each field from the next.  If you use a comma to delineate the fields, then the end user can not use a comma and if they do that will throw all the values off. 

 

 

Bob L

--
You received this message because you are subscribed to the Google Groups "GMail Power Users" group.
To post to this group, send email to gmail-po...@googlegroups.com
To unsubscribe from this group, send email to gmail-power-us...@googlegroups.com
For more options, visit this group at http://groups.google.com/group/gmail-power-users?hl=en
To send a message to the owner, visit the following page:
http://groups.google.com/group/gmail-power-users/post?sendowner=1&hl=en

[majorkong]

Hey George

thanks for the reply and the thought BUT we are a google only shop so
we have to play in that sandbox. So I think I am still stuffed when it
comes to this as google apps script can't handle reading email. Nice
work on the app though well done.

[George Savery]

have you had a look at contextual gadgets  the example below parses a gmail account for the phrase hello world

http://code.google.com/apis/gmail/gadgets/contextual/#manifest


then starts the pain :)

you will need to then call to a google docs spreadsheet
http://www.google.com/support/forum/p/apps-apis/thread?tid=2b1ac9cea11e1151&hl=en  <-- this person wants to write to a spreadsheet from Gmail , there are also some linked referances that may help



Regards
     George

[majorkong]

First of all AWESOME research and thanks for taking the time, I did
not know about contextual gadgets so I will spend some time looking at
the work you have done.
BUT ( there is always a but) I am thinking that this might be work
that I do only to be obliterated by Google adding the feature to the
existing mail objects in app script, to me it seems a natural
extension of the whole cloud process and one that more people will ask
for. I am still going to look into contextual gadgets and I thank you
again for going the extra yard.

dave

On Feb 21, 6:47 pm, George Savery <geo...@savery.org> wrote:
> have you had a look at contextual gadgets  the example below parses a gmail
> account for the phrase hello world
>
> http://code.google.com/apis/gmail/gadgets/contextual/#manifest
>
> then starts the pain :)
>

> you will need to then call to a google docs spreadsheethttp://www.google.com/support/forum/p/apps-apis/thread?tid=2b1ac9cea1...