Send Fixed-Price Gmail Quote Approvals in n8n (Data Tables)

Send fixed-price Gmail quote approvals from n8n—safely and idempotently

This n8n workflow authenticates fixed-price Gmail quote approvals, prevents replayed or ambiguous sends, and routes exceptions to the operations inbox—while also sweeping for stale review/pending-email states to keep your approval pipeline accurate.

What this workflow does

• Authenticates quote intake using the server-side QUOTE_INTAKE_TOKEN, rejecting malformed requests, array-shaped inputs, padded-scope payloads, and out-of-range requests before any state is accessed.
• Validates and fingerprints the quote by converting a versioned fixed price book into integer USD cents, deriving the exact workflow 08-compatible submission id, and creating a full request fingerprint.
• Detects duplicates and conflicts by reading all rows within the submission_id + onboarding_id + smoke_tag scope to distinguish new requests, exact replays, identity conflicts, and ambiguous duplicates.
• Persists send intent and verifies acknowledgement for either standard send or review-alert intent, ensuring the request matches the exact expected acknowledgement before Gmail actions.
• Sends only eligible standard offers when email and verified_email normalize to the same valid submitted address; otherwise it alerts the operations inbox only.
• Authenticates approvals separately with QUOTE_APPROVAL_TOKEN, records approve/reject evidence, and blocks expired, terminal, ambiguous, pending-send, unverified-recipient, and unknown-price rows.
• Confirms “offer as sent” only after Gmail provider evidence and an exact compare-and-set delivery acknowledgement.
• Runs an hourly sweep to capture stale review or pending-email state and records alert intent plus confirmed alert delivery in separate fields.

Use cases

• Automate fixed-price quote approvals where Gmail is the delivery channel.
• Prevent duplicate emails during network retries by enforcing fingerprint-based idempotency.
• Route approval exceptions to an operations inbox when recipient verification doesn’t match.

Technical details

• n8n Data Table: Create one Data Table named Quote_Offers using the exact columns from the workflow README, then re-select it in every Data T… node.
• Nodes/logic: if, code, webhook, gmail, data table, and sticky note.