Process Logistics Orders from Gmail with AI and Google Sheets
This workflow triggers when a new email containing an inbound order is received in Gmail. It then uses an AI model to extract key order details such as PO number, delivery date, SKU ID, and quantity from the email body. Finally, the extracted information is automatically added as a new row to a specified Google Sheet for logistics tracking.
Apps Used:
Gmail
OpenAI
Google SheetsCategories:
How It Works
- 1When a new email is received in Gmail with 'Inbound Order' in the subject
- 2Extract order details (PO_NUMBER, EXPECTED_DELIVERY_DATE, SKU_ID, QUANTITY) from the email body using AI
- 3Add a new row to a Google Sheet with the extracted order details
Related Templates
Extract Invoice Data from Gmail to Google Sheets with AI
This workflow monitors your Gmail for new emails containing PDF invoice attachments. It uses AI to extract key financial data such as company information, invoice numbers, line items, and taxes from the PDF. Finally, it creates a new Google Sheet, populates it with the extracted data, and organizes the file in Google Drive for accounting purposes.
Screen and Score Resumes from Gmail to Google Sheets with AI
This workflow streamlines the process of screening job applications. It triggers when a new email with a PDF resume attachment is received in Gmail. The workflow then extracts text and key candidate details from the resume using AI, evaluates and scores the candidate based on predefined criteria, and finally logs all the candidate's information, including their score, into a Google Sheet for easy management.
Extract Invoice Data from Google Drive PDFs with AI and Email Alerts
This workflow automatically triggers when a new PDF invoice is uploaded to a specified Google Drive folder. It extracts key invoice details using AI, logs this data into a Google Sheet, and then generates and sends an email alert to the billing team via Gmail with a summary of the processed invoice.
Automate Gmail Inquiry Responses with AI and Google Sheets
This workflow automatically monitors your Gmail inbox for new inquiries. It classifies incoming emails using AI, retrieves relevant context from a Google Sheet acting as an FAQ database, and generates a professional, context-aware reply for valid inquiries. Finally, it sends the AI-generated response via Gmail and logs all interaction details (original email, AI response, timestamp, and sender) to a Google Sheet for tracking.
Extract Data from Documents with Dynamic AI Prompts using Google Sheets
This workflow is triggered when a new row is added to a Google Sheet containing a document link. It processes the document (e.g., a PDF resume) by extracting its text content. Using prompts fetched from another Google Sheet, an AI extracts specific fields of information. Finally, the extracted data is updated back into the original Google Sheet row.
AI-Powered PDF Invoice Parser with Google Drive and Google Sheets
This workflow automates invoice processing by monitoring a Google Drive folder for new PDF invoices. Upon detection of a new PDF, it extracts text content using OCR, then uses AI to parse and extract key invoice details like invoice number, date, and total amount. Finally, it stores the extracted, structured data into a Google Sheet for easy access and reporting.