Jan Oberhauser
Workflows by Jan Oberhauser
AI-powered WooCommerce Support-Agent
With this workflow you get a fully automated AI powered Support-Agent for your WooCommerce webshop. It allows customers to request information about things like: - the status of their order - the ordered products - shipping and billing address - current DHL shipping status **How it works** The workflow receives chat messages from an in a website integrated chat. For security and data-privacy reasons, does the website transmit the email address of the user encrypted with the requests. That ensures that user can just request the information about their own orders. An AI agent with a custom tool supplies the needed information. The tool calls a sub-workflow (in this case, in the same workflow for convenience) to retrieve the required information. This includes the full information of past orders plus the shipping information from DHL. If otherr shipping providers are used it should be simple to adjust the workflow to query information from other APIs like UPS, Fedex or others.
Create Asana ticket from terminal bash-dash
This workflow allows creating a new Asana task via [bash-dash](https://github.com/n8n-io/bash-dash)  **Example usage:** \- asana My new task **Example bash-dash config:** commands[asana]="http://localhost:5678/webhook/asana"
Weather check workflow for bash-dash
This workflow returns the current weather at a predefined or given city and returns it so that it can be displayed with [bash-dash](https://github.com/n8n-io/bash-dash). [](Link) By default does it return the weather in Berlin if no city got defined. That default can be changed in the "Set City" node. **Example usage:** \- weather london **Example bash-dash config:** commands[weather]="http://localhost:5678/webhook/weather"
Receive Google Sheet data via REST API
 Simple workflow which allows to receive data from a Google Sheet via "REST" endpoint. 1. Wait for Webhook Call 1. Get data from Google Sheet 1. Return data Example Sheet: [https://docs.google.com/spreadsheets/d/17fzSFl1BZ1njldTfp5lvh8HtS0-pNXH66b7qGZIiGRU](https://docs.google.com/spreadsheets/d/17fzSFl1BZ1njldTfp5lvh8HtS0-pNXH66b7qGZIiGRU)
Send trending "Show HN" to email
 1. Triggers every day at 1pm 1. Gets the current content from Hacker News 1. Gets all the different submission items 1. Extracts the rank, title and url 1. Checks if it is a "Show HN" submission 1. Combines the items into a simple email text 1. Sends an email with the email text
API queries data from GraphQL
 Simpe API which queries the received country code via GraphQL and returns it. Example URL: [https://n8n.exampl.ecom/webhook/1/webhook/webhook?code=DE](https://n8n.exampl.ecom/webhook/1/webhook/webhook?code=DE) 1. Receives country code from an incoming HTTP Request 1. Reads data via GraphQL 1. Converts the data to JSON 1. Constructs return string
Convert Typeform data into spreadsheet
1. Trigger on new Typeform form submission 1. Get existing spreadsheet-file from NextCloud 1. Read data from file into flow 1. Append a new row to flow-data 1. Convert flow-data to a spreadsheet-file 1. Save updated spreadsheet-file to NextCloud  # Assumptions ## Spreadsheet file Named: Problems.xls in folder "examples". Columns Names: - Name - Email - Severity - Problem  # Typeform Typeform formular with questions named exactly like the columns of the Google Sheet.
Webhook returning XML
 1. Receives data from an incoming HTTP Request (set up to use respond to webhook node) 1. Create dummy data 1. Convert JSON to XML which gets returned 1. Respond to Webhook which returns the data and the content type of the data
Send Typeform results to Google Sheet, Slack and email
 1. Trigger on new Typeform form submission 2. Write data to Google Sheet 3. Check severity of problem 4. If very severe post message to Slack 5. If not so severe just send an email ## Assumptions ### Google Sheet Sheet in Spreadsheet called "Problems". Columns Names: - Name - Email - Severity - Problem Example Sheet: [https://docs.google.com/spreadsheets/d/17fzSFl1BZ1njldTfp5lvh8HtS0-pNXH66b7qGZIiGRU](https://docs.google.com/spreadsheets/d/17fzSFl1BZ1njldTfp5lvh8HtS0-pNXH66b7qGZIiGRU)  ### Typeform Typeform formular with questions named exactly like the columns of the Google Sheet.