Quote junk removal from texted photos with Twilio, OpenAI and Google
Ready for 3.0What this workflow does
This AI workflow has 58 nodes and runs when an HTTP POST request hits its webhook URL (plus 2 other triggers). Along the way it connects Google Sheets, Twilio, Google Drive and OpenAI and 2 more.
How it runs
Trigger: When an HTTP POST request hits its webhook URL (plus 2 other triggers).
- Your settings (Edit Fields (Set)): sets 12 fields: business_name, twilio_number, owner_cell…
- Read your settings (Code): runs custom JavaScript code
- What started this? (Switch): routes items into 3 branches
- Tell Twilio we got it (Respond to Webhook): sends the response back to the webhook caller
- Read all quotes (Google Sheets): read
- Create the spreadsheet (Google Sheets): create (spreadsheet)
- Read the quotes (Google Sheets): read
- Find what needs a nudge (Code): runs custom JavaScript code
- Example prices (Code): runs custom JavaScript code
- Who texted? (If): checks a condition and branches into true / false
…plus 43 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 (18)
- Webhook
n8n-nodes-base.webhook - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Manual Trigger
n8n-nodes-base.manualTrigger - Edit Fields (Set)
n8n-nodes-base.set - Code
n8n-nodes-base.code - Switch
n8n-nodes-base.switch - Respond to Webhook
n8n-nodes-base.respondToWebhook - Google Sheets
n8n-nodes-base.googleSheets - If
n8n-nodes-base.if - Split Out
n8n-nodes-base.splitOut - Twilio
n8n-nodes-base.twilio - HTTP Request
n8n-nodes-base.httpRequest - Google Drive
n8n-nodes-base.googleDrive - OpenAI
@n8n/n8n-nodes-langchain.openAi - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Google Calendar
n8n-nodes-base.googleCalendar
From the author
Quick overview Customers text photos of a pile to your Twilio number. OpenAI describes it and matches it to your price list in Google Sheets; the total is added up in code. Big or odd jobs wait for your YES by text. YES plus a day books a Google Calendar…