Automate medical billing with Google Sheets and Gmail
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 9 nodes and runs when someone submits an n8n form. Along the way it connects Gmail and Google Sheets.
How it runs
Trigger: When someone submits an n8n form.
- Data Structure (Edit Fields (Set)): sets or maps fields
- Format Date (Code): runs custom JavaScript code
- Calculate prices (Code): runs custom JavaScript code
- Error Check (If): checks a condition and branches into true / false
- Generate Error Message (Edit Fields (Set)): sets or maps fields
- Send Patient Invoice Email (Gmail): uses Gmail
- Admin Notification (HTTP Request): calls an HTTP API
- Log Invoice to Googlesheets (Google Sheets): uses Google Sheets
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (7)
- Edit Fields (Set)
n8n-nodes-base.set - If
n8n-nodes-base.if - HTTP Request
n8n-nodes-base.httpRequest - n8n Form Trigger
n8n-nodes-base.formTrigger - Code
n8n-nodes-base.code - Gmail
n8n-nodes-base.gmail - Google Sheets
n8n-nodes-base.googleSheets
From the author
Automate Medical Billing with Google Sheets and Gmail Note: This template is designed for self-hosted n8n instances. The workflow image above shows the complete automation flow. This n8n workflow automates the patient billing process—from form submission to…