Audio file from Outlook automatically transferred to google sheet with the transcript.
Budget: $30 – $250 USD
SHORT
I need an automation system that will export the content of some emails from my Outlook inbox to Google Sheet which includes a transcript of an audio file and a link to the audio file.
DETAILED
At work, I receive all my landline phone messages to my Outlook inbox including basic information about the caller and the audio file of the message.
I need that information to be automatically transferred to this Google Sheet:
https://docs.google.com/spreadsheets/d/1AuucIP8zq5hHP3YXQwgfsEug4CLPEi8PPjEGki1ArT0/edit?usp=sharing
Note that only the following columns should be populated with data from the email I received.
- All email:
- Date
- Time
- Phone
- Audio (link to the audio file)
- Message Transcript (of the audio file)
- When applicable:
- Unit
- FF
- Logical selection:
- Type
All other fields can be ignored for now as they will be entered manually by me.
Check these email screenshots. They match the data from the spreadsheet. In a way, it is as if the automation was already in place.
15:20 - Will provide upon request if needed (WPURIN)
15:14 - https://app.screencast.com/F1cLFbcrTbTrh
12:58- (WPURIN)
12:52- (WPURIN)
12:34- (WPURIN)
11:05 - (WPURIN)
11:02 - (WPURIN)
10:08 - (WPURIN)
09:00 - https://app.screencast.com/aJLiDu8rrbCB5
The difficult part of this project is to get the link for the audio file and the transcription.
To execute this project, I don’t mind which system you want to use. Either ifttt.com, tray.io, make.com or n8n.io… I would just really like to use a free version.
Additional notes:
- New lines should be added at the top (not the bottom)
- It should be possible for me to update the spreadsheet (add lines) manually without disrupting the update flow.
- It should be possible to add columns without disrupting the automation scritp.
- The width of the columns should remain the same when data is imported.
I need an automation system that will export the content of some emails from my Outlook inbox to Google Sheet which includes a transcript of an audio file and a link to the audio file.
DETAILED
At work, I receive all my landline phone messages to my Outlook inbox including basic information about the caller and the audio file of the message.
I need that information to be automatically transferred to this Google Sheet:
https://docs.google.com/spreadsheets/d/1AuucIP8zq5hHP3YXQwgfsEug4CLPEi8PPjEGki1ArT0/edit?usp=sharing
Note that only the following columns should be populated with data from the email I received.
- All email:
- Date
- Time
- Phone
- Audio (link to the audio file)
- Message Transcript (of the audio file)
- When applicable:
- Unit
- FF
- Logical selection:
- Type
All other fields can be ignored for now as they will be entered manually by me.
Check these email screenshots. They match the data from the spreadsheet. In a way, it is as if the automation was already in place.
15:20 - Will provide upon request if needed (WPURIN)
15:14 - https://app.screencast.com/F1cLFbcrTbTrh
12:58- (WPURIN)
12:52- (WPURIN)
12:34- (WPURIN)
11:05 - (WPURIN)
11:02 - (WPURIN)
10:08 - (WPURIN)
09:00 - https://app.screencast.com/aJLiDu8rrbCB5
The difficult part of this project is to get the link for the audio file and the transcription.
To execute this project, I don’t mind which system you want to use. Either ifttt.com, tray.io, make.com or n8n.io… I would just really like to use a free version.
Additional notes:
- New lines should be added at the top (not the bottom)
- It should be possible for me to update the spreadsheet (add lines) manually without disrupting the update flow.
- It should be possible to add columns without disrupting the automation scritp.
- The width of the columns should remain the same when data is imported.