AI AGENTS

Attachment PDF Bid Extractor

When a supplier emails a quote as a PDF attachment, the flow saves it to Google Drive, extracts the line-item pricing, and writes a structured bid record into Coda.

CategoryAI Agents
Enginesim
Difficultyintermediate
Triggerevent
Steps5
Setup~15 min

How it runs

The automated pipeline, trigger to output.

  • TriggerEmail with quote PDF received in GmailGmailGmail
  • ActionSave attachment to Google Drive folderGoogle DriveGoogle Drive
  • ActionExtract line-item pricing from PDF with OpenAIOpenAI
  • LogicValidate totals, flag low-confidence parses
  • OutputWrite structured bid record to CodaCodaCoda

What it does

Handles the common case where suppliers send quotes as PDF attachments rather than typed email bodies. It archives the file, reads the line items out of the document, and turns it into a structured Coda bid record you can compare and rank.

When to use it

Use it when your suppliers respond to RFQs with formal quote PDFs and you want the pricing captured and filed automatically instead of opening and transcribing each attachment.

How it works

  1. 1An email carrying a quote PDF attachment in Gmail fires the trigger.
  2. 2The attachment is saved to a dated folder in Google Drive for the audit record.
  3. 3OpenAI reads the document and extracts line items, unit prices, totals, currency, and validity date into structured fields.
  4. 4Logic validates the totals add up and flags any document it couldn't parse confidently for human review.
  5. 5The structured bid is written to the Coda tracker with a link back to the stored PDF.

Set it up

What you configure once, before turning it on.

  1. 1
    Connect GmailRead, draft, send, label.
  2. 2
    Connect Google DriveDocs, sheets, slides, files.
  3. 3
    Connect OpenAIModels, embeddings, files.
  4. 4
    Connect CodaDocs, packs, automations.
  5. 5
    Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
  6. 6
    Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
  7. 7
    Test, then turn it onRun once against a sample, confirm the output, then enable the trigger.

Run this workflow in your colony.

14-day trial. No DevOps. No Sales call. Provisioned in under a minute.