Translate emails received with a specific Gmail label and add them to Microsoft Excel
Translate emails received with a specific Gmail label and add them to Microsoft Excel
Launch this workflow to connect
Gmail &
Microsoft Excel
!
■Overview
Do you spend too much time reviewing emails received in Gmail, such as inquiries from overseas, and manually transferring their contents to Microsoft Excel? Translation and copy-and-paste data entry are not only time-consuming but can also lead to errors. With this workflow, whenever Gmail receives an email with a specific label, AI automatically translates its contents and adds the information to the designated Microsoft Excel file, streamlining the entire process and eliminating these challenges.
■Recommended for
- Those who frequently communicate with people overseas and manage Gmail messages in Microsoft Excel
- Those overwhelmed by repetitive tasks that involve regularly extracting information from Gmail and manually entering it into Excel
- Teams looking to streamline overall information management by integrating Gmail with Microsoft Excel
■Benefits of using this template
- Automating everything from receiving emails in Gmail and translating them to recording the results in Microsoft Excel frees up the time previously spent on manual work for other tasks
- Prevent human errors such as manual transcription mistakes, translation errors, and missed entries while maintaining data accuracy
■How the Flowbot works
- First, connect Gmail and Microsoft Excel to Yoom
- Next, select Gmail as the trigger, set the action to “When an email with a specific label is received,” and specify the target label
- Then, set the AI feature’s “Translate” action as an operation and specify the text to translate, such as the body of the received email
- Finally, set Microsoft Excel’s “Add a record” action as an operation and automatically add the translated text and other information to the designated file
※ “Trigger”: An action that starts the flow. “Operation”: An action that processes data within the flow after the trigger starts.
■Customization options
- For AI translation, you can specify any text you want to translate, including not only the email body but also the subject line
- When adding records to Microsoft Excel, you can specify the target file and sheet. You can also enter fixed text for each field or embed information retrieved by previous triggers or operations as variables
■Notes
- Connect both Gmail and Microsoft Excel to Yoom.
- Microsoft 365 (formerly Office 365) offers plans for home use and general business use (Microsoft 365 Business). Authentication may fail if you are not subscribed to a business plan.
- You can select a trigger interval of 5, 10, 15, 30, or 60 minutes. Please note that the shortest available interval varies by plan.
- For information on configuring operations that work with Microsoft Excel databases, see “[Excel] Configuring operations for working with databases.”
- The translation feature is available with the Mini plan and above. Please note that operations and data connections in configured Flowbots will result in errors on the Free and Personal plans.
- Paid plans such as the Personal, Mini, Team, and Success plans include a two-week free trial. During the free trial, you can use apps that are otherwise subject to plan restrictions.
Check Out Similar Templates!
Add Gmail inbox content to Notion
This is a business workflow that automatically adds Gmail received content to Notion. It streamlines email management and information organization, eliminating the need for manual transcription. By ensuring important emails are securely saved and shared, it enhances the team's operational productivity.
Automatically sort incoming emails in Gmail by keywords and forward them to the person in charge.
This is a flow to automatically sort emails received in Gmail by keywords and forward them to the appropriate person in charge. By using this flow, you can detect specific keywords and forward them to the appropriate person. This will likely lead to improved customer response times.
When you receive an email in Gmail that matches a specific keyword, generate text with DeepSeek and add a label to a specific Gmail message
When an email containing specific keywords arrives in Gmail, DeepSeek automatically generates a reply and applies a label. Reduce time spent on manual sorting and initial responses while ensuring no email is missed.
See more
About the Apps
Gmail
Related apps
Templates using
Gmail
This is a flow that is triggered at the end of each month to send an email via Gmail. It can be used for various purposes such as aggregation processing in Microsoft Excel or monthly invoice issuance.
This is a business workflow that automatically adds Gmail received content to Notion. It streamlines email management and information organization, eliminating the need for manual transcription. By ensuring important emails are securely saved and shared, it enhances the team's operational productivity.
Automatically sort incoming emails in Gmail by keywords and forward them to the person in charge.
This is a flow to automatically sort emails received in Gmail by keywords and forward them to the appropriate person in charge. By using this flow, you can detect specific keywords and forward them to the appropriate person. This will likely lead to improved customer response times.
Microsoft Excel
Related apps
Templates using
Microsoft Excel
A business workflow that automatically adds records to Microsoft Excel based on Tally's responses. It eliminates manual data entry, ensuring data accuracy and real-time updates, thereby improving work efficiency and preventing errors.
The workflow automatically records Jotform responses in Excel and adds tasks to Outlook. It eliminates the need for manual data entry and task setting, enhancing the accuracy and efficiency of operations.
This is a business workflow that automatically organizes Microsoft Teams posts into Excel and adds tasks to Outlook. It eliminates the need for manual input, streamlining information and task management.
About the apps you use
Gmail
Yoom allows you to integrate with Gmail's API without code and automate email sending from Gmail. You can automatically create and send invoices and contracts via Gmail, or automatically reply to inquiries.
see detailsTemplates
This is a flow that is triggered at the end of each month to send an email via Gmail. It can be used for various purposes such as aggregation processing in Microsoft Excel or monthly invoice issuance.
Activate the flow bot at the end of each month to send an email in Gmail.
This is a business workflow that automatically adds Gmail received content to Notion. It streamlines email management and information organization, eliminating the need for manual transcription. By ensuring important emails are securely saved and shared, it enhances the team's operational productivity.
Add Gmail inbox content to Notion
Automatically sort incoming emails in Gmail by keywords and forward them to the person in charge.
This is a flow to automatically sort emails received in Gmail by keywords and forward them to the appropriate person in charge. By using this flow, you can detect specific keywords and forward them to the appropriate person. This will likely lead to improved customer response times.
Automatically sort incoming emails in Gmail by keywords and forward them to the person in charge.
Microsoft Excel
Yoom allows you to integrate with Microsoft Excel's API without any code, enabling the automation of various tasks. For example, it can automatically store values in specific Excel cells or create sheets and tables automatically.
see detailsTemplates
A business workflow that automatically adds records to Microsoft Excel based on Tally's responses. It eliminates manual data entry, ensuring data accuracy and real-time updates, thereby improving work efficiency and preventing errors.
Add records to Microsoft Excel based on Tally's responses.
The workflow automatically records Jotform responses in Excel and adds tasks to Outlook. It eliminates the need for manual data entry and task setting, enhancing the accuracy and efficiency of operations.
Add tasks to Microsoft Excel and Outlook based on Jotform responses.
This is a business workflow that automatically organizes Microsoft Teams posts into Excel and adds tasks to Outlook. It eliminates the need for manual input, streamlining information and task management.
Add tasks to Microsoft Excel and Outlook based on Microsoft Teams posts.
No-Code API Actions
Executable API actions
Flowbot triggers
When an Email Matching Specific Keywords Is Received
When an Email with a Specific Label Is Received
When an Email with a Specific Label Is Received (Specify Label ID)
Flowbot operations
Search Emails
Move Message to Trash
Add Label to Specific Message
Remove Label from Specific Message
Retrieve Specific Message
Get Worksheet Information
Get a Specific Cell Value
Get Range by Column
Get Range by Row
Add Worksheet
Rename Sheet
Get Table List
Add Table
Enter Formula in Cell
Enter Value in Cell
Get Item ID
Delete Sheet
Sort a Specified Range in Ascending or Descending Order
Flowbot triggers
When an Email Matching Specific Keywords Is ReceivedWhen an Email with a Specific Label Is ReceivedWhen an Email with a Specific Label Is Received (Specify Label ID)
Flowbot operations
Search EmailsMove Message to TrashAdd Label to Specific MessageRemove Label from Specific MessageRetrieve Specific Message
Flowbot triggers
There is no action.
Flowbot operations
Get Worksheet InformationGet a Specific Cell ValueGet Range by ColumnGet Range by RowAdd WorksheetRename SheetGet Table ListAdd TableEnter Formula in CellEnter Value in CellGet Item IDDelete SheetSort a Specified Range in Ascending or Descending OrderUnprotect WorksheetGet Drive Item ID from Sharing URLCreate Excel SessionList SitesList Drives in SiteGet Worksheet Information (SharePoint)Get the Value of a Specific Cell (SharePoint)Get Range by Column (SharePoint)Get Range by Row (SharePoint)Add Worksheet (SharePoint)Rename Worksheet (SharePoint)Get Table List (SharePoint)Add Table (SharePoint)Set Formula in Cell (SharePoint)Set Value in Cell (SharePoint)Delete Sheet (SharePoint)Sort a Specified Range in Ascending or Descending Order (SharePoint)Unprotect Worksheet (SharePoint)Create Excel Session (SharePoint)Get Item ID (SharePoint)More inspiration for you
Discover step-by-step guides for automating your work using the apps featured in this workflow!
