Slack - Lazy AI

Slack 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.

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.

Send & Post Message to Slack using API

A Rest API that sends personal messages to Slack, supporting both direct private messages to user and posting messages in threads.

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.

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.

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.

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.

Send a daily report of some metrics from BigQuery to Slack

This app fetches data from BigQuery using a provided SQL query, formats the data into a table, and posts the table to a specified Slack channel. The data posting is scheduled to happen every day at 10 am UK time.

Basic Slack Bot

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

Slack

Slack is a cloud-based collaboration platform that allows teams to communicate and work together more efficiently. It was launched in 2013 and has gained popularity among businesses of all sizes.

Slack provides a centralized hub for team communication, replacing the need for email threads and scattered messaging apps. It offers various features to facilitate collaboration, such as channels, direct messaging, file sharing, and integrations with other tools.

Channels in Slack are dedicated spaces for specific topics or projects, where team members can have discussions, share files, and collaborate in real-time. Direct messaging allows for one-on-one or small group conversations, making it easy to have private discussions or quick exchanges.

One of the key advantages of Slack is its ability to integrate with other tools and services commonly used in the workplace. This allows teams to bring all their important information and notifications into one place, reducing the need to switch between different apps and platforms.

Slack also offers a range of additional features, including voice and video calls, screen sharing, and the ability to search and archive conversations. It is available on various platforms, including desktop, web, and mobile devices, making it accessible to users wherever they are.

Overall, Slack aims to improve team communication, collaboration, and productivity by providing a centralized and organized platform for work-related discussions and tasks.