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
  • Can I write rules that combine data from different sources?
  • Can LogicLoop deduplicate data so that I don't take the same action twice on the same entity?
  • Can LogicLoop send customizable Slack notifications?
  • How can I configure LogicLoop to safety run on my database?
  • How do I send an email notification to each of my customers?
  • Can LogicLoop send from my own domain instead of hi@getlogicloop.com?
  • Can I get alerted when a LogicLoop action fails?
  • Can I trigger a LogicLoop rule live via API call?
  • Can I retry failed actions?
  • Can I inject a list from another query or GSheets into my rule?
  • The API I want to query returns complex, nested JSON responses. How can I extract the specific fields I need?
  • Can I transform my data before the action trigger?
  • Can I chain LogicLoop actions together?
  • Can you share some common analytics templates?
  • Do you support integrating with...
  • Can I login via Google/SSO/SAML?
  • How do I set a custom schedule interval?
  • Can I trigger an action on a data change?
  • Is my Google Sheets data compliant with Google's Limited Use Policy?

Was this helpful?

FAQs

PreviousChangelogNextTroubleshooting

Last updated 1 year ago

Was this helpful?

Can I write rules that combine data from different sources?

Yes! One of the advantages of LogicLoop is that you can combine data from various sources such as data warehouses, databases, and APIs. In order to do so, first create a separate LogicLoop rule grabbing the data you need from each separate data source. The data generated from those rule runs will be stored as JSON under LogicLoop's data source. Next, you can that joins data from two separate rules using SQLite syntax. .

Can LogicLoop deduplicate data so that I don't take the same action twice on the same entity?

Yes, when you configure your LogicLoop action, you can turn on deduplication to ensure that the action won't run twice on the same data. LogicLoop will deduplicate the data points based on an id field returned.

You can be very creative with what field you actually want to deduplicate on in your SQL query. For example, you may write select user_id as id from users if you want to deduplicate on a field called user_id. You may write select created_at as id from users if you want to deduplicate based on time stamp. You may even write select (user_id || current_date) as id from users if you don't want to alert on the same user twice in the same day, but you want to alert on them again the next day.

Can LogicLoop send customizable Slack notifications?

How can I configure LogicLoop to safety run on my database?

Many of our customers are able to run smoothy with LogicLoop connected to their production databases, but if you're worried about queries hitting your prod database directly, we recommend configuring LogicLoop to connect to either a secondary replica or a read-only user that has limited permissions. You may also choose to connect LogicLoop to your data warehouse instead.

The number one thing you should do is practice good SQL hygiene and write efficient queries that fetch only what you need from your database. We recommend adding a LIMIT 1000 to your queries to limit the rows returned from your data. LogicLoop automatically cuts off queries that run for longer than 15 minutes in order to protect both your database and ours from being overloaded. We also recommend running your queries only as frequently as your need e.g. every day instead of every minute.

How do I send an email notification to each of my customers?

Can LogicLoop send from my own domain instead of hi@getlogicloop.com?

Yes, for advanced users, we can configure your account to send out emails from support@yourdomain.com instead of hi@getlogicloop.com. Please email us at hi@getlogicloop.com if you wish to enable this on your account.

Can I get alerted when a LogicLoop action fails?

Can I trigger a LogicLoop rule live via API call?

Yes, you can trigger a LogicLoop rule to run immediately by calling that rule's API endpoint. Contact support@logicloop.com for API access.

Can I retry failed actions?

We currently do not support retrying individual failed actions but you can simply re-run your rule again.

Can I inject a list from another query or GSheets into my rule?

The API I want to query returns complex, nested JSON responses. How can I extract the specific fields I need?

Can I transform my data before the action trigger?

Can I chain LogicLoop actions together?

Can you share some common analytics templates?

Do you support integrating with...

Can I login via Google/SSO/SAML?

We offer login via Google as well as SAML (Okta, Auth0, etc). Please support@logicloop.com if you wish to enable this on your account.

How do I set a custom schedule interval?

Can I trigger an action on a data change?

LogicLoop typically works by triggering an action if there is data returned from your SQL query. If on the other hand, you wish to trigger an action only when the data returned from your SQL query changes, you can create your own advanced LogicLoop rule. First, create a rule that fetches the data you are evaluating. Next, create a meta-rule that queries the results of your first rule and compares it to the cached results of that same rule. For example, your meta-rule could look something like this: select * from query_12 joins cached_query_12 where query_12.status != cached_query_12.status where query_12 is the first rule that you wrote with the original data.

The built in LogicLoop supports sending custom Slack notifications to a Slack channel of your choice. In the Slack notification template, can do things like and tag a specific user to be pinged by inserting their <@MEMBERID> or <@username> (with the < > brackets) into the template.

You can also integrate with the Slack API directly using our to unlock an even . For example, you can:

(including Slack Connect channels that are shared with external customers) for each row returned from your data.

Include an with your Slack message.

Make your LogicLoop Slack alert a .

First, write a LogicLoop that returns the set of customers you wish to notify. Next, create an whose trigger setting is set to for each row returned. That way, when your rule runs, it will send a separate email for each customer returned. You can customize the messages sent to each customer using our .

Yes, LogicLoop itself exposes and API of all the events in our system including action logs and rule runs. You can then use the data source to query the LogicLoop API and retrieve all failed action logs. Then you can create an that will send you a Slack or email alert on failed action logs. Please contact support@logicloop.com if you wish to gain access to this Beta API.

Yes, you can inject a list intro your SQL query by the value of that list into your query e.g. select * from users where category in ({{ categories }}). In your parameter's configuration, you can select it to automatically populate with values from another query.

You can use function to extract individual data points from nested lists and dictionaries returned from your complex APIs.

Yes, we recommend taking advantage of the power of SQL to transfer your data into the shape you want before the action gets triggered. SQL has many advanced functions like that can help you transform data into the format you need.

Yes, you can have the action of one LogicLoop rule trigger another LogicLoop to be run. You can also pass through data from the first rule as parameters into the second rule. In order to enable this, email support@logicloop.com to get access to our Beta API. You will need the API in order to have your first rule trigger another rule by setting up a that calls the LogicLoop API endpoint that will trigger your second rule.

Yes! .

In addition to our and we can integrate with any service that exposes an API. That means we can integrate with services like Gmail, Google Calendar, Google Drive, Zapier, Twilio, WhatsApp, Stripe, Sendgrid, Mailchimp, Dropbox, Trello, JIRA, Notion, Airtable, Salesforce, Close, Twitter, Hubspot, Discord, Facebook, Typeform, Asana, Webflow, Shopify, Zendesk, Intercom, ClickSend, Freshworks and more.

If you do not see the schedule interval you would like to use (e.g. "Every 3 weeks"), please send an email to with a link to your rule and the interval that you want set.

Is my Google Sheets data compliant with Google's ?

Yes, LogicLoop's use and transfer to any other app of information received from Google Sheets APIs will adhere to the , including the Limited Use requirements.

Slack integration
embed data
Have your LogicLoop rule ping a different Slack channel
image attachment
reply to another thread
rule
action
templating language
JSON API
action
parameterizing
SQL's JSON_EXTRACT
FORMAT()
Check out our template library here
pre-built data sources
pre-built action destinations
support@logicloop.com
Limited Use Policy
Google API Services User Data Policy
Query Results
write a meta-query
View a demo here
wider array of features the Slack API can support
webhooks action
webhook action