Conversation Operations
Turn reviewed call notes into an owned handoff — Google Sheets RAW review row
Return a normalized summary and ordered action packet, flagging unowned or undated actions for review. Consume already reviewed structured notes; do not claim transcript extraction or task creation. Prepare a Google Sheets RAW review row.
Experimental native example · local preview · revision 1
WORKFLOW PREVIEW
See how it works
Use + and − to zoom, F to fit. Press Enter on a node to inspect it.
Private preview. These tested drafts are available for inspection. Adding them to a Vora workspace is still being tested.
What you need
- Authorized supplied job facts matching the original closed input contract.
- Explicit review metadata and target destination fields; no implicit team, channel, list or project selection.
Follow the workflow step by step
Supplied agency job and review metadata
Receive the explicitly supplied manual input packet.
Turn reviewed call notes into an owned handoff
Return a normalized summary and ordered action packet, flagging unowned or undated actions for review. Consume already reviewed structured notes; do not claim transcript extraction or task creation.
- default: Google Sheets RAW review row
Google Sheets RAW review row
Return a normalized summary and ordered action packet, flagging unowned or undated actions for review. Consume already reviewed structured notes; do not claim transcript extraction or task creation.
Setup and review
- Download the workflow JSON and inspect its jobInput and deliveryMetadata contracts.
- Supply the original agency job input plus explicit review metadata and destination.
- Run in an isolated test and inspect the complete jobResult, target status, holds and escape report before taking an external action.
Inspect every node
Expand a node to inspect its complete settings. Review the runtime and adoption evidence before installing it.
Supplied agency job and review metadata · wfManualTrigger
{
"label": "Supplied agency job and review metadata"
}Turn reviewed call notes into an owned handoff · code
{
"label": "Turn reviewed call notes into an owned handoff",
"code": "return (function(context){\n\nfunction obj(value, keys, required = keys) {\n if (!value || typeof value !== 'object' || Array.isArray(value)) throw new Error('Expected object');\n if (Object.keys(value).some(key => !keys.includes(key))) throw new Error('Unknown input field');\n if (required.some(key => !Object.hasOwn(value, key))) throw new Error('Missing required input field');\n return value;\n}\nfunction text(value, name, max = 200, allowEmpty = false) {\n if (typeof value !== 'string' || value.length > max || (!allowEmpty && !value.trim())) throw new Error('Invalid ' + name);\n return value.trim();\n}\nfunction list(value, name, max = 500) {\n if (!Array.isArray(value) || value.length > max) throw new Error('Invalid ' + name);\n return value;\n}\nfunction int(value, name, min = 0, max = Number.MAX_SAFE_INTEGER) {\n if (!Number.isSafeInteger(value) || value < min || value > max) throw new Error('Invalid ' + name);\n return value;\n}\nfunction amount(value, name) {\n if (!Number.isFinite(value) || value < 0 || value > 1000000000) throw new Error('Invalid ' + name);\n return value;\n}\nfunction email(value) { return /^[^\\s@]+@[^\\s@]+\\.[^\\s@]+$/.test(value); }\nfunction day(value) {\n if (typeof value !== 'string' || !/^\\d{4}-\\d{2}-\\d{2}$/.test(value)) throw new Error('Invalid calendar date');\n const ms = Date.parse(value + 'T00:00:00Z');\n if (!Number.isFinite(ms) || new Date(ms).toISOString().slice(0, 10) !== value) throw new Error('Invalid calendar date');\n return ms;\n}\nfunction instant(value) {\n if (typeof value !== 'string' || !/^\\d{4}-\\d{2}-\\d{2}T\\d{2}:\\d{2}:\\d{2}(\\.\\d{3})?Z$/.test(value)) throw new Error('Invalid UTC timestamp');\n const ms = Date.parse(value);\n const normalized = value.includes('.') ? value : value.replace('Z', '.000Z');\n if (!Number.isFinite(ms) || new Date(ms).toISOString() !== normalized) throw new Error('Invalid UTC timestamp');\n return ms;\n}\nfunction uniqueIds(items) {\n const ids = items.map(item => text(item.id, 'item ID', 120));\n if (new Set(ids).size !== ids.length) throw new Error('Duplicate item ID');\n return ids;\n}\nfunction ratioBps(numerator, denominator) {\n const n = BigInt(numerator) * 10000n;\n const d = BigInt(denominator);\n const quotient = n / d;\n const floor = n < 0n && n % d !== 0n ? quotient - 1n : quotient;\n const result = Number(floor);\n if (!Number.isSafeInteger(result)) throw new Error('Unsafe calculated ratio');\n return result;\n}\n\n\nconst x = obj(context.input, ['callId','summary','actions']);\nconst callId = text(x.callId, 'call ID', 120);\nconst summary = text(x.summary, 'summary', 4000).replace(/\\s+/g, ' ');\nconst items = list(x.actions, 'actions', 100);\nitems.forEach(item => obj(item, ['id','text','ownerId','dueDate']));\nconst ids = uniqueIds(items);\nconst actions = items.map((item,index) => {\n const actionText = text(item.text, 'action text', 1000).replace(/\\s+/g, ' ');\n const ownerId = text(item.ownerId, 'owner ID', 120, true), dueDate = text(item.dueDate, 'due date', 10, true);\n if (dueDate) day(dueDate);\n const reviewReasons = [];\n if (!ownerId) reviewReasons.push('missing_owner');\n if (!dueDate) reviewReasons.push('missing_due_date');\n return {id:ids[index], text:actionText, ownerId, dueDate, reviewReasons};\n});\nconst status = !actions.length ? 'no_actions' : actions.some(item => item.reviewReasons.length) ? 'review' : 'ready';\nreturn {callId, summary, actions, status};\n\n})({input:context.input.jobInput});\n",
"outputVar": "jobResult",
"timeout": 3000,
"memoryLimit": 64
}Google Sheets RAW review row · code
{
"label": "Google Sheets RAW review row",
"code": "const jobResult=context.jobResult;\nconst delivery=(function(context){\nreturn ((function(originalResult,metadata,destination){\nfunction stableResult(value,depth=0){\n if(depth>64)throw new Error('Result nesting exceeds 64');\n if(value===null||typeof value==='string'||typeof value==='boolean')return JSON.stringify(value);\n if(typeof value==='number'&&Number.isFinite(value))return JSON.stringify(value);\n if(Array.isArray(value)){\n if(Object.keys(value).length!==value.length||Array.from({length:value.length},(_,i)=>i).some(i=>!Object.hasOwn(value,i)))throw new Error('Result contains sparse data');\n return '['+value.map(item=>stableResult(item,depth+1)).join(',')+']';\n }\n if(value&&typeof value==='object')return '{'+Object.keys(value).sort().map(key=>JSON.stringify(key)+':'+stableResult(value[key],depth+1)).join(',')+'}';\n throw new Error('Result is not JSON data');\n}\nfunction utf8Length(text){\n let bytes=0;\n for(let i=0;i<text.length;i++){\n const code=text.charCodeAt(i);\n if(code<128)bytes++;else if(code<2048)bytes+=2;\n else if(code>=55296&&code<=56319&&i+1<text.length&&text.charCodeAt(i+1)>=56320&&text.charCodeAt(i+1)<=57343){bytes+=4;i++;}\n else bytes+=3;\n }\n return bytes;\n}\nfunction chunkText(text,maximum){\n const chunks=[];\n for(let start=0;start<text.length;){let end=Math.min(start+maximum,text.length);const last=text.charCodeAt(end-1),next=text.charCodeAt(end);if(end<text.length&&last>=55296&&last<=56319&&next>=56320&&next<=57343)end--;chunks.push(text.slice(start,end));start=end;}\n return chunks;\n}\nfunction deliveryState(rendererId,originalResult,metadata,destination,destinationKeys){\n const output={rendererId,status:'HELD',originalResult,drafts:[],holds:[],escapeReport:[]};\n const hold=(code,message)=>{output.holds.push({code,message});return {output,json:''};};\n const object=value=>value&&typeof value==='object'&&!Array.isArray(value);\n const exact=(value,keys)=>object(value)&&Object.keys(value).length===keys.length&&keys.every(key=>Object.hasOwn(value,key));\n const keys=['workflowId','canonicalIntentId','title','reviewUrl'],maxima=[128,200,200,1000];\n if(!exact(metadata,keys)||keys.some((key,i)=>typeof metadata[key]!=='string'||!metadata[key].length||metadata[key].length>maxima[i]||/[\\u0000-\\u001f\\u007f]/.test(metadata[key]))||!/^https?:\\/\\/[^\\s<>\"']+$/.test(metadata.reviewUrl))return hold('INVALID_METADATA','Metadata must provide bounded workflowId, canonicalIntentId, title and an HTTP(S) reviewUrl.');\n if(!exact(destination,destinationKeys)||destinationKeys.some(key=>typeof destination[key]!=='string'||!destination[key].length||destination[key].length>200||destination[key]!==destination[key].trim()||/[\\u0000-\\u001f\\u007f]/.test(destination[key])))return hold('INVALID_DESTINATION','Destination fields must be exactly: '+destinationKeys.join(', ')+'.');\n let json;\n try{if(!object(originalResult))throw new Error('Primary result must be a JSON object');json=stableResult(originalResult);}catch(error){return hold('INVALID_RESULT',error.message);}\n if(json.length>32768||utf8Length(json)>65536)return hold('RESULT_BOUND_EXCEEDED','Original result exceeds this renderer profile; full original result is retained.');\n return {output,json};\n}\nreturn (function googleSheetsReviewValues(originalResult,metadata,destination){\n const state=deliveryState('google-sheets-review-values',originalResult,metadata,destination,['spreadsheetId','range']);\n if(state.output.holds.length)return state.output;\n const draft={spreadsheetId:destination.spreadsheetId,valueInputOption:'RAW',body:{range:destination.range,majorDimension:'ROWS',values:[['workflowId','canonicalIntentId','title','reviewUrl','resultJson'],[metadata.workflowId,metadata.canonicalIntentId,metadata.title,metadata.reviewUrl,state.json]]}};\n if(utf8Length(JSON.stringify(draft))>131072){state.output.holds.push({code:'TARGET_BOUND_EXCEEDED',message:'Sheets draft exceeds the Vora payload profile bound; no draft is emitted.'});return state.output;}\n state.output.status='PREPARED';state.output.drafts=[draft];return state.output;\n})(originalResult,metadata,destination);\n}))(context.input.jobResult,context.input.deliveryMetadata.metadata,context.input.deliveryMetadata.destination);\n\n})({input:{jobResult,deliveryMetadata:context.input.deliveryMetadata}});\nreturn {jobResult,delivery};\n",
"outputVar": "result",
"timeout": 3000,
"memoryLimit": 64
}Input and output contracts
Input
{
"type": "object",
"properties": {
"jobInput": {
"additionalProperties": false,
"properties": {
"actions": {
"items": {
"additionalProperties": false,
"properties": {
"dueDate": {
"maxLength": 10,
"type": "string"
},
"id": {
"maxLength": 120,
"type": "string"
},
"ownerId": {
"maxLength": 120,
"type": "string"
},
"text": {
"maxLength": 1000,
"type": "string"
}
},
"required": [
"id",
"text",
"ownerId",
"dueDate"
],
"type": "object"
},
"maxItems": 100,
"type": "array"
},
"callId": {
"maxLength": 120,
"type": "string"
},
"summary": {
"maxLength": 4000,
"type": "string"
}
},
"required": [
"callId",
"summary",
"actions"
],
"type": "object"
},
"deliveryMetadata": {
"type": "object",
"properties": {
"metadata": {
"type": "object",
"properties": {
"workflowId": {
"type": "string",
"maxLength": 128
},
"canonicalIntentId": {
"type": "string",
"maxLength": 200
},
"title": {
"type": "string",
"maxLength": 200
},
"reviewUrl": {
"type": "string",
"maxLength": 1000
}
},
"required": [
"workflowId",
"canonicalIntentId",
"title",
"reviewUrl"
],
"additionalProperties": false
},
"destination": {
"type": "object",
"properties": {
"spreadsheetId": {
"type": "string",
"maxLength": 200
},
"range": {
"type": "string",
"maxLength": 200
}
},
"required": [
"spreadsheetId",
"range"
],
"additionalProperties": false
}
},
"required": [
"metadata",
"destination"
],
"additionalProperties": false
}
},
"required": [
"jobInput",
"deliveryMetadata"
],
"additionalProperties": false
}Output
{
"type": "object",
"properties": {
"jobResult": {
"additionalProperties": false,
"properties": {
"actions": {
"items": {
"additionalProperties": false,
"properties": {
"dueDate": {
"maxLength": 10,
"type": "string"
},
"id": {
"maxLength": 120,
"type": "string"
},
"ownerId": {
"maxLength": 120,
"type": "string"
},
"reviewReasons": {
"items": {
"maxLength": 200,
"type": "string"
},
"maxItems": 2,
"type": "array"
},
"text": {
"maxLength": 1000,
"type": "string"
}
},
"required": [
"id",
"text",
"ownerId",
"dueDate",
"reviewReasons"
],
"type": "object"
},
"maxItems": 100,
"type": "array"
},
"callId": {
"maxLength": 120,
"type": "string"
},
"status": {
"maxLength": 20,
"type": "string"
},
"summary": {
"maxLength": 4000,
"type": "string"
}
},
"required": [
"callId",
"summary",
"actions",
"status"
],
"type": "object"
},
"delivery": {
"type": "object",
"properties": {
"rendererId": {
"type": "string",
"maxLength": 128,
"enum": [
"google-sheets-review-values"
]
},
"status": {
"type": "string",
"maxLength": 16,
"enum": [
"PREPARED",
"HELD"
]
},
"originalResult": {
"additionalProperties": false,
"properties": {
"actions": {
"items": {
"additionalProperties": false,
"properties": {
"dueDate": {
"maxLength": 10,
"type": "string"
},
"id": {
"maxLength": 120,
"type": "string"
},
"ownerId": {
"maxLength": 120,
"type": "string"
},
"reviewReasons": {
"items": {
"maxLength": 200,
"type": "string"
},
"maxItems": 2,
"type": "array"
},
"text": {
"maxLength": 1000,
"type": "string"
}
},
"required": [
"id",
"text",
"ownerId",
"dueDate",
"reviewReasons"
],
"type": "object"
},
"maxItems": 100,
"type": "array"
},
"callId": {
"maxLength": 120,
"type": "string"
},
"status": {
"maxLength": 20,
"type": "string"
},
"summary": {
"maxLength": 4000,
"type": "string"
}
},
"required": [
"callId",
"summary",
"actions",
"status"
],
"type": "object"
},
"drafts": {
"type": "array",
"items": {
"type": "object",
"properties": {
"spreadsheetId": {
"type": "string",
"maxLength": 200
},
"valueInputOption": {
"type": "string",
"maxLength": 16,
"enum": [
"RAW"
]
},
"body": {
"type": "object",
"properties": {
"range": {
"type": "string",
"maxLength": 200
},
"majorDimension": {
"type": "string",
"maxLength": 16,
"enum": [
"ROWS"
]
},
"values": {
"type": "array",
"items": {
"type": "array",
"items": {
"type": "string",
"maxLength": 32768
},
"maxItems": 5,
"minItems": 5
},
"maxItems": 2,
"minItems": 2
}
},
"required": [
"range",
"majorDimension",
"values"
],
"additionalProperties": false
}
},
"required": [
"spreadsheetId",
"valueInputOption",
"body"
],
"additionalProperties": false
},
"maxItems": 1,
"minItems": 0
},
"holds": {
"type": "array",
"items": {
"type": "object",
"properties": {
"code": {
"type": "string",
"maxLength": 128
},
"message": {
"type": "string",
"maxLength": 2000
}
},
"required": [
"code",
"message"
],
"additionalProperties": false
},
"maxItems": 10,
"minItems": 0
},
"escapeReport": {
"type": "array",
"items": {
"type": "object",
"properties": {
"field": {
"type": "string",
"maxLength": 256
},
"method": {
"type": "string",
"maxLength": 80
},
"originalValue": {
"type": "string",
"maxLength": 32768
},
"escapedValue": {
"type": "string",
"maxLength": 32768
}
},
"required": [
"field",
"method",
"originalValue",
"escapedValue"
],
"additionalProperties": false
},
"maxItems": 1000,
"minItems": 0
}
},
"required": [
"rendererId",
"status",
"originalResult",
"drafts",
"holds",
"escapeReport"
],
"additionalProperties": false
}
},
"required": [
"jobResult",
"delivery"
],
"additionalProperties": false
}Related implementations
Compare implementations for this job · Primary business workflow
Caller-supplied spreadsheetId and A1 range identify the draft destination. Header and full review row use majorDimension ROWS and valueInputOption RAW; formula-like strings remain literal. Original result, including original reasons/holds, is preserved without mutation. Missing/extra destination fields or invalid metadata hold the draft. No truncation: overflow returns HELD with an empty drafts array and full original result.
Supplied input: vora-agency-call-handoff-packet · 1. Draft/result: google-sheets-review-values · Google Sheets REST v4, reviewed 2026-10-08.
Mapping and loss rules
- Caller-supplied spreadsheetId and A1 range identify the draft destination.
- Header and full review row use majorDimension ROWS and valueInputOption RAW; formula-like strings remain literal.
- Original result, including original reasons/holds, is preserved without mutation.
- Missing/extra destination fields or invalid metadata hold the draft.
- No truncation: overflow returns HELD with an empty drafts array and full original result.
This binding consumes supplied data. It does not establish an authenticated connector or a provider write.
Example input and result
These examples use synthetic data.
Input
{
"jobInput": {
"callId": "call-01",
"summary": " Buyer requested a pilot. ",
"actions": [
{
"id": "a1",
"text": "Send the approved scope",
"ownerId": "owner-01",
"dueDate": "2026-10-09"
}
]
},
"deliveryMetadata": {
"metadata": {
"workflowId": "agency-call-handoff-packet",
"canonicalIntentId": "conversation.prepare-owned-handoff",
"title": "Turn reviewed call notes into an owned handoff",
"reviewUrl": "https://example.test/workflows/call-handoff-packet/"
},
"destination": {
"spreadsheetId": "sheet-review",
"range": "Review!A1:E2"
}
}
}Expected result
{
"jobResult": {
"callId": "call-01",
"summary": "Buyer requested a pilot.",
"actions": [
{
"id": "a1",
"text": "Send the approved scope",
"ownerId": "owner-01",
"dueDate": "2026-10-09",
"reviewReasons": []
}
],
"status": "ready"
},
"delivery": {
"rendererId": "google-sheets-review-values",
"status": "PREPARED",
"originalResult": {
"callId": "call-01",
"summary": "Buyer requested a pilot.",
"actions": [
{
"id": "a1",
"text": "Send the approved scope",
"ownerId": "owner-01",
"dueDate": "2026-10-09",
"reviewReasons": []
}
],
"status": "ready"
},
"drafts": [
{
"spreadsheetId": "sheet-review",
"valueInputOption": "RAW",
"body": {
"range": "Review!A1:E2",
"majorDimension": "ROWS",
"values": [
[
"workflowId",
"canonicalIntentId",
"title",
"reviewUrl",
"resultJson"
],
[
"agency-call-handoff-packet",
"conversation.prepare-owned-handoff",
"Turn reviewed call notes into an owned handoff",
"https://example.test/workflows/call-handoff-packet/",
"{\"actions\":[{\"dueDate\":\"2026-10-09\",\"id\":\"a1\",\"ownerId\":\"owner-01\",\"reviewReasons\":[],\"text\":\"Send the approved scope\"}],\"callId\":\"call-01\",\"status\":\"ready\",\"summary\":\"Buyer requested a pilot.\"}"
]
]
}
}
],
"holds": [],
"escapeReport": []
}
}Success means: Return a normalized summary and ordered action packet, flagging unowned or undated actions for review. Consume already reviewed structured notes; do not claim transcript extraction or task creation.
When something goes wrong
- Review original business holds and target holds separately. Correct the relevant supplied input and rerun without discarding the original job result.
Limits and costs
- This prepares a target-specific review draft from the original agency decision. The complete original job result and business holds remain visible. A held target produces no draft. No provider request, send, import, issue creation or publication occurs.
- No paid model calls or metered third-party operations are declared in this pure graph. Vora plan availability, compute and quotas still apply; pricing has not been verified by this batch.