NEW Introducing AI workers. Hire the digital teammate you've been looking for. Learn more
Hire your AI teammate, meet AI workers. Learn more
When a quote is received in Gmail, analyze it with an AI worker and update the quote comparison table

When a quote is received in Gmail, analyze it with an AI worker and update the quote comparison table

Launch this workflow to connect Gmail & Google Drive & Google Sheets & Slack !
■Overview
Do you find it burdensome to manually transfer the details of quotes received from multiple vendors into a comparison table? Especially during busy periods, missing information or misplacing original documents can easily occur, potentially hindering accurate decision-making. With this workflow, when you receive a quote in Gmail, an AI Worker automatically analyzes its contents and updates the quote comparison table in Google Sheets. By automating the entire process—from identifying project information to saving files—you can improve the accuracy and speed of administrative tasks.

■Who this template is for
  • Procurement and purchasing professionals who want to reduce the effort of manually transferring large volumes of quotes received in Gmail into a comparison table
  • Project managers who want to share the latest quote comparison information with their team and make smooth, informed decisions
  • Business owners who want to strengthen their management processes by preventing missing original quote documents and outdated data

■Benefits of using this template
  • The AI Worker analyzes quotes received in Gmail and automatically updates Google Sheets, reducing the time spent on manual data entry.
  • Prevent human errors such as incorrect data entry and missing file storage, and keep your comparison table accurate at all times.

■Flowbot steps
  1. First, connect Gmail, Google Drive, Google Sheets, and Slack to Yoom.
  2. Next, select Gmail as the trigger and set the action to “When an email matching specific keywords is received.”
  3. Finally, create an AI Worker manual that extracts information from the email and quote PDF, then automatically saves the file and transfers the data to the quote comparison table.
※“Trigger”: An action that starts the flow. “Operation”: An action that processes data within the flow after the trigger starts.

■Customization options
  • In the Gmail trigger settings, configure the search criteria (keywords) as needed to accurately detect emails with the relevant quote attachments.
  • Specify the sheet ID of the quote comparison table to update in Google Sheets and the columns where the information should be entered based on your environment.
  • In the Slack notification settings, freely customize the channel where information is shared and the content of the notification message.

■Notes
  • Connect Gmail, Google Drive, Google Sheets, and Slack to Yoom. The tools (apps) used within the AI Worker also require My Apps connections.
  • You can select a trigger interval of 5, 10, 15, 30, or 60 minutes.
  • Please note that the shortest available trigger interval varies by plan.
  • For basic AI Worker settings, see “[AI Worker] How to configure basic settings.”
  • The number of simultaneous AI Worker executions, the number of AI Workers you can create, and the AI models available to you vary by plan.
  • The apps and operations available within AI Workers are subject to the same usage limits as Flowbots.
  • Please note that AI Workers consume tasks during test runs just as they do during production runs. For details, see “[AI Worker] How task execution counts are calculated.”
  • AI Workers are more likely to perform the appropriate actions when the manual is configured in detail. For details, see “[AI Worker] How to create a manual.” 
  • The maximum downloadable file size is 300 MB. Please note that this limit may be lower than 300 MB depending on the app specifications.
  • For details on the file size limits for triggers and individual operations, see “File size limits.”
Check Out Similar Templates!
Shopify
Slack
Have an AI worker regularly analyze Shopify inventory sell-through rates and notify stakeholders of recommended actions after consultation
This flow uses AI to regularly analyze your Shopify inventory data and recommend action plans based on sell-through rates. Refine your strategies through conversations with AI and send notifications to Slack—ideal for ecommerce leaders who want to streamline inventory management while making flexible, informed decisions.
Google Sheets
Jira Software
Slack
Have AI Workers analyze Jira progress weekly, update the roadmap, and notify you only when risks are detected
Automate Jira progress tracking and Google Sheets roadmap updates with AI Workers.,At a scheduled time each week, AI retrieves and analyzes Jira ticket data, then automatically updates your Google Sheet with current progress and delay risks. Administrators simply review the analysis delivered to Slack to identify potential delays early. Eliminate tedious manual updates and focus your resources on faster decision-making and resolving critical issues.
Google Docs
Zendesk
Regularly add FAQ drafts from resolved Zendesk tickets to Google Docs
Automatically create FAQ drafts from daily Zendesk tickets and centralize them in Google Docs with this Flow Bot template. Turn valuable knowledge accumulated in customer support into FAQs—without the manual effort. AI regularly reviews resolved tickets and identifies frequently asked questions, helping you efficiently maintain an FAQ update cycle that reflects the latest user needs. Reduce the time spent gathering information and creating drafts, and ensure customers always receive accurate information.
Gmail
Google Sheets
When an employee is flagged as terminated in a Google Sheets tracker, an AI worker generates separation certificate data from the payroll ledger
Use updated employee departure information in Google Sheets to have an AI agent (AI worker) automatically generate separation notices from payroll ledgers and send notifications via Gmail. Eliminate manual data entry and calculations to reduce processing time and prevent input errors.
Google Docs
Google Drive
Google Forms
Slack
Register contract terms in Google Forms, then use an AI worker to review them, generate a contract, and notify Slack
Automate legal reviews and contract drafting with AI based on contract terms submitted through Google Forms. Accelerate approvals, prevent errors, and streamline the path to contract execution—reducing the workload on your legal team and improving operational efficiency.
Google Sheets
Microsoft Outlook
Each day, the AI worker identifies travelers who need reminders and sends pre-departure emails after approval from the person in charge.
This template automatically identifies recipients who need reminders from Google Sheets, uses an AI worker to craft personalized messages for each person, and sends emails through Outlook after approval from the assigned owner. Reduce the risk of missed recipients and misdirected emails while delivering thoughtful follow-ups that improve customer satisfaction with minimal effort.
See more
About the Apps
Gmail
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.

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.
Google Drive
Templates using
Google Drive

Automatically convert PowerPoint files in Google Drive to Google Slides and notify your team in Slack. Eliminate manual conversions and missed sharing to streamline document management and team collaboration.

In this workflow, when a new file is uploaded to Google Drive, the file information is automatically compiled in Notion. This automation facilitates smooth file tracking and sharing, ensuring seamless information sharing within the team.

The workflow automatically saves form responses to Google Drive and registers leads in Salesforce. It enhances data management efficiency and integrates the sales process.
Google Sheets
Templates using
Google Sheets

Once the billing information is filled out in the form, an invoice will be generated using the Google Spreadsheet invoice template. After that, it will undergo approval by the person in charge, and an email will be sent.

This is a flow for adding order information to WooCommerce when a row is added in Google Sheets. This flow significantly reduces manual effort and saves the time previously spent on registration, allowing you to focus on more important tasks and improving productivity.

You can add a new tab to a Google Spreadsheet at the beginning of each month. By being able to add a new sheet to a specific Google Spreadsheet at the start of each month, you can avoid forgetting to add sheets and prevent unnecessary rework.
Slack
Templates using
Slack

This is a flow bot that automatically activates at the end of each month and sends notifications via Slack. This flow bot can perform various automated processes through the flows added after the branch on the right side. For example, you can use it for various purposes such as monthly invoice issuance, aggregation processing to spreadsheets, or regular data backup processing.

This is a business workflow that automatically adds content posted in a Slack channel as comments to tasks in Wrike. This reduces manual task updates and improves project management efficiency.

When an inquiry comes to Slack, it is registered in Google Sheets. By integrating Slack and Google Sheets, you can eliminate the hassle of operating individual apps and repeatedly entering data, allowing for smoother business operations. Records can be easily added to Google Sheets automatically, preventing any omissions or leaks in information 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 details
Templates

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.

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.
Google Drive
Yoom allows you to integrate with Google Drive's API without any code, enabling the automation of various tasks. For example, you can automatically create new folders in Google Drive and store files, or download files from Google Drive and send them via email or chat.
see details
Templates

Automatically convert PowerPoint files in Google Drive to Google Slides and notify your team in Slack. Eliminate manual conversions and missed sharing to streamline document management and team collaboration.

In this workflow, when a new file is uploaded to Google Drive, the file information is automatically compiled in Notion. This automation facilitates smooth file tracking and sharing, ensuring seamless information sharing within the team.

The workflow automatically saves form responses to Google Drive and registers leads in Salesforce. It enhances data management efficiency and integrates the sales process.
Google Sheets
At Yoom, you can utilize the Google Sheets API without any coding. By integrating Sheets with Yoom, you can automate data entry into spreadsheets and automatically create documents based on spreadsheet templates. Additionally, you can sync spreadsheet information with Yoom's database for various applications.
see details
Templates

Once the billing information is filled out in the form, an invoice will be generated using the Google Spreadsheet invoice template. After that, it will undergo approval by the person in charge, and an email will be sent.

This is a flow for adding order information to WooCommerce when a row is added in Google Sheets. This flow significantly reduces manual effort and saves the time previously spent on registration, allowing you to focus on more important tasks and improving productivity.

You can add a new tab to a Google Spreadsheet at the beginning of each month. By being able to add a new sheet to a specific Google Spreadsheet at the start of each month, you can avoid forgetting to add sheets and prevent unnecessary rework.
Slack
Yoom allows you to utilize Slack's API without any coding. By integrating Yoom with Slack, you can freely connect various SaaS with Slack and receive all kinds of notifications on Slack. Additionally, it is possible to trigger a bot when a message is sent to Slack.
see details
Templates

This is a flow bot that automatically activates at the end of each month and sends notifications via Slack. This flow bot can perform various automated processes through the flows added after the branch on the right side. For example, you can use it for various purposes such as monthly invoice issuance, aggregation processing to spreadsheets, or regular data backup processing.

This is a business workflow that automatically adds content posted in a Slack channel as comments to tasks in Wrike. This reduces manual task updates and improves project management efficiency.

When an inquiry comes to Slack, it is registered in Google Sheets. By integrating Slack and Google Sheets, you can eliminate the hassle of operating individual apps and repeatedly entering data, allowing for smoother business operations. Records can be easily added to Google Sheets automatically, preventing any omissions or leaks in information management.‍
Templates
No items found.
Related apps
No items found.
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)
    New File or Folder Created
    When a New File or Folder Is Created in a Specified Folder
    When a Specific File Is Created or Updated
    When a File Containing Specific Keywords Is Created
    When a Row Is Added
    When a Row Is Updated
    When a Message Is Posted to a Channel
    When a File Is Posted to a Channel
    When a Message Is Posted to a Channel (Webhook)
    When a Reaction Is Added to a Message (Webhook)
    When a User Is Mentioned in a Channel
    When a Message Containing Specified Text Is Posted to a Channel
    When the Slack App Is Mentioned (Webhook)
    When Mentioned in a Channel (Multiple Users)
    When a Message Containing Specified Text Is Posted to a Channel (Regular Expression)
    When a New Channel Is Created (Webhook)
    When a Message Is Posted in a Thread (Webhook)
    When Mentioned in a Channel (Multiple Users & User Groups)
    When a Message Reaction Is Removed (Webhook)
    When a Posted Message Is Updated (Webhook)
Flowbot operations
    Search Emails
    Move Message to Trash
    Add Label to Specific Message
    Remove Label from Specific Message
    Retrieve Specific Message
    Create Folder
    Duplicate File
    Search for Files and Folders in a Specific Folder
    Delete File
    Upload File
    Download File
    Download Google Sheets File
    Download Google Slides
    Download Google Docs File
    Retrieve a List of Files and Folders in a Specific Folder
    Rename File
    Retrieve File or Folder Information
    Convert Excel File to Google Sheets
    Convert CSV File to Google Sheets
    Grant File or Folder Permissions to a User
    Move File to Trash
    Retrieve a List of Permissions for a File or Folder
    Update Description for a File or Folder
    Change File Destination Folder
    Create a Shortcut to a File
    Configure Download and Copy Permissions
    Retrieve a List of Folders in a Specific Folder
    Convert a File to Google Docs
    Download a Google Sheet (Specify Sheet)
    Change Sharing to "Anyone with the Link"
    Search Files and Folders in a Specific Folder (Excluding Trash)
    Convert a Presentation File to Google Slides
    Convert a PDF File to Google Docs
    Grant File or Folder Permissions to a Specific Organization
    Update a Specific File
    Remove Permissions from a File or Folder
    Create a Shared Drive
    Search Shared Drives
    Copy File (Detailed Options)
    Search Files and Folders
    Set a Value in a Cell
    Get Values
    Clear Values
    Create a New Spreadsheet
    Copy a Sheet (Tab)
    Add a New Sheet (Tab)
    Delete Sheet (Tab)
    Replace Values
    Update Sheet Name
    Delete Rows
    Get Spreadsheet Info
    Get Sheet Names
    Apply a Formula to a Range
    Enter Values in a Range
    Embed an Image in a Cell
    Sort by Specific Column
    Hide a Sheet
    Add a Note to the Specified Cells
    Insert Columns
    Delete Columns
    Write Values to Multiple Columns
    Add Rows
    Send Message to Channel
    Send Direct Message
    Get Member IDs in a Channel
    Create Channel
    Invite Members to Channel
    Get User Group List
    Post Message to Thread
    Archive Channel
    Get Messages in a Thread
    List Public Channels
    Remove a Member from a Private Channel
    Find User by Email Address
    Get User Info
    Get a Specific Message
    Get Message Link
    Delete Message
    Get Users in a User Group
    Get Reactions for a Message
    Create a User Group
    List Channel Messages
    Send a Message to a Channel with Attachments
    List Rows in a List
    Create List
    Update List
    Get a Specific List Row
    Remove List Access
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
Flowbot triggers
    New File or Folder Created
    When a New File or Folder Is Created in a Specified Folder
    When a Specific File Is Created or Updated
    When a File Containing Specific Keywords Is Created
Flowbot operations
    Create Folder
    Duplicate File
    Search for Files and Folders in a Specific Folder
    Delete File
    Upload File
    Download File
    Download Google Sheets File
    Download Google Slides
    Download Google Docs File
    Retrieve a List of Files and Folders in a Specific Folder
    Rename File
    Retrieve File or Folder Information
    Convert Excel File to Google Sheets
    Convert CSV File to Google Sheets
    Grant File or Folder Permissions to a User
    Move File to Trash
    Retrieve a List of Permissions for a File or Folder
    Update Description for a File or Folder
    Change File Destination Folder
    Create a Shortcut to a File
    Configure Download and Copy Permissions
    Retrieve a List of Folders in a Specific Folder
    Convert a File to Google Docs
    Download a Google Sheet (Specify Sheet)
    Change Sharing to "Anyone with the Link"
    Search Files and Folders in a Specific Folder (Excluding Trash)
    Convert a Presentation File to Google Slides
    Convert a PDF File to Google Docs
    Grant File or Folder Permissions to a Specific Organization
    Update a Specific File
    Remove Permissions from a File or Folder
    Create a Shared Drive
    Search Shared Drives
    Copy File (Detailed Options)
    Search Files and Folders
Flowbot triggers
    When a Row Is Added
    When a Row Is Updated
Flowbot operations
    Set a Value in a Cell
    Get Values
    Clear Values
    Create a New Spreadsheet
    Copy a Sheet (Tab)
    Add a New Sheet (Tab)
    Delete Sheet (Tab)
    Replace Values
    Update Sheet Name
    Delete Rows
    Get Spreadsheet Info
    Get Sheet Names
    Apply a Formula to a Range
    Enter Values in a Range
    Embed an Image in a Cell
    Sort by Specific Column
    Hide a Sheet
    Add a Note to the Specified Cells
    Insert Columns
    Delete Columns
    Write Values to Multiple Columns
    Add Rows
Flowbot triggers
    When a Message Is Posted to a Channel
    When a File Is Posted to a Channel
    When a Message Is Posted to a Channel (Webhook)
    When a Reaction Is Added to a Message (Webhook)
    When a User Is Mentioned in a Channel
    When a Message Containing Specified Text Is Posted to a Channel
    When the Slack App Is Mentioned (Webhook)
    When Mentioned in a Channel (Multiple Users)
    When a Message Containing Specified Text Is Posted to a Channel (Regular Expression)
    When a New Channel Is Created (Webhook)
    When a Message Is Posted in a Thread (Webhook)
    When Mentioned in a Channel (Multiple Users & User Groups)
    When a Message Reaction Is Removed (Webhook)
    When a Posted Message Is Updated (Webhook)
Flowbot operations
    Send Message to Channel
    Send Direct Message
    Get Member IDs in a Channel
    Create Channel
    Invite Members to Channel
    Get User Group List
    Post Message to Thread
    Archive Channel
    Get Messages in a Thread
    List Public Channels
    Remove a Member from a Private Channel
    Find User by Email Address
    Get User Info
    Get a Specific Message
    Get Message Link
    Delete Message
    Get Users in a User Group
    Get Reactions for a Message
    Create a User Group
    List Channel Messages
    Send a Message to a Channel with Attachments
    List Rows in a List
    Create List
    Update List
    Get a Specific List Row
    Remove List Access
More inspiration for you
Discover step-by-step guides for automating your work using the apps featured in this workflow!