AI‑Powered Gmail documents to Google Drive and Sheets in Make or n8n

Automatically watch a Gmail label for new Rate Confirmation emails in Make. Send the email body and attachments to Drive, parse the PDF, then call Perplexity API to extract all load details as structured JSON. Parse that JSON in Make and map fields like pickup, delivery, rate, miles, equipment type, and attachment PDF link. Append each RateCon as a new row into a Google Sheets “Jobs” or “Loads” table for tracking.