Database
Xenibase
Start workflows when rows change in a Xenibase (formerly PGDock) project (Taskiem creates and removes the webhook itself); read, insert, upsert, update and delete a table's rows and call its functions through the project's data API.
Connecting it
One click: sign in to Xenibase and allow Taskiem. There is nothing to copy.
What your workflows can do
- Call a database function
- Check the connection
- Delete rows
- Get a row by its key
- Insert rows
- Query rows
- Read rows (data API)
- Update rows
- Upsert rows
Ready-made
Workflows that use Xenibase
Record your bank's email alerts in a table
When your bank emails you an alert, keep it in a data table and tell you on WhatsApp.
Put people who opted in on a Brevo list
When a customer in your customers table agrees to marketing, add them to your Brevo newsletter list, once.
Mark Brevo unsubscribes in your table
When someone unsubscribes from your Brevo emails, their address bounces or they mark one as spam, update their row and stop marketing to them.
Welcome new customers from your customers table
When a customer is added to your customers table, text them a welcome message, with no spreadsheet.
Put people who opted in on a Mailchimp audience
When a customer in your customers table agrees to marketing, add them to your Mailchimp audience, once.
Mark Mailchimp unsubscribes in your table
When someone unsubscribes from your Mailchimp audience or their address is cleaned, update their row and stop marketing to them.
Mark bounced Resend emails in your table
When an email sent through Resend bounces or is marked as spam, note it on the customer's row and stop marketing to them.
WhatsApp message when a row is added in Xenibase
When a new row is added to a table in your Xenibase database (an order, a booking, a sign-up), send the phone number in it your approved WhatsApp template.
Bring in past OPay terminal payments
Ask OPay for a terminal's successful payments between two days (up to a week) and add them to the POS sales table.
Every night, check OPay for terminal payments the notifications missed
Late every night, ask OPay for each terminal's successful payments of the day and add any that are not in the POS sales table yet.
Record every OPay payment in the POS sales table
Every payment on your OPay business account, your POS terminals included, kept in your POS sales table with the fee and what was settled.
Record every Moniepoint POS sale in a table
Every time one of your Moniepoint terminals takes a payment, keep it in a data table: terminal, amount, kind, whether it was approved.
End-of-day POS cash-up
Check a terminal's day against the sales book: enter what the book says and hear the difference, with a record kept.
Evening POS summary to the owner
Every evening, add up today's Moniepoint POS sales from the POS sales table, per terminal, and tell the owner.
Evening OPay settlement check
Every evening, add up what OPay took today, the fees and what was settled to you, and tell the owner with the account balance.
Record each Payrolla payroll in tables
When Payrolla finishes paying a payroll, add it and each person's payment to tables your accountant can read.
Run payroll from any payments account
On payday, check your staff list and balance, get the payroll approved, pay everyone once through whichever payments account you connected, and keep a record.
Leave requests from your staff, approved and answered on their phone
Staff ask for leave with a form; a manager approves; they hear the answer on WhatsApp, Telegram or by text.
Pay a list of people after approval
Pay everyone on a list (suppliers, refunds, prizes, commissions) once, after one approval, from whichever payments account you connected, and keep a record.
Collect a payment with a link
Make a payment link for an order, send it to the customer, remind them once, and record the order as paid when the money arrives.
Give each customer their own account number
Open a bank account number for a customer to pay into, record it, and send it to them, so every transfer is known to be theirs.