Automate Your Business with AI

Slack AI agents customized for your needs

Slack integrations and API templates

AI Query Generator Slack Bot for BigQuery

This app allows users to interact with a Slack bot, ask a question about the data in a table or request the table schema, and then uses the latest ChatGPT to generate a query that is executed on BigQuery to return the results. The app includes a retry mechanism for query generation in case of an error (up to two retries) and provides the LLM with the table info to generate more accurate queries. The table schema is only printed if it is successfully retrieved. All errors from retries are now passed to the LLM. The generated query is printed before the results, and the results are displayed in a pretty table format. The bot uses the Slack API to send and receive messages and parses the user's message to determine the action to take. The bot always responds in a thread to the original message.

149

Watch The Demo

Create Slack Channel using API

An app for Slack integration allowing the creation of public channels using the Slack API. This webhook app requires 'SLACK_BOT_TOKEN' to authenticate with slack api. It also requires channels:manage scope enabled to create channels. Further enchancements to prompts may allow the app to add the user to the channel.

124

JIRA JQL Generator Slack Bot

This app, named "Slack Mention Jira Query Generator", is designed to assist you in generating Jira Query Language (JQL) queries directly from Slack. When you mention the app in a Slack message, it will generate a JQL based on your message and ask if you want to run the query. If you agree, it will execute the query on Jira and return the results in the same Slack thread. The app is designed to handle multiple users at the same time and ensures that the correct JQL is associated with the user who requested it. It also formats the JQL results to share the links of the issues instead of the actual issue object, making it easier for you to navigate to the issues directly from Slack. To use this app, you will need to provide the following environment variables: - SLACK_BOT_TOKEN: You can get this by creating a new app in your Slack workspace, adding the bot scope, and installing the app in the workspace. - SLACK_APP_TOKEN: This can be generated by enabling Socket Mode for the app in the Slack API settings and generating an App-Level token. - JIRA_API_TOKEN and JIRA_EMAIL: These can be generated from your Jira account settings. - JIRA_SERVER_URL: This is the URL of your Jira server.

121

Watch The Demo

Weekly Jira Issue Count to Slack

This app fetches Jira issues that had status change in the last week, calculates the count of issues in different issue types, further breaks down each issue type by issue status, prepares a summary for it in form of a table using tabulate, posts the summary in a Slack channel, and schedules the app to run every time the server is started and then every week afterwards. The app requires the following environment variables to be set: - `JIRA_SERVER`: The URL of your Jira server. - `JIRA_USERNAME`: Your Jira username. - `JIRA_API_TOKEN`: Your Jira API token. - `JIRA_PROJECT_NAME`: The name of your Jira project. - `SLACK_TOKEN`: Your Slack token. - `CHANNEL_ID`: The ID of the Slack channel where the summary will be posted.

103

Watch The Demo

Slack Thread Summarizer App

This app listens for mentions in a Slack thread, excluding messages sent by bots and messages where the bot is mentioned. It then summarizes the thread using an LLM, providing a concise summary of 3 to 5 sentences. The summary is sent back to the same thread where the bot was mentioned. The app also improves the prompt given to the LLM, ensuring that the response consists of key takeaways in bullet points, is concise, and avoids repetition. It also handles errors when the app is mentioned directly without any thread.

Jira Weekly Done Issues to Slack

This app provides a summary of completed Jira tasks posted to a specific Slack thread every week. It uses the Jira API to download closed tickets from the current week. The query filters for tickets with the status 'Done' and last updated this week. The ticket details, including the ticket URL, are posted to Slack in a single thread. The required environment variables are JIRA_DOMAIN, JIRA_EMAIL, JIRA_API_TOKEN, SLACK_TOKEN, and SLACK_CHANNEL.

Watch The Demo

Basic Slack Bot

This is a simple starting point for a Slack bot it just responds hi to a mention.

Basic Slack Bot

A basic starting template for a Slack bot that responds with a simple "hi" to mentions.

Discord Member Engagement Bot

This bot will be designed to perform a variety of tasks on Discord, including counting metrics, tracking unique engaged members, tracking new members, and tracking members that have left. These metrics will also be sent as messages to a Slack channel every 7 days in the form of a data frame table converted to text. To make it work, it requires the following environment variables: DISCORD_TOKEN (your Discord bot token), SLACK_API_TOKEN (your Slack API token), and SLACK_CHANNEL (the ID of the Slack channel where the bot will send messages).

Slack integrations and API

Lazy AI’s Slack integration templates offer a range of automated solutions that significantly streamline workflows by leveraging the full potential of Slack’s API. From automating BigQuery queries to summarizing Jira issues, creating channels, and sending reports, these templates simplify the most time-consuming aspects of communication and project management. With the flexibility to integrate custom workflows and automate repetitive tasks, Lazy AI empowers teams to enhance their productivity and efficiency within the Slack ecosystem.

Generating BigQuery Queries Using Slack API

The Slack API enables seamless interaction between users and BigQuery. Lazy AI uses the chat.postMessage method to automate data requests from Slack to BigQuery. Users can input commands through Slack’s interface to generate and run SQL queries, which are processed and returned in real-time. This allows teams to access critical data reports without leaving Slack. The conversational interface, powered by Slack API's interactive elements, makes querying data simple, empowering teams to quickly gain insights and make decisions based on data.

Creating Slack Channels via the Slack API

Automating the creation of Slack channels is made possible by the conversations.create method in the Slack API. Lazy AI integrates this functionality to streamline the creation of new project or task-specific channels. For instance, when a project is initiated in a tool like Jira, Lazy AI triggers Slack to automatically generate a corresponding channel, invite relevant members using conversations.invite, and set up communication spaces efficiently. This removes the administrative burden, ensures that communication channels are created instantly, and organizes teams around specific tasks or projects without manual intervention.

Automating Slack Messages with the Slack API

Lazy AI utilizes the Slack API’s chat.postMessage method to automate messaging within Slack. This template allows teams to automate routine communication, such as sending reminders, task notifications, or progress updates. By using triggers and scheduled actions through Slack API, important information can be communicated automatically. For instance, teams can set up daily standups or notify members of task completions without manual input. With support for advanced message formatting, including attachments, blocks, and buttons, Lazy AI enables teams to send rich, interactive messages, enhancing the communication process.

Reporting and Notifications Using Slack API

The Slack API’s chat.postMessage and chat.update methods are central to automating reporting and notifications. Lazy AI templates make it easy to generate and distribute project reports, task updates, or performance metrics directly within Slack. Users can schedule notifications or set them to trigger when specific actions occur, such as task completions or important project milestones. These automated reports keep everyone in the loop and reduce the need for manual check-ins, ensuring that important information is delivered to the right people at the right time, fostering better collaboration and decision-making.

Custom Workflows with Slack API

Slack’s API is highly flexible, allowing the creation of custom workflows that fit unique organizational needs. Lazy AI leverages this flexibility by utilizing various Slack API methods like chat.postMessage, conversations.create, and users.lookupByEmail to automate more complex workflows. These workflows can integrate with other tools, such as Trello, Asana, or Google Drive, enabling Slack to act as the central hub for multiple applications. Teams can customize these workflows to meet their specific needs, whether it's automating task assignments, generating reports, or setting up automated reminders, all driven by Slack’s powerful API capabilities.