Docs
  • LogicLoop Documentation
  • LogicLoop Quickstart
  • Data Sources
    • Connect your data source
      • Deployment options
    • Supported data sources
      • API data (JSON)
      • AWS CloudWatch
      • BigQuery
      • Databricks
      • Google Analytics
      • Google Sheets
      • MongoDB
      • Microsoft SQL Server
      • MySQL
      • Oracle
      • PostgreSQL
      • Snowflake
      • Combine Results
      • LogicLoop Data Source
  • Queries
    • Write a rule
      • More rule options
      • A/B testing rules
      • Version history
      • Query Snippets
    • Visualizations & dashboards
      • Visualizations
      • Dashboards
  • Actions
    • Set up an action
    • Action destinations
      • Email
      • Slack
      • Webhooks & APIs
      • Microsoft Teams
      • Salesforce
      • Zapier
      • PagerDuty
      • Write to Database
      • Chain Rules
      • Google Sheets
      • Bento
    • Templating
  • Case Management
    • Case Management
      • Ticket Generation
      • Case Triage
      • Custom Fields and Attachments
  • AI
    • AI Query Helper
    • Ask AI
  • Teams & Settings
    • Integrations
      • Slack
      • Google Sheets
    • Invite your teammate
    • Groups & Permissions
  • Changelog
  • FAQs
  • Troubleshooting
  • Templates
    • Templates Home
    • Risk & Fraud Rules
    • AML Transaction Monitoring Rules
    • Logistics & Marketplace Ops
    • Customer Success & Growth
    • Systems Observability
    • Data Quality Monitoring
    • Healthcare
    • HTML Email Templates
      • Annual Review
      • Weekly Performance Table
      • Invoice Recap
  • BETA
    • AI SQL API
    • Approving rules
    • Render Data as JSON
    • Case Analytics
    • Python
  • Security & Legal
    • Security
    • AI Security
    • Terms of use
    • Privacy policy
    • Services description
Powered by GitBook
On this page
  • 1. Connect your data source
  • 2. Write or use AI to generate your first rule
  • 3. Run it on a schedule and Trigger actions

Was this helpful?

LogicLoop Quickstart

Learn how to set up your first LogicLoop rule in minutes.

PreviousLogicLoop DocumentationNextConnect your data source

Last updated 7 months ago

Was this helpful?

LogicLoop lets you set up alerts and automations on your data, without writing code. This quickstart guide will show you how you can set up a Slack alert when a business threshold is exceeded.

1. Connect your data source

Log in to LogicLoop, and hi if you need a setup link.

LogicLoop can read and combine data from databases, Google Sheets and API-based SaaS apps.

To add a new data source, you must be an admin user. Go to the Settings > Data Sources tab. Click + New Data Source to open the Create a New Data Source wizard. Select the type of your data source, and enter the necessary user credentials to configure it. Then click Test Connection to verify the setup.

2. Write or use AI to generate your first rule

LogicLoop lets you write SQL-based rules as queries on your data to manage your business processes. First, navigate to the Rules tab on the left sidebar. Here you'll see a listing of all existing Rules with useful metadata about the status of their last runs. Click + New Rule on the top right corner to start a new query, and enter your SQL.

Our AI Query Generator lets you convert plain English text to a SQL query, so you can write rules even without any technical knowledge. To use Query Generator, open a new rule. In the top right, select AI Query Helper -> Query Generator. For example, you can say "Show all merchants and amounts with a large transaction over $10000" You can also choose which tables to run the query on.

Important: Remember to hit Publish on the top right for your query before moving to the next step.

This feature is powered by OpenAI. If you use this feature, only the text of your SQL query or your data schema format will be sent to OpenAI. None of your actual data will be sent.

3. Run it on a schedule and Trigger actions

Once you have a query, you can run it on a schedule, every 1 minute to every month, from the bottom left tab Schedule and Action > Run Schedule

Now, click + Add Action, and select Trigger Action > For each row returned and click Create Action. Go the Destinations tab on the left, click + Action Destination on the top right, and follow the steps to create a Slack integration and then create a Slack Action Destination.

Then come back to your rule, click View Action on the bottom left and click + Add to connect this new Slack Action Destination. Select the channel you want to post alerts to from your list, and use our templating syntax to customize your alert, like the example below.

Now click Run Rule Now, and you should see your Slack alert show up like this:

That's it! You'll also see a complete history of all Action Logs in your rule run, so you can keep track of what ran.

For a deeper dive into connecting datasources, refer to the in the docs.

For a deeper dive, read the section of our docs.

For more details, refer to the section of the docs.

Connect your datasource section
Write a rule
Set up an action
LogicLoop can help connect your business data to actions
Step 1: Connecting to a data source
Using AI Generator to write SQL queries from natural language text
Running your rule on a schedule
Configuring your Slack alert with custom fields