{ "edges": [ { "to": "ef0aa4f9-5b08-47ec-a04d-1a5669d1b5e2", "from": "48461e38-d7ed-453c-9ea4-bd95394b5bf4", "toPort": "0", "fromPort": "0" }, { "to": "e4966a5f-518d-46c5-a96d-85db4aa1e0f3", "from": "eb7a600c-01d4-46bc-9963-065e690f8437", "toPort": "0", "fromPort": "0" }, { "to": "48461e38-d7ed-453c-9ea4-bd95394b5bf4", "from": "02e6f15b-f88a-46ca-a014-fd58877d8116", "toPort": "0", "fromPort": "ai_languageModel" }, { "to": "07f6d282-a7c6-430a-8941-6c726fdb5b68", "from": "4fb11931-4d3b-4e57-8344-a79db509a211", "toPort": "0", "fromPort": "0" }, { "to": "48461e38-d7ed-453c-9ea4-bd95394b5bf4", "from": "e88a4910-1596-4553-b5b4-52940d14973e", "toPort": "0", "fromPort": "0" }, { "to": "4fb11931-4d3b-4e57-8344-a79db509a211", "from": "b1a148ef-ac76-40f6-b1d0-2e8111004d07", "toPort": "0", "fromPort": "0" }, { "to": "d43feee7-beaf-43e3-9bb1-899ef7fc0280", "from": "e4966a5f-518d-46c5-a96d-85db4aa1e0f3", "toPort": "0", "fromPort": "0" }, { "to": "eb7a600c-01d4-46bc-9963-065e690f8437", "from": "24db74c3-ef2d-4115-b9da-07cc4b0b9125", "toPort": "0", "fromPort": "0" }, { "to": "e88a4910-1596-4553-b5b4-52940d14973e", "from": "dbb1366f-09ef-40b5-ab22-44113e668e28", "toPort": "0", "fromPort": "0" }, { "to": "b1a148ef-ac76-40f6-b1d0-2e8111004d07", "from": "90e39a29-8b34-4b92-92ab-a93099449b6a", "toPort": "0", "fromPort": "0" } ], "nodes": [ { "id": "eb7a600c-01d4-46bc-9963-065e690f8437", "name": "Fetch MR Sheet", "type": "integration", "params": { "options": {}, "service": "googleSheets", "filtersUI": { "values": [ { "lookupValue": "Pending", "lookupColumn": "Status" } ] }, "operation": "read", "sheetName": { "__rl": true, "mode": "list", "value": "gid=0", "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1VQD8qUpEv28IF7MUo9D8c9lTkI6csF_3jffTxpOXpPs/edit#gid=0", "cachedResultName": "Sheet1" }, "documentId": { "__rl": true, "mode": "list", "value": "1VQD8qUpEv28IF7MUo9D8c9lTkI6csF_3jffTxpOXpPs", "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1VQD8qUpEv28IF7MUo9D8c9lTkI6csF_3jffTxpOXpPs/edit?usp=drivesdk", "cachedResultName": "MRPlanWork" } }, "position": [ 224, 304 ] }, { "id": "e4966a5f-518d-46c5-a96d-85db4aa1e0f3", "name": "Send Plan Email to MR", "type": "integration", "params": { "sendTo": "={{ $json.Email }}", "message": "=Hello {{ $json.MR_Name }},\n\n

\n\nHere is your visit plan for today:\n\n

Doctor: {{ $json.Visit_Doctor }}
Location: {{ $json.Visit_Location }}

\n\nPlease update your visit status here:\n\nGoogle Form\n\n

\n\nHave a productive day!
\n- MR Automation System {{ $json.MR_Name }}", "options": {}, "service": "gmail", "subject": "=Your Visit Plan for Today – {{ $json.MR_Name }}", "operation": "read" }, "position": [ 448, 304 ] }, { "id": "b1a148ef-ac76-40f6-b1d0-2e8111004d07", "name": "Fetch Pending Records", "type": "integration", "params": { "options": {}, "service": "googleSheets", "filtersUI": { "values": [ { "lookupValue": "Pending", "lookupColumn": "Status" } ] }, "operation": "read", "sheetName": { "__rl": true, "mode": "list", "value": "gid=0", "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1VQD8qUpEv28IF7MUo9D8c9lTkI6csF_3jffTxpOXpPs/edit#gid=0", "cachedResultName": "Sheet1" }, "documentId": { "__rl": true, "mode": "list", "value": "1VQD8qUpEv28IF7MUo9D8c9lTkI6csF_3jffTxpOXpPs", "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1VQD8qUpEv28IF7MUo9D8c9lTkI6csF_3jffTxpOXpPs/edit?usp=drivesdk", "cachedResultName": "MRPlanWork" } }, "position": [ 144, 688 ] }, { "id": "4fb11931-4d3b-4e57-8344-a79db509a211", "name": "Send Reminder Email", "type": "integration", "params": { "sendTo": "={{ $json.Email }}", "message": "Hello {{ $json.MR_Name }},\n\n

\n\nThis is a friendly reminder to update your visit status in the Google Form before the day ends.\n\n
\n\nUpdate Visit Status\n\n

\n\nThank you,
\nMR Automation System", "options": {}, "service": "gmail", "subject": "Reminder – Please Update Today's Visit Status", "operation": "read" }, "position": [ 368, 688 ] }, { "id": "e88a4910-1596-4553-b5b4-52940d14973e", "name": "Fetch Form Responses", "type": "integration", "params": { "options": {}, "service": "googleSheets", "operation": "read", "sheetName": { "__rl": true, "mode": "list", "value": 2027534892, "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1VQD8qUpEv28IF7MUo9D8c9lTkI6csF_3jffTxpOXpPs/edit#gid=2027534892", "cachedResultName": "Form Responses 1" }, "documentId": { "__rl": true, "mode": "list", "value": "1VQD8qUpEv28IF7MUo9D8c9lTkI6csF_3jffTxpOXpPs", "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1VQD8qUpEv28IF7MUo9D8c9lTkI6csF_3jffTxpOXpPs/edit?usp=drivesdk", "cachedResultName": "MRPlanWork" } }, "position": [ 80, 1088 ] }, { "id": "ef0aa4f9-5b08-47ec-a04d-1a5669d1b5e2", "name": "Send Summary to Manager", "type": "integration", "params": { "sendTo": "user@example.com", "message": "={{\n(() => {\n // Helper: safe JSON parse\n function tryParseJson(s) {\n try {\n return JSON.parse(s);\n } catch (e) {\n return null;\n }\n }\n\n // 1) get raw output (handles array node, direct node, or nested)\n const candidateSources = [\n // n8n common shapes\n Array.isArray($json) && $json[0] ? $json[0] : null,\n $json,\n ];\n\n let raw = null;\n for (const cs of candidateSources) {\n if (!cs) continue;\n if (typeof cs.output === 'string' && cs.output.trim()) { raw = cs.output; break; }\n if (cs.email_body_html || cs.email_body_plain || cs.subject) { raw = cs; break; }\n // sometimes the node returns the JSON string in a field named 'summary' or 'text'\n if (typeof cs.summary === 'string' && cs.summary.trim()) { raw = cs.summary; break; }\n if (typeof cs.text === 'string' && cs.text.trim()) { raw = cs.text; break; }\n }\n\n // 2) If raw is a string that contains a fenced JSON block, extract it\n let parsed = null;\n if (typeof raw === 'string') {\n // extract code-fenced JSON ```json ... ```\n const fenceMatch = raw.match(/```(?:json)?\\s*([\\s\\S]*?)\\s*```/i);\n const jsonCandidate = fenceMatch ? fenceMatch[1].trim() : raw.trim();\n\n // try parse directly if it looks like JSON; otherwise try to find first { ... }\n parsed = tryParseJson(jsonCandidate);\n if (!parsed) {\n const firstBrace = jsonCandidate.indexOf('{');\n const lastBrace = jsonCandidate.lastIndexOf('}');\n if (firstBrace !== -1 && lastBrace !== -1 && lastBrace > firstBrace) {\n const possible = jsonCandidate.slice(firstBrace, lastBrace + 1);\n parsed = tryParseJson(possible);\n }\n }\n } else if (typeof raw === 'object' && raw !== null) {\n parsed = raw;\n }\n\n // If we still don't have parsed JSON, try $json directly\n if (!parsed) parsed = ($json && Object.keys($json).length ? $json : null);\n\n // 3) If parsing failed entirely, produce a simple fallback email\n if (!parsed) {\n const fallbackText = String(raw || 'Summary not available').replace(/\\n{2,}/g, '\\n\\n');\n const htmlFallback = `

Hello Manager,

Here is the MR summary (unparsed):

${escapeHtml(fallbackText)}

Regards,
MR Automation System

`;\n return htmlFallback;\n }\n\n // 4) If parsed already contains email_body_html or full HTML, use it directly\n if (parsed.email_body_html && String(parsed.email_body_html).trim()) {\n return String(parsed.email_body_html);\n }\n\n // 5) Build content from fields (subject, headline, bullets, details, actions, urgency)\n const subject = parsed.subject || parsed.title || `MR Update${parsed.MR || parsed['MR name'] ? `: ${parsed['MR name'] || parsed.MR}` : ''}`;\n const headline = parsed.headline || '';\n const bullets = Array.isArray(parsed.summary_bullets) ? parsed.summary_bullets : (parsed.summary ? (Array.isArray(parsed.summary) ? parsed.summary : String(parsed.summary).split('\\n').filter(Boolean)) : []);\n const details = parsed.details_paragraph || parsed.details || parsed.email_body_plain || '';\n const actions = Array.isArray(parsed.action_items) ? parsed.action_items : (parsed.action_items ? [parsed.action_items] : []);\n const urgency = parsed.urgency || parsed.Urgency || '';\n const mrName = parsed['MR name'] || parsed.MR || parsed.MR_ID || '';\n const rawFields = Array.isArray(parsed.raw_fields_used) ? parsed.raw_fields_used : (parsed.raw_fields_used ? [parsed.raw_fields_used] : []);\n const inferred = parsed.inferred_fields || {};\n\n // Helper: escape html\n function escapeHtml(s) {\n return String(s || '').replace(/[&<>\"']/g, function (m) {\n return ({'&':'&','<':'<','>':'>','\"':'"',\"'\":'''})[m];\n });\n }\n\n // Build HTML\n let html = '';\n html += `

`;\n html += `

Hello Manager,

`;\n html += `

${escapeHtml(subject)}

`;\n if (headline) html += `

${escapeHtml(headline)}

`;\n\n // urgency badge\n if (urgency) {\n const color = urgency.toLowerCase() === 'high' ? '#d9534f' : (urgency.toLowerCase() === 'medium' ? '#f0ad4e' : '#5cb85c');\n html += `

Urgency: ${escapeHtml(urgency)}

`;\n }\n\n // bullets\n if (bullets && bullets.length) {\n html += `

${escapeHtml(String(b))}

`;\n }\n\n // details paragraph\n if (details) {\n html += `

${escapeHtml(String(details)).replace(/\\n/g,'
')}

`;\n }\n\n // action items\n if (actions && actions.length) {\n html += `

Action Items:

`;\n html += `

${escapeHtml(String(a))}

`;\n }\n\n // metadata table (MR, timestamp, raw fields)\n html += ``;\n if (mrName) {\n html += ``;\n }\n if (parsed.Timestamp || parsed.Normalized_Timestamp || inferred.Normalized_Timestamp) {\n const ts = parsed.Normalized_Timestamp || parsed.Timestamp || inferred.Normalized_Timestamp;\n html += ``;\n }\n if (rawFields && rawFields.length) {\n html += ``;\n }\n // inferred fields\n if (inferred && Object.keys(inferred).length) {\n html += ``;\n }\n html += `

MR	${escapeHtml(mrName)}
Timestamp	${escapeHtml(ts)}
Fields used	${escapeHtml(rawFields.join(', '))}
Inferred	${escapeHtml(Object.entries(inferred).map(([k,v])=>k+': '+v).join(' '))}

`;\n\n // signature\n html += `

Regards,
MR Automation System${mrName ? `
Reported by ${escapeHtml(mrName)}` : ''}

`;\n html += `

`;\n\n // 6) Also create a plain-text fallback (optional but useful)\n // We return html only because many email nodes use the node output as html body.\n return html;\n})()\n}}\n", "options": { "appendAttribution": false }, "service": "gmail", "subject": "MR Daily Summary Report – {{ $now.toFormat('dd MMM yyyy') }}", "operation": "read" }, "position": [ 656, 1088 ] }, { "id": "48461e38-d7ed-453c-9ea4-bd95394b5bf4", "name": "AI Agent", "type": "llm", "params": { "text": "=You are an assistant that converts one MR visit record (JSON) into a concise manager update ready to send by email.\n\nInput: a single JSON object with fields like:\n \"row_number\",\"Timestamp\",\"MR name\",\"Date\",\"Doctor Name\",\"Visit Status\",\"Outcome(Rx Count)\",\"Samples Given\",\n \"Notes (Doctor Visit)\",\"Product Name\",\"Samples Distributed (Qty)\",\"Promotional Materials Used\",\"Remarks (Samples/Product)\",\n \"Total Doctor Calls Made Today\",\"Total Chemist Calls Made Today\",\"New Doctors Added Today\",\"Feedback Type\",\n \"Feedback Details\",\"CRM Updated?\",\"Samples Stock Updated?\",\"Daily Call Report Completed?\",\"Any support required from manager?\",\n \"Visit Status [Not Completed]\"\n\nInstructions:\n1. Read and normalize fields. If a value clearly belongs to another field (e.g., \"Date\" contains a person name), try to infer correct mapping and note the correction in \"raw_fields_used\".\n2. Infer doctor speciality from \"Visit Status\" and \"Notes (Doctor Visit)\". If you cannot infer, set speciality to \"Not specified\".\n3. Extract key facts:\n - MR_ID (from \"MR name\")\n - Timestamp (use \"Timestamp\" raw value; also convert to ISO YYYY-MM-DD HH:MM:SS if possible)\n - Doctor name and location/hospital (from \"Doctor Name\" and related fields)\n - Doctor speciality(s)\n - Key discussion topics and doctor interest (explicitly call out \"bulk order\" or \"product interest\" if present)\n - Outcome metrics (Rx Count, Samples Given, Samples Distributed)\n - CRM / Samples stock / Daily report status\n - Any manager support requested\n4. Determine urgency:\n - High: manager support requested OR bulk order confirmed & immediate approval/logistics needed.\n - Medium: doctor expressed interest (e.g., potential bulk order) but details missing.\n - Low: routine visit, no follow-up required.\n5. Produce ONE valid JSON object (no extra text) with these keys:\n{\n \"subject\": \"\",\n \"to\": \"\",\n \"headline\": \"\",\n \"summary_bullets\": [\"\", \"\", \"...\"],\n \"details_paragraph\": \"<1-2 short paragraphs, 40-80 words total>\",\n \"action_items\": [\"\", \"...\"],\n \"urgency\": \"\",\n \"email_body_plain\": \"\",\n \"email_body_html\": \"\",\n \"raw_fields_used\": [\"list of input field names used\"],\n \"inferred_fields\": {\"Doctor_Speciality\":\"...\", \"Normalized_Timestamp\":\"...\"} \n}\n6. Formatting rules:\n - subject: max 10 words, include MR ID and Doctor name.\n - headline: 8–12 words.\n - summary_bullets: 3–4 bullets, each ≤ 25 words.\n - details_paragraph: 1–2 paragraphs total ≤ 80 words explaining context and next steps.\n - action_items: 1–4 short, concrete steps, each imperative (e.g., \"MR to confirm quantity\").\n - email_body_plain: include a 1-line subject, the headline, bullets, details, and action items; close with \"Regards,\\n[MR Name]\" if MR name available.\n - If fields are missing, explicitly state which fields were missing inside \"details_paragraph\".\n7. Special flags:\n - If \"Visit Status\" or notes mention \"bulk order\", add action item: \"Confirm bulk order quantity & preferred SKUs\" and set urgency to at least Medium.\n - If \"CRM Updated?\" or \"Samples Stock Updated?\" is \"No\" or blank, add action item: \"Update CRM and Samples Stock\" and mark it in summary_bullets.\n - If \"Any support required from manager?\" is non-empty, include it verbatim as a top action item and set urgency to High unless text indicates otherwise.\n8. Output must be valid JSON only. Do not add any commentary or additional text.\n9. Use actual input field values when present (they will be referenced as {{$json[\"FIELD_NAME\"]}} in this environment); if a field is blank, omit it from \"raw_fields_used\".\n\nEnd of instructions.\n", "prompt": "=You are an assistant that converts one MR visit record (JSON) into a concise manager update ready to send by email.\n\nInput: a single JSON object with fields like:\n \"row_number\",\"Timestamp\",\"MR name\",\"Date\",\"Doctor Name\",\"Visit Status\",\"Outcome(Rx Count)\",\"Samples Given\",\n \"Notes (Doctor Visit)\",\"Product Name\",\"Samples Distributed (Qty)\",\"Promotional Materials Used\",\"Remarks (Samples/Product)\",\n \"Total Doctor Calls Made Today\",\"Total Chemist Calls Made Today\",\"New Doctors Added Today\",\"Feedback Type\",\n \"Feedback Details\",\"CRM Updated?\",\"Samples Stock Updated?\",\"Daily Call Report Completed?\",\"Any support required from manager?\",\n \"Visit Status [Not Completed]\"\n\nInstructions:\n1. Read and normalize fields. If a value clearly belongs to another field (e.g., \"Date\" contains a person name), try to infer correct mapping and note the correction in \"raw_fields_used\".\n2. Infer doctor speciality from \"Visit Status\" and \"Notes (Doctor Visit)\". If you cannot infer, set speciality to \"Not specified\".\n3. Extract key facts:\n - MR_ID (from \"MR name\")\n - Timestamp (use \"Timestamp\" raw value; also convert to ISO YYYY-MM-DD HH:MM:SS if possible)\n - Doctor name and location/hospital (from \"Doctor Name\" and related fields)\n - Doctor speciality(s)\n - Key discussion topics and doctor interest (explicitly call out \"bulk order\" or \"product interest\" if present)\n - Outcome metrics (Rx Count, Samples Given, Samples Distributed)\n - CRM / Samples stock / Daily report status\n - Any manager support requested\n4. Determine urgency:\n - High: manager support requested OR bulk order confirmed & immediate approval/logistics needed.\n - Medium: doctor expressed interest (e.g., potential bulk order) but details missing.\n - Low: routine visit, no follow-up required.\n5. Produce ONE valid JSON object (no extra text) with these keys:\n{\n \"subject\": \"\",\n \"to\": \"\",\n \"headline\": \"\",\n \"summary_bullets\": [\"\", \"\", \"...\"],\n \"details_paragraph\": \"<1-2 short paragraphs, 40-80 words total>\",\n \"action_items\": [\"\", \"...\"],\n \"urgency\": \"\",\n \"email_body_plain\": \"\",\n \"email_body_html\": \"\",\n \"raw_fields_used\": [\"list of input field names used\"],\n \"inferred_fields\": {\"Doctor_Speciality\":\"...\", \"Normalized_Timestamp\":\"...\"} \n}\n6. Formatting rules:\n - subject: max 10 words, include MR ID and Doctor name.\n - headline: 8–12 words.\n - summary_bullets: 3–4 bullets, each ≤ 25 words.\n - details_paragraph: 1–2 paragraphs total ≤ 80 words explaining context and next steps.\n - action_items: 1–4 short, concrete steps, each imperative (e.g., \"MR to confirm quantity\").\n - email_body_plain: include a 1-line subject, the headline, bullets, details, and action items; close with \"Regards,\\n[MR Name]\" if MR name available.\n - If fields are missing, explicitly state which fields were missing inside \"details_paragraph\".\n7. Special flags:\n - If \"Visit Status\" or notes mention \"bulk order\", add action item: \"Confirm bulk order quantity & preferred SKUs\" and set urgency to at least Medium.\n - If \"CRM Updated?\" or \"Samples Stock Updated?\" is \"No\" or blank, add action item: \"Update CRM and Samples Stock\" and mark it in summary_bullets.\n - If \"Any support required from manager?\" is non-empty, include it verbatim as a top action item and set urgency to High unless text indicates otherwise.\n8. Output must be valid JSON only. Do not add any commentary or additional text.\n9. Use actual input field values when present (they will be referenced as {{$json[\"FIELD_NAME\"]}} in this environment); if a field is blank, omit it from \"raw_fields_used\".\n\nEnd of instructions.\n", "options": {}, "provider": "openai", "promptType": "define", "approximated": true }, "position": [ 304, 1088 ] }, { "id": "02e6f15b-f88a-46ca-a014-fd58877d8116", "name": "OpenAI Chat Model", "type": "llm", "params": { "model": "gpt-4.1-mini", "options": {}, "provider": "openai" }, "position": [ 384, 1312 ] }, { "id": "d43feee7-beaf-43e3-9bb1-899ef7fc0280", "name": "Update row in sheet", "type": "integration", "params": { "columns": { "value": { "id": "={{ $('Fetch MR Sheet').item.json.id }}", "Date": "={{ $('Fetch MR Sheet').item.json.Date }}", "Email": "={{ $('Fetch MR Sheet').item.json.Email }}", "Status": "Assigned", "MR_Name": "={{ $('Fetch MR Sheet').item.json.MR_Name }}", "Form_Link": "={{ $('Fetch MR Sheet').item.json.Form_Link }}", "Visit_Doctor": "={{ $('Fetch MR Sheet').item.json.Visit_Doctor }}", "Visit_Location": "={{ $('Fetch MR Sheet').item.json.Visit_Location }}" }, "schema": [ { "id": "id", "type": "string", "display": true, "removed": false, "required": false, "displayName": "id", "defaultMatch": true, "canBeUsedToMatch": true }, { "id": "MR_Name", "type": "string", "display": true, "required": false, "displayName": "MR_Name", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Email", "type": "string", "display": true, "required": false, "displayName": "Email", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Visit_Doctor", "type": "string", "display": true, "required": false, "displayName": "Visit_Doctor", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Visit_Location", "type": "string", "display": true, "required": false, "displayName": "Visit_Location", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Form_Link", "type": "string", "display": true, "required": false, "displayName": "Form_Link", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Date", "type": "string", "display": true, "required": false, "displayName": "Date", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Status", "type": "string", "display": true, "required": false, "displayName": "Status", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "row_number", "type": "number", "display": true, "removed": true, "readOnly": true, "required": false, "displayName": "row_number", "defaultMatch": false, "canBeUsedToMatch": true } ], "mappingMode": "defineBelow", "matchingColumns": [ "id" ], "attemptToConvertTypes": false, "convertFieldsToString": false }, "options": {}, "service": "googleSheets", "operation": "update", "sheetName": { "__rl": true, "mode": "list", "value": "gid=0", "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1VQD8qUpEv28IF7MUo9D8c9lTkI6csF_3jffTxpOXpPs/edit#gid=0", "cachedResultName": "Sheet1" }, "documentId": { "__rl": true, "mode": "list", "value": "1VQD8qUpEv28IF7MUo9D8c9lTkI6csF_3jffTxpOXpPs", "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1VQD8qUpEv28IF7MUo9D8c9lTkI6csF_3jffTxpOXpPs/edit?usp=drivesdk", "cachedResultName": "MRPlanWork" } }, "position": [ 672, 304 ] }, { "id": "24db74c3-ef2d-4115-b9da-07cc4b0b9125", "name": "Schedule To Assign Work", "type": "trigger", "params": { "kind": "n8n-nodes-base.scheduleTrigger", "rule": { "interval": [ { "triggerAtHour": 9 } ] } }, "position": [ 0, 304 ] }, { "id": "90e39a29-8b34-4b92-92ab-a93099449b6a", "name": "Schedule For Remind Pending work", "type": "trigger", "params": { "kind": "n8n-nodes-base.scheduleTrigger", "rule": { "interval": [ { "triggerAtHour": 18 } ] } }, "position": [ -80, 688 ] }, { "id": "dbb1366f-09ef-40b5-ab22-44113e668e28", "name": "Schedule for Summary Update", "type": "trigger", "params": { "kind": "n8n-nodes-base.scheduleTrigger", "rule": { "interval": [ { "triggerAtHour": 23 } ] } }, "position": [ -144, 1088 ] }, { "id": "07f6d282-a7c6-430a-8941-6c726fdb5b68", "name": "Update row in sheet1", "type": "integration", "params": { "columns": { "value": { "id": "={{ $('Fetch Pending Records').item.json.id }}", "Date": "={{ $('Fetch Pending Records').item.json.Date }}", "Email": "={{ $('Fetch Pending Records').item.json.Email }}", "Status": "Assigned", "MR_Name": "={{ $('Fetch Pending Records').item.json.MR_Name }}", "Reminder": "Yes", "Form_Link": "={{ $('Fetch Pending Records').item.json.Form_Link }}", "VisitType": "={{ $('Fetch Pending Records').item.json.VisitType }}", "Speciality": "={{ $('Fetch Pending Records').item.json.Speciality }}", "Doctor name": "={{ $('Fetch Pending Records').item.json[\"Doctor name\"] }}", "Clinic/Hospital": "={{ $('Fetch Pending Records').item.json[\"Clinic/Hospital\"] }}", "Expected Outcome": "={{ $('Fetch Pending Records').item.json[\"Expected Outcome\"] }}", "Objective To Visit": "={{ $('Fetch Pending Records').item.json[\"Objective To Visit\"] }}" }, "schema": [ { "id": "id", "type": "string", "display": true, "removed": false, "required": false, "displayName": "id", "defaultMatch": true, "canBeUsedToMatch": true }, { "id": "MR_Name", "type": "string", "display": true, "required": false, "displayName": "MR_Name", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Email", "type": "string", "display": true, "required": false, "displayName": "Email", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Doctor name", "type": "string", "display": true, "removed": false, "required": false, "displayName": "Doctor name", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Speciality", "type": "string", "display": true, "removed": false, "required": false, "displayName": "Speciality", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Clinic/Hospital", "type": "string", "display": true, "removed": false, "required": false, "displayName": "Clinic/Hospital", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "VisitType", "type": "string", "display": true, "removed": false, "required": false, "displayName": "VisitType", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Objective To Visit", "type": "string", "display": true, "removed": false, "required": false, "displayName": "Objective To Visit", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Expected Outcome", "type": "string", "display": true, "removed": false, "required": false, "displayName": "Expected Outcome", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Form_Link", "type": "string", "display": true, "required": false, "displayName": "Form_Link", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Date", "type": "string", "display": true, "required": false, "displayName": "Date", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Status", "type": "string", "display": true, "required": false, "displayName": "Status", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Reminder", "type": "string", "display": true, "removed": false, "required": false, "displayName": "Reminder", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "row_number", "type": "number", "display": true, "removed": true, "readOnly": true, "required": false, "displayName": "row_number", "defaultMatch": false, "canBeUsedToMatch": true } ], "mappingMode": "defineBelow", "matchingColumns": [ "id" ], "attemptToConvertTypes": false, "convertFieldsToString": false }, "options": {}, "service": "googleSheets", "operation": "update", "sheetName": { "__rl": true, "mode": "list", "value": "gid=0", "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1VQD8qUpEv28IF7MUo9D8c9lTkI6csF_3jffTxpOXpPs/edit#gid=0", "cachedResultName": "Sheet1" }, "documentId": { "__rl": true, "mode": "list", "value": "1VQD8qUpEv28IF7MUo9D8c9lTkI6csF_3jffTxpOXpPs", "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1VQD8qUpEv28IF7MUo9D8c9lTkI6csF_3jffTxpOXpPs/edit?usp=drivesdk", "cachedResultName": "MRPlanWork" } }, "position": [ 592, 688 ] } ] }

Automate medical rep visit workflow with Google Sheets, Gmail & OpenAI summaries