S
S
Serw802022-02-16 11:09:55
Google Sheets
Serw80, 2022-02-16 11:09:55

How to export data from email to google spreadsheet?

Good day to all connoisseurs!
A special mailbox (Google) receives letters of the same format. These are requests for processing by logisticians.
How to make sure that each field of the application (each line) is transferred to a Google spreadsheet, which logisticians are already working with? Values ​​in the corresponding line should be transferred

Letter format:
1 Initiator: Karyshev B.V.
2 Date of creation: 00/00/2022
3 Date of delivery of equipment: 01/01/2022
4 Object: Statue of Liberty KZh SMR
5 Place of loading: Irkutsk, Logistov str., 5
6 Contact at the place of loading: Fedor Popov, tel. 8999 111111
7 Type loading: Top, crane capacity 5t.
8 Weight and dimension characteristics of the cargo: Rolled metal 12 m (14.5 t)
9 Place of delivery: New York, Wall Street, 1 10 Contact at the point of unloading :
Bob Smith tel
. should be bright red

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Alexander, 2022-02-16
@ForestAndGarden

Start: https://qna.habr.com/q/859913#clarification_1032471
Then the processed data needs to be moved to the worksheet. The same four services or the "Collector" script.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question