Landbot and Postgres integration
How to connect Landbot and Postgres
Create a new workflow and add the first step
In n8n, click the "Add workflow" button in the Workflows tab to create a new workflow. Add the starting point – a trigger on when your workflow should run: an app event, a schedule, a webhook call, another workflow, an AI chat, or a manual trigger. Sometimes, the HTTP Request node might already serve as your starting point.
Build your own Landbot and Postgres integration
Create custom Landbot and Postgres workflows by choosing triggers and actions. Nodes come with global operations and settings, as well as app-specific parameters that can be configured. You can also use the HTTP Request node to query data from any app or service with a REST API.
Supported API Endpoints for Landbot
Get channel data
Returns channel data of a specified channel ID.
List channels
Returns your channels data.
Create hook
Creates a message hook for the specified channel
Delete hook
Deletes a specific message hook from a channel
List WhatsApp templates
Returns your WhatsApp templates data.
List whatsapp templates
Returns whatsapp templates to send with more than one channel.
Opt out customer
Delete opt-ins of a specific customer.
Send template
Sends template message to a specific customer.
Delete customer
Deletes a specified customer by ID.
Get customer data
Returns data of a specified customer ID.
List customers
Returns a list of all customers.
Send WhatsApp template
Sends a WhatsApp template to a specified customer.
Send image
Sends an image to a specified customer.
Send location
Sends a location to a specified customer.
Send text
Sends a text message to a specified customer.
Archive customer
Archives a specified customer by ID.
Unarchive customer
Unarchives a specified customer by ID.
Archive customer
Archives a specific customer.
Assign bot to customer
Assigns a specific customer to a specific bot.
Assign customer to agent
Assigns :customer_id to :agent_id
Assign customer to self
Assigns :customer_id to you
Block customer
Blocks :customer_id
Delete customer
Delete customer :customer_id
Send image
Sends an image message to a specific customer by customer_id.
Send location
Sends a location message to a specific customer by customer_id.
Send text message
Sends a text message to a specified customer.
Unarchive customer
Unarchives a specified customer.
Unassign customer
Unassigns a specified customer.
Unblock customer
Unblocks a specified customer.
Delete field
Deletes field :field_name from customer with id :customer_id
Create customer
Create a new customer entry.
Read customer
Read specific customer details by token.
Update customer
Update details for an existing customer by token.
Read customer
Read customer information based on customer token.
Update customer
Update customer details based on customer token.
Create customer field
Creates a new customer field.
Delete customer field
Deletes a specified customer field.
Create message hook
Creates a new message hook for a specific channel.
Change field value
Changes the value of a specified field for a customer.
Get data
Get data of a specific agent by ID.
Send message
Send a message to a customer with a given token.
Send messages
Send messages to the specified webhook URL.
To set up Landbot integration, add the HTTP Request node to your workflow canvas and authenticate it using a generic authentication method. The HTTP Request node makes custom API calls to Landbot to query the data you need using the API endpoint URLs you provide.
See the example hereThese API endpoints were generated using n8n
n8n AI workflow transforms web scraping into an intelligent, AI-powered knowledge extraction system that uses vector embeddings to semantically analyze, chunk, store, and retrieve the most relevant API documentation from web pages. Remember to check the Landbot official documentation to get a full list of all API endpoints and verify the scraped ones!
Postgres supported actions
Delete
Delete an entire table or rows in a table
Execute Query
Execute an SQL query
Insert
Insert rows in a table
Insert or Update
Insert or update rows in a table
Select
Select rows from a table
Update
Update rows in a table
Landbot and Postgres integration details
Other integrations with Postgres
Landbot and Postgres integration tutorials
How to export data from PostgreSQL to CSV
CSV is a universally accepted and easy-to-read format to interpret data, and PostgreSQL is one of the most popular relational databases. Read on to learn how to export PostgreSQL as a CSV file using the COPY command, \copy command, and n8n.
How to import CSV into PostgreSQL
PostgreSQL remains one of the most popular relational database options among data enthusiasts. Read on to learn how to import a CSV file into PostgreSQL using pgAdmin, SQL statements, and n8n.
Database activity monitoring: How to automatically monitor and set alerts for a database
Learn what database activity monitoring is, why it's important, and how to automatically monitor a Postgres database containing IoT data with n8n workflows.
Automate your data processing pipeline in 9 steps
Learn how to build an n8n workflow that processes text, stores data in two databases, and sends messages to Slack.
FAQ
Can Landbot connect with Postgres?
Can I use Landbot’s API with n8n?
Can I use Postgres’s API with n8n?
Is n8n secure for integrating Landbot and Postgres?
How to get started with Landbot and Postgres integration in n8n.io?
Need help setting up your Landbot and Postgres integration?
Discover our latest community's recommendations and join the discussions about Landbot and Postgres integration.
Postgres node IN operator with parameters
Mikhail Savenkov
Describe the problem/error/question Postgres node is not working with IN Operator when the parameters is an Array. I suppose that’s because of the sanity checks. E.g. I have a list of some workflows that I’m returning v…
Open topic
Passing an array as query parameter in Postgresql
Honza Pav
Hello, I have a follow-up question related to a topic that has been discussed but is closed: Postgres use array as a query parameters I want to pass an array into a Postgresql query as a query parameter. Ideally, I woul…
Open topic
Self-Hosted n8n 1.59.3 does not have Postgres PGVector Store and Postgres Chat Memory nodes
Vyacheslav Karbovnichy
Describe the problem/error/question I have set up local n8n (latest stable v1.59.3) and wanted to try the solution from here https://www.youtube.com/watch?v=PEI_ePNNfJQ but when importing that workflow locally I have so…
Open topic
Node does not return "enough items"
Dennis
Hey everyone, I have the following problem & one question. Problem I have an HTTP request and a split. The split node correctly splits the HTTP into 10 items. But the Postgres only returns 1 item. No matter what, which…
Open topic
Sudden Spike in Database Request
Dennis
Hey everyone, I love N8N so far; as a newbie when it comes to databases and development, I am happy for this awesome solution. Situation I am, at best, an intermediate coder. Right now we are building an MVP, before h…
Open topic
Looking to integrate Landbot and Postgres in your company?
The world's most popular workflow automation platform for technical teams including
Why use n8n to integrate Landbot with Postgres
Build complex workflows, really fast
