A
A
airisart2015-03-16 00:51:44
gmail
airisart, 2015-03-16 00:51:44

How to save incoming emails to Google Spreadsheet?

I want to take some information from a specific sender and enter it into a Google spreadsheet automatically along with an attachment, how can I do it?

Answer the question

In order to leave comments, you need to log in

2 answer(s)
A
Alex, 2015-03-16
@isqua

https://ifttt.com/recipes/90162-add-receipts-order...
Change the "Search for" field to "from: sender's email".

S
Slayerty, 2021-04-19
@Slayerty

I solved a similar task of parsing email messages - I used EmailParser (I had to look for what to look for).
The application is installed in the operating system / can be launched as a system service. (there is an option to use such functionality as a web service, but periodic payment is required) A trial period of 30 days, previously there was a one-time purchase of a key, at the moment the developers have left the option for an annual renewal, if I'm not mistaken - you can check it on the program website.
The application configures the data source - the target mail account and authorization parameters [POP3 / IMAP] access are specified as the data source.
The program monitors the receipt of new letters.
If a new letter arrives, the next step is activated - filtering by a specified configured condition (filter from whom, to whom, blind copy, subject, content ... and so on)
Filtered messages go to the stage of extracting the required data:
-sender data -message
subject
- date of receipt - the
presence of an attachment and its extraction
- all previously extracted data of the mail message is recorded in a table (you can use the Google-Sheet for this in the settings to specify the Google account authorization data, access to create, write information is allowed, permission is confirmed in the account settings). In the description of the program, all steps are presented with examples.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question