{"product_id":"n8n-workflow-monitor-google-drive-vendor-pdfs-to-sheets","title":"n8n Workflow: Monitor Google Drive Vendor PDFs to Sheets","description":"\u003ch3\u003eAuto-classify vendor compliance PDFs in Google Drive—and keep Sheets, Slack, and email in sync\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow watches a \u003cstrong\u003eGoogle Drive\u003c\/strong\u003e “Vendor Compliance Inbox” for new vendor compliance PDF files, extracts key details with \u003cstrong\u003eOpenAI\u003c\/strong\u003e, records everything in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, alerts your team in \u003cstrong\u003eSlack\u003c\/strong\u003e when review is needed, and runs a daily compliance check that sends vendor reminders and a digest via \u003cstrong\u003eGmail\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMonitors a Google Drive folder\u003c\/strong\u003e and triggers as soon as a new file is created in the “Vendor Compliance Inbox”.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates file type\u003c\/strong\u003e: if the uploaded file is not a PDF, it posts a \u003cstrong\u003eSlack\u003c\/strong\u003e message and skips processing.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eExtracts document fields\u003c\/strong\u003e: downloads the PDF, extracts its text, then uses an \u003cstrong\u003eOpenAI chat model\u003c\/strong\u003e to classify and extract vendor name, issuer, issue\/expiry dates, coverage amount, summary, and confidence.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMatches to your vendor records\u003c\/strong\u003e: compares extracted data against the \u003cstrong\u003eVendors\u003c\/strong\u003e tab in Google Sheets, validates results (e.g., missing expiry or low confidence), and \u003cstrong\u003eupserts\u003c\/strong\u003e the record into the \u003cstrong\u003eDocuments\u003c\/strong\u003e tab.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRoutes exceptions for human review\u003c\/strong\u003e: posts a \u003cstrong\u003eSlack alert\u003c\/strong\u003e when there’s no vendor match, partial match, low confidence, missing expiry for expiring document types, or bank information concerns.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns daily compliance checks at 8 AM\u003c\/strong\u003e: reads \u003cstrong\u003evendors\u003c\/strong\u003e and \u003cstrong\u003edocuments\u003c\/strong\u003e from Google Sheets, evaluates active vendors against tier-based requirements, appends results to the \u003cstrong\u003eCompliance Log\u003c\/strong\u003e tab, and triggers:\n    \u003cul\u003e\n      \u003cli\u003e\n\u003cstrong\u003eVendor reminders via Gmail\u003c\/strong\u003e when reminders are due\u003c\/li\u003e\n      \u003cli\u003e\n\u003cstrong\u003eA daily compliance digest\u003c\/strong\u003e to the compliance owner via \u003cstrong\u003eGmail\u003c\/strong\u003e and a summary message via \u003cstrong\u003eSlack\u003c\/strong\u003e\n\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eCentralizing insurance\/vendor compliance intake by automatically processing newly uploaded compliance PDFs.\u003c\/li\u003e\n  \u003cli\u003eReducing manual spreadsheet work by extracting, matching, and updating Google Sheets documents automatically.\u003c\/li\u003e\n  \u003cli\u003eImproving compliance reliability with Slack-based exception handling and a daily 8 AM audit + reminder cycle.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Drive\u003c\/strong\u003e trigger for new files in the “Vendor Compliance Inbox” folder\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePDF text extraction\u003c\/strong\u003e + \u003cstrong\u003eOpenAI\u003c\/strong\u003e chat classification and field extraction\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e updates: “Vendors”, “Documents”, and “Compliance Log” tabs\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSlack\u003c\/strong\u003e alerts for skipped files and items requiring human review\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGmail\u003c\/strong\u003e emails for vendor reminders and the daily compliance digest\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWorkflow logic nodes\u003c\/strong\u003e include if, set, code, gmail, slack, and filter\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46153937256627,"sku":"N8N-20324","price":6.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/wLJhXzx1Dt64tU3MrywlZ_tzsDzwC4.png?v=1790931775","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-monitor-google-drive-vendor-pdfs-to-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}