When you receive an email with a specific label in Gmail, translate it with Perplexity and add it to Microsoft Excel
When you receive an email with a specific label in Gmail, translate it with Perplexity and add it to Microsoft Excel
Launch this workflow to connect
Perplexity AI &
Gmail &
Microsoft Excel
!
■Overview
Do you spend too much time translating emails from overseas and manually entering the content into Microsoft Excel every time you receive one? Manually recording inquiries and sharing information takes time and can easily lead to data entry errors. With this workflow, simply receiving an email with a specific label in Gmail triggers Perplexity to automatically translate its content and add the results to Microsoft Excel, streamlining the entire process.
■Recommended for
- Those who spend too much time translating and managing emails from overseas received in Gmail
- Those who want to automate translation tasks using AI tools such as Perplexity
- Those who want to reduce the time and errors associated with manually entering data into Microsoft Excel
■Benefits of using this template
- From receiving an email in Gmail to translating it with Perplexity and recording the results in Microsoft Excel, the entire process is automated, reducing the time spent on manual tasks.
- Prevent human errors such as missed translations and data entry mistakes, helping you manage information accurately.
■Flowbot steps
- First, connect Gmail, Perplexity, and Microsoft Excel to Yoom.
- Next, select Gmail as the trigger and set the action to “When an email with a specific label is received.”
- Then, set up Perplexity’s “Generate text” action as an operation and configure it to translate the body and other content of the received email.
- Finally, set up Microsoft Excel’s “Add a record” action as an operation and add information such as the translation results as a row in the specified file.
※“Trigger”: An action that starts a flow. “Operation”: An action that processes data within the flow after the trigger starts.
■Customization options
■Customization options
- In the Gmail trigger settings, specify the label to apply to emails you want to translate.
- In Perplexity’s text generation operation, you can freely customize the prompt, including the type of translation to perform. You can also use the subject and body of the email retrieved by the trigger as variables.
- In the operation for adding records to Microsoft Excel, you can specify which information to add to each column. For example, you can assign the sender, subject, and translation results to separate columns.
■Notes
- Connect each of Gmail, Perplexity, and Microsoft Excel to Yoom.
- Microsoft 365 (formerly Office 365) offers home and business plans (Microsoft 365 Business). Authentication may fail if you are not subscribed to a business plan.
- You can choose a trigger interval of 5, 10, 15, 30, or 60 minutes.
- Please note that the shortest available trigger interval varies by plan.
- For details on configuring operations that interact with a Microsoft Excel database, see “[Excel] Configuring operations for interacting with a database”.
Check Out Similar Templates!
Automatically respond to inquiry form contents using Perplexity and store the Q&A history in Notion.
The content of the inquiry form is automatically answered by Perplexity, and the Q&A history is accumulated in Notion as part of the business workflow. Since Perplexity generates responses automatically, customer service can be conducted swiftly.
Summarize the content received via email using Perplexity and notify it on Slack.
This is a business workflow that summarizes the content received via email using Perplexity and notifies it on Slack. By concisely summarizing email information and sharing it on Slack, communication within the team becomes smoother, enhancing work efficiency.
Request to create a new article in Notion, draft it in Perplexity, and reflect it in Notion.
In the workflow integrating Notion and Perplexity using Yoom, new article creation requests in Notion are drafted in Perplexity and then reflected back in Notion. This streamlines the initial stages of article creation and provides an environment for smooth content management.
Summarize the minutes added to the database using Perplexity and notify via Slack.
This is the workflow for managing meeting minutes using Yoom. When the minutes are added to the database, Perplexity automatically summarizes them and sends a notification to Slack. This facilitates quick information sharing within the team and ensures smooth business operations.
See more
About the Apps
Perplexity AI
Related apps
Templates using
Perplexity AI
Automatically respond to inquiry form contents using Perplexity and store the Q&A history in Notion.
The content of the inquiry form is automatically answered by Perplexity, and the Q&A history is accumulated in Notion as part of the business workflow. Since Perplexity generates responses automatically, customer service can be conducted swiftly.
This is a business workflow that summarizes the content received via email using Perplexity and notifies it on Slack. By concisely summarizing email information and sharing it on Slack, communication within the team becomes smoother, enhancing work efficiency.
In the workflow integrating Notion and Perplexity using Yoom, new article creation requests in Notion are drafted in Perplexity and then reflected back in Notion. This streamlines the initial stages of article creation and provides an environment for smooth content management.
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
Perplexity AI
In Yoom, you can integrate with Perplexity's API without any coding and perform searches through the API. For example, you can execute Perplexity searches from chat tools like Slack or Teams, or integrate with CRMs like Salesforce or HubSpot to perform Perplexity searches.
see detailsTemplates
Automatically respond to inquiry form contents using Perplexity and store the Q&A history in Notion.
The content of the inquiry form is automatically answered by Perplexity, and the Q&A history is accumulated in Notion as part of the business workflow. Since Perplexity generates responses automatically, customer service can be conducted swiftly.
Automatically respond to inquiry form contents using Perplexity and store the Q&A history in Notion.
This is a business workflow that summarizes the content received via email using Perplexity and notifies it on Slack. By concisely summarizing email information and sharing it on Slack, communication within the team becomes smoother, enhancing work efficiency.
Summarize the content received via email using Perplexity and notify it on Slack.
In the workflow integrating Notion and Perplexity using Yoom, new article creation requests in Notion are drafted in Perplexity and then reflected back in Notion. This streamlines the initial stages of article creation and provides an environment for smooth content management.
Request to create a new article in Notion, draft it in Perplexity, and reflect it in Notion.
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 the Web (AI Summarizes)
Search for Information
Generate Text
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
Flowbot triggers
There is no action.
Flowbot operations
Search the Web (AI Summarizes)Search for InformationGenerate Text
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!
