Hello, today we will show you how to create a scenario that will enter
information from your emails into a Google spreadsheet.
First, create and name a new spreadsheet.
Add column headers specifying which data from the emails will be entered,
like date, sender address, and subject.
You can also modify the spreadsheet as you want.
Now, you can move on to creating the scenario.
To create the scenario, click the "Create a new scenario button" on your dashboard.
Then search for Gmail as your first app.
Select, the watch emails trigger.
Now, create a connection to your Gmail account, so that Integromat knows which account to work with.
Select the mailbox folder you want to watch or, you can select all emails.
Choose that you want to process only unread emails and mark them as seen when processed.
Select from where you want the email processing to start.
For example from the beginning, so All emails
or, you can choose the first email for where the processing is to start.
In this case, we will select the From now on option to watch all emails received from now on.
Now, specify what you want to do with the emails.
In this case, add the next module, which starts by selecting Google Sheets
and then choosing the add a row module.
You need to grant access rights for Google sheets.
So, far you only have allowed access to Gmail.
Select the file you created at the beginning.
The column headers have been loaded from that file.
Now, select the data you want to map to each column: date, sender email address, and subject.
Now, you can save the scenario and try running it by hitting the "Run once" button
Your email box must have been empty, so nothing is loaded.
So, let's send an email to your account so that you can test the scenario.
Enter your email address.
Enter a subject for the message.
Once the email arrives to your mailbox, run the scenario again.
Integromat will load the email and store the data in Google Sheets.
In the log, you can see what was processed and where it was saved.
Check if the data was entered correctly in Google sheets.
Now, schedule the scenario to run as you need.
You can enter, for example, one minute and then activate the scenario.
Once activated the scenario will run automatically.
It will watch your Gmail mailbox and list any incoming emails in the Google spreadsheet.
To check whether everything runs as you want, you can send another message.
Once you've sent the message, Integromat will process it and save it to the spreadsheet.
It will appear in one minute at the interval you have set.
And, here it is.
The scenario is ready to use.
You can now easily list all of your emails into Google Sheets.
Thank you for watching and see you next time.
For more infomation >> Classificação e Modo de Exibição dos Arquivos no Google Drive - Duration: 6:09. 
For more infomation >> Videocast: Temperatures near 60 today - Duration: 2:09. 
For more infomation >> TOP 10 České vynálezy, které změnily svět - Duration: 10:06. 
For more infomation >> New Suzuki GSX-R1000 and GSX-R1000R Colours For 2018 | Mich Motorcycle - Duration: 1:36. 
For more infomation >> Gluten-Free Casein-Free Diets for Autism Put to the Test - Duration: 6:31. 
For more infomation >> Cười không nhặt được mồm ║ Những pha chơi ngu hài hước bá đạo nhât ─ #60 - Duration: 10:59. 
For more infomation >> Serie SwissSki Helvetia - Skicross Airbag - Duration: 1:16. 
Không có nhận xét nào:
Đăng nhận xét