Automate invoice creation & smart reminders with Jotform, QuickBooks & Outlook AI
Ready for 3.0What this workflow does
This AI workflow has 27 nodes and runs when an HTTP POST request hits its webhook URL (plus 1 other trigger). Along the way it connects QuickBooks Online, OpenAI Chat Model and Microsoft Outlook.
How it runs
Trigger: When an HTTP POST request hits its webhook URL (plus 1 other trigger).
- Format data (Code): runs custom JavaScript code
- Add reminders config (Edit Fields (Set)): sets or maps fields
- Check if the customer exists (QuickBooks Online): get many
- If: checks a condition and branches into true / false
- If: checks a condition and branches into true / false
- Insert invoice id to DB (Data table): uses Data table
- Get Invoices (Data table): get
- Update the customer (QuickBooks Online): update
- Create the customer (QuickBooks Online): create
- Loop over invoices (Loop Over Items (Split in Batches)): loops over the items in batches
…plus 14 more steps. See the full node list below.
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 (12)
- Webhook
n8n-nodes-base.webhook - If
n8n-nodes-base.if - QuickBooks Online
n8n-nodes-base.quickbooks - Code
n8n-nodes-base.code - Edit Fields (Set)
n8n-nodes-base.set - Data table
n8n-nodes-base.dataTable - AI Agent
@n8n/n8n-nodes-langchain.agent - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Switch
n8n-nodes-base.switch - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Microsoft Outlook
n8n-nodes-base.microsoftOutlook
From the author
Generate Invoices and Send Reminders for Customers with Jotform, QuickBooks and Outlook This workflow automates the entire process of receiving a product/service order, checking or creating a customer in QuickBooks Online (QBO), generating an invoice,…