Giter Club home page Giter Club logo

crewai-xls's Introduction

CrewAI excel xls template runner

Intro

This repository contains code to load crewAI configuration usin gq Grqdio UI from excel xls and generate the python code for a crew-job combination. A job is a sequence of tasks. The source of the crews is defined in the xls. It allows for quick prototyping and iterations without having to edit code, There is a set of basic agents which have tools defined. This is only a subset of what currently is available through crewai tools.

Prerequisites

CrewAI

A new clean requirements.txt is generated; command is in .sh file

CrewAI package

Default pip install of the package

Tools

Default install of the crewai tools

Langchain

Other langchain packages that are used are listed in requirements.txt

XLS

Excel format is xlsx, list of sheets are read and loaded. The actual preparation of the crews is done beforehand as the crew details do not change much once developed.

API Keys

API keys need to be provided as part of the environment, both running straight from source and when using docker container eg when hosting on render.com

Run locally

First get the project dependencies installed

pip install -r requirements.txt

just run locally as python3 main.py

and follow the gradio instructions on screen to open your browser and use the UI.

Run in Docker container

To allow easy deployment a docker image is provided;

Building and running your application

When you're ready, start your application by running: docker compose up --build.

Your application will be available at http://localhost:8000.

Deploying your application to the cloud

First, build your image, e.g.: docker build -t myapp .. If your cloud uses a different CPU architecture than your development machine (e.g., you are on a Mac M1 and your cloud provider is amd64), you'll want to build the image for that platform, e.g.: docker build --platform=linux/amd64 -t myapp ..

Then, push it to your registry, e.g. docker push myregistry.com/myapp.

Consult Docker's getting started docs for more detail on building and pushing.

References

Screenshots

Browser GradioUI

Optional Step 1 Downloading and uploading xls template files

ui step 1 xls

Optional Step 2

Select xls configuration

ui step 2A select xls

Select a crew and job combination to generate crew for

ui step 2B select combi

Straight to Step 3 if nothing changed in xls

Select job to run from generated crews

ui step 3A Run Job

Job is selected and default prompt is provided

ui step 3B Select Job

Provide specific additional inputs

ui step 3C provide input

Wait for final results and see detailed logging

ui step 3D logging downloads

Excel xls

The excel file contains the complete setup to run a crew. Please note , not all parameters are implemented yet, but most are and up-to-date with version 0.41 from crewAI.

Supporting additonal parameters entails adding the column, matching the name to the template {variable} taking care of quoteds strings when needed. If something more fancy is needed, you have to either add to the generate_crew code, or within the class constructor.

LLM providers and models

Defining the providers and available models. The templates/llm_class_template.py has the import statement for the provider. To support additional providers, you need to add these to the class template, additional models for already configured providders, you only need to add a row in the xls sheet with the details.

LLM providers and models

Jobs to be done and task definitions

To stick to crewAI terminology, a job is a collection of tasks

Jobs to be done

Jobs consisting of multiple tasks

The xls contains the trip planner example, other jobs and tasks are development test cases, not necessarily working well.

Crews and crewmembers

Crews are defined to tackle specific jobs. Agens have the tools and are assebled into crews.

Crews are defined to tackle specific jobs

Agents have the tools and can be specified at the task level

For a specifc job a crewmembers are assembled from the available agents.

crewai-xls's People

Contributors

cbruyndoncx avatar

Stargazers

 avatar  avatar Rip&Tear avatar

Watchers

 avatar

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    ๐Ÿ–– Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. ๐Ÿ“Š๐Ÿ“ˆ๐ŸŽ‰

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google โค๏ธ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.