Jan Oberhauser
Founder/CEO of n8n
Categories
Templates by Jan Oberhauser
Telegram sticker bot
Gets triggered by Telegram once a user sends a message Checks if the message contains a sticker If a sticker got found it sends a message with its ID else it informs the user that no sticker was found in message
By Jan OberhauserReceive Google Sheet data via REST API
Simple workflow which allows to receive data from a Google Sheet via "REST" endpoint. Wait for Webhook Call Get data from Google Sheet Return data Example Sheet: https://docs.google.com/spreadsheets/d/17fzSFl1BZ1njldTfp5lvh8HtS0-pNXH66b7qGZIiGRU
By Jan OberhauserAPI 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 Receives country code from an incoming HTTP Request Reads data via GraphQL Converts the data to JSON Constructs return string
By Jan OberhauserWrite HTTP query string on image
Receives data from an incoming HTTP Request Reads file from internet Writes data on image Returns the data The URL to call will look like this: http://localhost:5678/webhook-test/webhook/test?name=Jim Once called it will return an image like this:
By Jan OberhauserTransfer data from Postgres to Excel
Read data from Postgres Converting it to XLS Save it to disk
By Jan OberhauserWebhook returning XML
Receives data from an incoming HTTP Request (set up to use respond to webhook node) Create dummy data Convert JSON to XML which gets returned Respond to Webhook which returns the data and the content type of the data
By Jan OberhauserSync data between multiple Google Spreadsheets
Triggers workflow all two minutes Reads data from a Google Spreadsheet (in example Sheet Data columns A to G) Write the data unchanged in two different Spreadsheets with same Sheet name and columns, expressions are optional)
By Jan OberhauserSend selected GitHub events to Slack
Gets triggered by GitHub once a user stars/unstars a repository Checks if star got added or removed and forwards data depending on that Sends notification to Slack
By Jan OberhauserSend Typeform results to Google Sheet, Slack and email
Trigger on new Typeform form submission Write data to Google Sheet Check severity of problem If very severe post message to Slack 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 Typeform Typeform formular with questions named exactly like the columns of the Google Sheet.
By Jan OberhauserConvert Typeform data into spreadsheet
Trigger on new Typeform form submission Get existing spreadsheet-file from NextCloud Read data from file into flow Append a new row to flow-data Convert flow-data to a spreadsheet-file 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.
By Jan OberhauserTransform XML data and upload to Dropbox
Download XML data Convert it to JSON Change title in data Convert back to XML Upload file to Dropbox
By Jan OberhauserHandle errors from a different workflow
When set as "Error Workflow" on other workflow which does fail will it send an Email with information about which workflow did fail and what went wrong.
By Jan Oberhauser