We Use Cookies

We use cookies to ensure that we give you the best experience on our website. If you continue to use this site we will assume that you are happy with this.

See our cookie policy.

Automate database monitoring

Trigger workflows on database changes

Use ThinkAutomation to create custom database queries and lookups as part of your workflows. Our software bots can pull data from your databases and run the required follow-up tasks automatically.

ThinkAutomation can monitor your local (on-premises) or cloud databases for new or updated records. When a new or updated record is found, the content of the record will be passed to your Automation for processing. Within your Automation you can access individual column values. For example: You could monitor a 'customer' table for new customers. When a new customer is found, use the 'Name' and 'Email' columns to send the customer a welcome email. Your Automation can also use the data to update another database.

ThinkAutomation supports: Microsoft SQL Server, MySQL, MariaDB, PostgreSQL, Oracle, DB3, Firebird, SQLite, MS Access PLUS any ODBC or OLE/DB database.

parse

1. Perform parameterised queries

ThinkAutomation reads records from a database at scheduled intervals

retrieve results

2. Retrieve results

Query results are checked against your pre-defined rules and conditions

execute triggers

3. Execute automations

Triggered actions will then be performed against each record returned

email new customers added to the database
Email new customers added to the database
send loyalty offer to customers after x years
Send loyalty offer to customers after X years
send loyalty offer to customers after x years
Send loyalty offer to customers after X years
translate irregular records into a language of choice
Translate irregular records into a language of choice
extract customers who have given marketing consent
Extract customers who have given marketing consent
delete records after x years of inactivity
Delete records after X years of inactivity
delete records after x years of inactivity
Delete records after X years of inactivity
run a report on product purchases
Run a report on product purchases
send marketing sms to entries with a mobile number
Send marketing SMS to entries with a mobile number
back up new records after x time
Back-up new records after X time
drip emails based on customer time zone
Drip emails based on customer time zone
excel
Create a spreadsheet on customers within a location
send a welcome tweet to new customers
Send a welcome tweet to new customers
pull data of customers in x sector
Pull data of customers in X sector
extract a list of unconverted prospects
Extract a list of unconverted prospects
send email to customers of a specific product
Send an email to customers of a specific product
create spreadsheet of customers due for renewal
Create spreadsheet of customers due for renewal
delete records with invalid formatting
Delete records with invalid formatting
pull data of customers in x sector
Pull data of customers in X sector
create a call list of customers with x account manager
Create a call list of customers with X account manager
email customers with high sentiment scores
Email customers with high sentiment scores
pull a list of previous customers graphic
Pull a list of previous customers
lookup contacts with a specific job title
Lookup contacts with a specific job title
parse negative feedback into a custom folder
Parse negative feedback into a custom folder
send emails to customers based on milestones
Send emails to customers based on milestones
re-format phone numbers based on company country code
Re-format phone numbers based on company country code
run custom greater than queries
Run custom greater than queries
extract a list of high value customers
Extract a list of high-value customers
send re engagement email after x weeks of inactivity
Send re-engagement email after X weeks of inactivity
lookup messages containing keywords
Lookup messages containing keywords
and-countless-more
And countless more

Hundreds of combinations

Database pulls can incorporate as many lookups and actions as you can conceive. It might be simple, scheduled record cleansing, periodic extractions, or timed and tiered communication workflows.

You build your database pull rules using logical select statements and conditional processing. (Straightforward ‘if’, ‘then’, and ‘else’ type rules.) For example:

Select If Then
Select all new accounts created in the last 24 hours The customer has given contact consent Send them a welcome email
Select all records created over X years ago The account is still active Send the customer a loyalty offer
Select all customers located within the UK The contact number does not begin with +44 Change the number to the correct format

Ready to automate your database monitoring?

Ease your email admin with a free trial of ThinkAutomation

Download Free Trial

thinkautomation interface screenshot