Flash banner sign design tool jobs
I’m looking for an experienced Python developer with a solid understanding of Django and Flask, who can help me with the amalgamation of two separate Python projects. Here are some details about my requirements: - Integration Order: The order of integration isn't a matter of concern to me, so I'm comfortable with starting either way. - Data Flow: My preference is to migrate the Flask Python code into the Django application, as opposed to running the two in parallel. We won't be exchanging any data through an API. - Flask Functionality: The specific Flask feature to be integrated into the Django app is simply the API endpoints. However, the final decision on exactly which APIs will be incorporated will be made in due course, so your understanding and flexibility towa...
In need of a competent developer to create a store locator tool for my Shopify website. This locator needs to synchronise with my Google My Business locations, which currently number around 300. Main features required: 1. Filter by Distance: Users should be easily able to see the stores within their chosen distance range. 2. Direct Navigation to Store: Provide easy accessibility with a feature that directs users to chosen store locations. Currently I am using a google map built using It works correctly but you can't sync the location data so every time a store changes the hours it has to be re-generated. We need a locator that syncs the location data. Ideal candidate will have: - Experience with Google My Business API - Previous
I'm seeking a skilled programmer to convert an animated GIF into an HTML5 format for creating a triad of animated banner ads. The banners should be optimized for desktop, mobile, and tablet devices to ensure they display correctly across all platforms. The different versions of this animated banner must meet the specified dimensions: 300x600 pixels & 472x114 pixels. Both creatives should be under 100KB file size.
Hello, I have around 400 Postcodes in the UK, and out of those 300 are already done, so you need to search for the remaining postcodes on a website, I will provide you with all the details along with a video tutorial + other details I will provide through WhatsApp messaging and calls. You will know about taking screenshots, I have a free Chrome tool, and I will provide it. it's a Very Urgent Project, so if you can start work Immediately and finish within the next 24 hours, then only apply. You should know the Excel and web-based copy/paste knowledge. This is a challenging job, and who can handle the pressure, the right candidate can get regular work. Hindi-speaking people will get preference. Happy Bidding! Randhir
I'm in need of a professional with expertise in creating basic circuit boards to help with the development of a new product. We will have 15 led lights that can illuminate normally or flash. They will light in different sequences. Ie Light 1 flashes and light 5 lights. Then say light 3 illuminates and light 3 flashes etc. The idea is to have an app made to manage / send the info for the sequences, I need someone to create the circuit board with the lights so that we can connect to a mobile app. Key aspects of the project include: • The creation of a circuit board design that supports integrated circuits • The product is in its developmental stage, requiring your input and creativity Ideal skills and experiences: • Demonstrated experience in design...
I'm seeking an expert with significant experience in Fortigate firewall configurations, particularly with implementing Zero Trust Network Access (ZTNA) and integrating with Single Sign-On (SSO) solutions. Key Requirements: - Deploying ZTNA on Fortigate with specific features like network segmentation, user authentication, and secure remote access. - Integrating Azure Active Directory with the Fortigate firewall for seamless SSO functionality. - Enable user provisioning functionality in the Fortigate firewall through Azure Active Directory integration. Ideal Skills: - Proficiency in Network Security and Firewall Configurations - Experience in executing ZTNA strategies - Familiarity with Azure Active Directory and SSO implementations Your application will rank higher if yo...
I'm in need of three advanced Auslan interpreters for an upcoming project. Your skills and experience will be vital in ensuring successful communication in various settings. The project locations include: Interpreting videos for an application Strong experience with advanced Auslan interpretation is required. Your expertise in interpreting complex sign language in various professional situations will be highly regarded. In this project, you'll have to: - Provide accurate Auslan interpreting services for videos - Handle multiple interpreting tasks efficiently - Properly interpret complex or special language phrases - Ensure a high level of professionalism and confidentiality Prior experience in working in working for AUSLAN interpreting videos would be advantageous....
I'm in need of a talented graphic artist to create engaging yard sign graphics. This project requires a blend of text and images, all designed to advertising my business effectively. Yard sign design that may also be used as a truck sign Key components of this project include: - The graphics you create should integrate well with my company's brand colors. The final design must both reflect my brand and be eye-catching to attract potential customers. - Your design should be able to strike a balance between text and images; a stunning visual narrative paired with clear and compelling text that will advertise my business. - Keep in mind, the prime purpose of this design is to advertise my business, so it should be en...
I’m looking for a software engineer with strong experience in Node.js to build a plagiarism checker, designed specifically to prevent plagiarism. The tool should be able to examine Node.js language scripts to identify copied code and trace code similarity. While I haven't specified any additional features, I leave open the option for the developer to suggest and incorporate features that can improve the performance and user experience. Expertise in algo development, code metrics, good understanding of plagiarism checker algorithms such as MOSS (Measure of Software Similarity) and Dolos will be highly appreciated.
I'm looking for a professional with considerable experience in contemporary signage design. The job is to craft a compelling storefront sign with a contemporary look that can draw attention and invite people in. Key skills needed for this project are: - Eye for modern aesthetics - Provide graphics suitable for Fabrication and signage - Proficient in color theory, particularly with bright colors - Stellar graphic design skills - Proficiency in relevant design software The ideal candidate has a solid understanding of how to visually communicate a brand through a storefront sign. You should have a knack for creating compelling, contemporary designs that embody our brand well. Your past experience with similar projects will be pivotal for this job, an...
I need a proficient designer to create a flash banner to be included in my email footer. The banner should meet the following specifications: - Size: To match similar size to example video shown - Primary Action: Entice users to visit my website - Color Scheme: Minimalistic Red and black to match my company colors Ideal skills for this project would include strong experience with graphic design and flash banner creation. Knowledge of effective CTAs and a keen eye for visual details would be highly beneficial. Preference will be given to those who can demonstrate experience in creating visually appealing banners that drive traffic to websites. Please provide work samples along with your proposal. Looking forward to collaborating with you on this pr...
I'm seeking a skilled freelancer to undertake a content refresh of my website. This will involve the following: Website to do list: 1- Create new webpage “Join Our Team” . Use text and pictures x 2, provided in this folder. Make same font and style as other existing pages. Make sure it is seo friendly. Make Clickable link on main webpage banner in between “Reviews” and “contact us” 2- add new awards pictures on homepage webpage, remove old ones (three best rated, Top choice, CBRB) (make sure they look good in desktop and mobile views) 3- make phone number bigger on homepage so it is highly visible 4- make floating “call us” and “get a quote” buttons bigger 5-see if nicejob app button can stop hidding the button ...
I'm seeking a proficient developer to create a sophisticated DEX scanner and arbitrage bot. The primary functions of this tool will be to find the best price for cryptocurrencies, execute trades for profit automatically, and detect potential arbitrage opportunities. The bot should operate seamlessly on Uniswap, SushiSwap, and PancakeSwap. Specificity about the cryptocurrencies it will focus on isn't provided. Thus, it should be versatile enough to work with a broad range of them. Ideal skills and experience for this job include: - Proficiency in crypto trading algorithms. - Familiarity with DeFi platforms like Uniswap, SushiSwap, and PancakeSwap. - Ability to design a user-friendly interface. - Knowledge in dealing with arbitrage scenarios in crypto trading.
...an application that can effectively translate American Sign Language (ASL) into text. The envisaged app's primary functionality is to convert ASL gestures into readable text in real-time. It's a task that requires the successful integration of machine learning frameworks. Additional specifications: - Android compatibility is essential for this project. - The app should also provide the capability for users to save their translations. Ideal Skills and Experience: Developers interested in this project should have: - Proficiency in Android app development. - Experience in integrating machine learning models into the application. - Sound knowledge of API frameworks is preferred. - Prior experience in developing language translation or sign language apps would be a...
I'm looking for an experienced Android app developer to create an application that interprets sign language into text or speech. This app will provide real-time translation and is primarily designed to assist persons with speech/hearing impairments. Key Features: - Real-time sign language translation integrated into an easy-to-use interface Ideal Candidate: - Experience in developing Android applications - Familiarity with real-time video processing and interpretation would be advantageous - Knowledge in accessibility design, with experience in solutions catering to persons with speech and hearing impairments is highly desirable. This application is expected to help bridge the communication gap for its users so a combination of technical proficiency and so...
I'm seeking a professional videographer for a charity event, the 'World's Greatest Shave' created and ran by Just Cuts Coomera. This event is scheduled for Saturday 6ht April at Westfield Coomera from 11am - 2pm. The main focus of your lens would be to capture footage for our Instagram Reels channel. Key Moments to Capture: - Participa...the event. Length of Footage: - The final Instagram Reel video should be no longer than 60 seconds, particularly crafted for vertical orientation on Instagram. For this role, experience in event videography and familiarity with the Instagram Reels' vertical format would be advantageous. A knack for capturing candid moments of fun and compassion is pivota, thus ability to use storytelling as a tool to emotionally engage ...
I'm seeking a professional videographer for a charity event, the 'World's Greatest Shave' created and ran by Just Cuts Mt Ommaney. This event is scheduled for Saturday, 23 March at Mt. Ommaney Centre from 11am - 2pm. The main focus of your lens would be to capture footage for our Instagram Reels channel. Key Moments to Capture: - Parti...the event. Length of Footage: - The final Instagram Reel video should be no longer than 60 seconds, particularly crafted for vertical orientation on Instagram. For this role, experience in event videography and familiarity with the Instagram Reels' vertical format would be advantageous. A knack for capturing candid moments of fun and compassion is pivota, thus ability to use storytelling as a tool to emotionally engage ...
I'm looking for a seasoned developer to build a tool capable of extracting text ,images, and links from a specific website. I will provide in a text what links i need to be scraped and the tool should save the data in a folder I'm particularly interested in your past experience relating to similar projects. The essential requirement for the tool is it should be compatible with the Windows operating system. Ideal Skills And Experience: - Expertise in web scraping - Proven track record of creating data extraction tools - Familiarity with Windows environment and compatible programming languages - A keen eye for detail to ensure accurate data extraction.
Please Sign Up or Login to see details.
Please Sign Up or Login to see details.
Hi there! I am looking for help with some specific enhancements to the Shopify theme for New West Knifeworks. We recently launched an updated theme on the Shopify 2.0 platform but would like some additional dev fixes and do not prefer to work with the team that developed the customized theme. The required changes...Customizing certain info page templates and Shopify 2.0 sections to have branding options for our brother brand/site within a site, MTN MAN Toy Shop The ideal candidate for the job would have substantial experience in Shopify theme customization and a good understanding of UI/UX. You must also be proficient in adapting the theme for mobile responsiveness. We will use Asana as the project management tool for these tasks. Thank you! Margot
...can build a minimalist, clean website to effectively showcase my work process in architecture and interior design field, keeping my future clients engaged. The site will heavily feature: - Dynamic imagery or portfolio: Photos, sketches, models, and final creations should be visually striking, easy to navigate and update. Your experience in creating visually stunning portfolio galleries will be highly valued. This website should act as an effective tool during interviews to present to future clients, therefore the ability to add and alter content without comprehensive programming knowledge is a must. Skills ideally required: - Web design - Web development - Graphic Design - UI/UX Design - Portfolio Management -and its on squarespace i can always c...
...mobile app developer who can create a tool for designing modern wedding invitations. This is what I'm after: - An application exclusive to mobile devices, ensuring optimal user experience and functionality on both iOS and Android platforms. - The ability to customize templates, allowing users to express their unique style. This means rich functionality for altering layout, typography, color schemes, and imagery. - A focus on offering modern design templates. Though the emphasis is on contemporary aesthetics, the application should still be user-friendly and intuitive enough for anyone to design stunning wedding invitations. The ideal candidate for this project would have experience in mobile app development, specifically those involving graphic design ...
URGENT I'm seeking a talented graphic designer to create a visually striking 8x10 foot banner for my company that will be displayed to catch the attention of the public. Expectations for this project include: - Use of provided product images and company tagline in the design. - Utilize red, white and black, the colours of my company that I will explain in detail upon hiring. - Design should be traffic-stopping and reflect our company's brand. - Prompt turnaround, as this project is time-sensitive. Required skills and experience: - Proven graphic design experience, especially with large format designs. - Proficiency in graphic design software. - Attention to detail and solid understanding of colour theory. - Ability to work on a tight schedule.
...produce SEO-optimized content, track record of lead generation, understanding of fitness industry • Task: Develop and implement a social media campaign centered around fitness tutorials. The content should be appealing, shareable, and beneficial for local residents interested in group exercise and personal training. • Objective: The main goal is to significantly increase gym membership and class sign-ups through lead generation. If you have a flair for fitness, engaging content creation and possess the requisite digital marketing skills, this is the right fit for you....
I am looking to work with someone that can build me a simple web scraping tool to pull new listings from 3 different websites into a Google Sheet. The file attached will show the information that should be pulled from each website and compiled into a singular sheet. Additional instructions in the Word Document. I am also provided the code from the scraper I had built in 2022. Once reviewed, please provide your cost, timeline, and confirmation that the information can be pulled into a Google Sheet if I invite to be an owner. Thank you very much!!
...an experienced website developer who can build a website tailored towards business professionals. This modern, user-friendly website should serve as an effective tool for our company's online presence and feature the following: - Advance User Login/Registration system: The website should have an enhanced user login/registration system that ensures security and ease of use for our users. Ideal Skills & Experience: - Proficiency in modern web development technologies - Experience in developing websites for businesses - Experience in creating secure user login systems - Strong understanding of User Interface and User Experience design for business professionals - Ability to deliver the project on time and to high quality standards Please include relevant experienc...
Job Description: We are seeking a talented and creative Freelance Graphic Designer to design an 8-page booklet that embodies the essence of Groupe Morgan Inc. This booklet will serve as a key marketing tool, showcasing our services, philosophy, and the quality of our work to potential clients. The designer will work closely with our marketing team to create a visually appealing and informative booklet that reflects our brand's values and aesthetic. Responsibilities: Design an 8-page booklet that includes information about our services, company philosophy, mission, and vision statements. Create a compelling cover design that reflects the strength and reliability of Groupe Morgan Inc., incorporating our logo and brand colors. Develop layouts for interior p...
I need a skilled and experienced Figma designer who can help me create a desktop prototype using the Vuexy template. The purpose of this prototype will be for design iteration. Key Responsibilities: - Craft a functional Figma prototype using the Vuexy template. - Ensure design adheres to our minimalist style. - Iterate design as per feedback given. Ideal Candidate: - Experience with Desktop application design - Strong knowledge of the Figma tool - Prior experience with the Vuexy template would be advantageous. If you have a keen eye for design, a strong understanding of Figma, and especially if you've worked with Vuexy before, I would love to hear from you.
The task is to visit the location to: 1- Verify documents and get a form filled and sign stamped by the Augentageskliniken MVZ. 2- 4 to 5 geotagged photos are required with name board visible. 3- In case of refusal take the written refusal with stamp and get details of verifier Name, Designation and Contact. If above mentioned requirements are fulfilled than task will be completed.
I'm in need of a skilled Graphic Designer with experience in creating emblem-style designs. The m...will be developing a cohesive theme for my business materials, including business cards and yard signs. Key Responsibilities: - Create an emblem graphic design, reflecting the identity of my business - Apply this design to create a cohesive appearance for business card and yard sign Ideal Skills: - Proven experience in emblem graphic design - Proficiency in applications, such as Adobe Illustrator or CorelDraw - Experience in designing business materials would be beneficial - Strong understanding of design principles and techniques - Attention to detail and creative thinking Please provide examples of your previous work in emblem design, pa...
I'm seeking an experienced...I am set on a multi-page layout. Ideally, the website should be user-friendly and intuitive, allowing visitors to navigate smoothly. - Functionality: It must incorporate both user registration and a shopping cart. These are critical for my website to facilitate purchases and develop a customer database. - User Experience: The checkout process should be simple and secure. Additionally, the user sign-up and login process should be straightforward. The ideal bidder should have experience in: - Setting up shopping carts and user registration functionality on websites - Designing and developing multi-page websites - Creating customer-focused, user-friendly interfaces Your proven ability to achieve these would greatly increase your chances of succ...
I'm seeking an professional who excels in creating detailed Power BI dashboards. It will basically focus on visualizing Sales data, Financial data, and Marketing data, and will need to be...Financial data, and Marketing data, and will need to be regularly updated on a daily basis. The dashboards should incorporate visual elements including Graphs and charts, Maps and geographical data, as well as Tables and matrices. This ensures readable, engaging, and comprehensive interpretation of the crucial company data. Ideal Skills: - Exceptional knowledge and experience in Power BI tool. - Strong ability to structure data efficiently. - Proficiency in data visualization techniques. - Awareness of latest trends in data representation styles. - Ability to deliver on a daily u...
As your prospective developer, I understand you require a PHP tool that emulates the functionality of the Android Call App. This application should be able to verify if a person has a linked Facebook account using their phone number. I gathered from your inputs the following requirements for this tool: - Must be implemented as an API, with the phone number being passed as GET parameter in the API's URL. - The tool should be developed to be compatible with PHP 7.3. Before biding, freelancers should assure they have: - Extensive experience with PHP 7.3. - Comprehensive knowledge of API development. - Proven background in integrating applications with Facebook API. This project will be ideal for a PHP developer experienced with API development and Facebook int...
As a startup in the technology sector, I'm in need of a captivating investor pitch deck. This tool will be the driving force behind securing the crucial investment needed to fund my startup's ambitious goals. To achieve this, the designed pitch deck should encapsulatively demonstrate my startup's potential—showcasing our innovative tech solutions—and clearly communicate our business model to investors. Key skills and experience: - Verifiable experience in designing investor pitch decks for tech startups - In-depth understanding of the tech industry and investor landscape - Ability to articulate complex ideas, presenting them in a clear, compelling, and investor-friendly format - Strategic thinker, who can balance creativity with practical business ins...
I'm seeking an efficient, detail-oriented assistant for data entry and mapping tasks. The scope of the project will involve handling and arranging medium volumes of data Skills and E...detail-oriented assistant for data entry and mapping tasks. The scope of the project will involve handling and arranging medium volumes of data Skills and Experience Required: - Strong proficiency data mapping and entry. - High level of accuracy and attention to detail. - Ability to handle medium volumes of data. Expectations: - Efficient mapping of product categories to onsalenow database in CI front-end tool. - Diligent organization and cleaning of entered data. - Ongoing assignment - Other administrative tasks that may arise from time to time Please ensure you've completed compara...
I'm in need of an expert who has great capabilities in Groovy programming language to help write a Jenkins file that will be used to facilitate Continuous Integration in a cloud-based environment. DETAILED REQUIREMENTS: Groovy: - Must have extensive experience in Groovy programming language. - Should be able to create a Jenkins file that supports a robust CI pipeline. Continuous Integra...strong background in the implementation and management of CI pipelines. - Will need to ensure the pipeline can handle regular and reliable code changes. Cloud-Based Environment: - Should have experience integrating applications in the cloud. The ideal freelancer for this project should have a firm grasp of DevOps principles and should be adept with the Groovy language and Jenkins as a CI/...
...SEND FINAL PROPOSAL Home Page: Banners: Purpose: To visually link to key sections: Trends, Influencers, Promotions, Contact, and Newsletter Subscription. Task: Incorporate a responsive slider plugin (e.g., Smart Slider 3 or Slider Revolution) that allows easy updating of banners through WordPress's admin panel. Each banner should have editable text overlays and be clickable, leading to respective categories, including a special banner for encouraging newsletter subscriptions. SEO Consideration: Use descriptive ALT tags and filenames for images to aid SEO. Insert a newsletter subscription section on the bottom of the page as the reference here Menu: Purpose: To navigate to different sections of the site: Trends, Influencers, Promotions,
I am looking for a seasoned software developer to build a salon and beauty booking appointment app - with similarities to Fresha.com. To make sure the app provides optimal utility for users, I want it developed for both iOS and Android platforms. As far as app’s functionality, it must have the following key features: - Online payment system - A real-time schedule availability tool - Service selection options For comprehensive management and to improve user experience, User and provider apps along with a management dashboard are required. Additional features for user and provider apps should include: - Push notifications - Rating and review system to ensure feedback and constant improvement - Appointment reminders to minimize no-shows and last-minute cancellations. To ...
My project involves designing a rigid metal d...metal dryer vent duct of 50 feet maximum length. The design must account for efficient airflow, fire safety, and city approval requirements. Optimizing the duct to fit within the space provided is a crucial task. Ideal candidates will have experience with ductwork design, fire safety protocols, and city code requirements for HVAC systems. Expert knowledge about airflow optimization and rigid metal material is desired. There are 2 vent ducts and 2 separate dryer vent booster fans installed on 4" ducting. I need the design to have engineering approval to supply to the city inspector. I will need an engineer with a stamp or some form of verification for the state of California that the City building department will acc...
I'm seeking a proficient animator to create a standout Lottie animation for the banner of our website. The purpose of this animation is to prominently highlight a product promotion. Here is the document with requirements, please only apply if you know you're capable of delivering it end-to-end and have portfolio to back it up.
I urgently require an expert in Node.js, JSON, and MongoDB to develop a reliable plagiarism checker for my code. Key requirements include: - Ability to work with Node.js, JSON, and MongoDB code - Produce either a command-line tool or a web-based solution - Deliver results promptly and efficiently Ideal candidates should have experience in developing code plagiarism checkers and confident in handling large pieces of code. The ability to work quickly and effectively is a bonus.
I need a skilled professional to photoshop my images of cap onto a white background, enhance colour so they look sharp Also hang a cap to penny lane sign and put one on mans head who is signing penny lane sign (both images attached). The focus is on making these images look clean and professional for a website and promotional materials. Key aspects of the job include: - Photoshopping 1 items. - Ensure that all images are in front, side and top view. - Create a clear white background without compromise on the clothing details. - add cap to both images of man and also street signs Ideal candidate should be proficient in Photoshop and have a keen eye for detail. A background in fashion photography editing would be a bonus. The freelancer should understand the importance of...
...for students to sign up and enroll in the courses. - Interactive quizzes: a platform where students can review their understanding with quizzes. - Live chat forum: a space for students to converse, share difficulties, and help each other. - A section for PDF resource and test purchases: on the platform, a library for useful math resources and tests for students to purchase. - A booking system for scheduling: integrate with Zoom to enable students to book tutoring sessions directly from the site. The ideal freelancer would have experience building similar educational platforms, with a particular focus on incorporating the e-commerce aspect into it. Experience in integrating video conferencing tools (like Zoom) would be an advantage. A deep understanding of user-friendly design...
I currently operate on SharePoint 2016 with customizations using Jsom and I require skilled help to migrate and properly integrate these customizations into a new environment. The project includes: - Migration of SharePoint 2016 to SharePoint Online - Ensuring...multi level approval-approx 5 levels, 15 list, 5 libraries, data per list 2000 to 25000 items, pages can be edited by logging into sharepoint designer and manipulate html css js, for functionaliyy and logic there are different js files , I need someone with: - Solid Experience in SharePoint Migration - Expertise in Jsom - Proven track record managing third-party integrations - ShareGate tool This project will require careful planning and flawless execution. Please only apply if you have substantial experience in th...
In my project, Azure Active Directory is being implemented primarily to manage user authentication, authorize thousands of users, and provide single sign-on for various applications. I am seeking an expert with extensive experience in Microsoft Azure, particularly in Active Directory. I also require a comprehensive review of our system with specific focus on the following areas: - Identifying potential issues and weaknesses - Enhancing system efficiency and reliability - Scalability assessment and performance optimization Your skills and experience should ideally include: - Advanced knowledge of Azure Active Directory - Proven experience in system review - Expertise in performance optimization - Understanding of security vulnerabilities. Our primary goal for this project is to...
I'm looking for a designer specialized in WordPress to make some changes to my current WordPress template. Please don't request more than $50.00 - Great entry level project. 1. Navigation - Need a HOME/ House icon on the menu bar. Also need to add a "right" margin on the menu. Both on the home page and the sub pages. 2. Banner developed with the logo, colors and a quote, provided in a psd file. 2. Blog Categories - Both the Resources and Stories page are blogs and should only contain the category selected in the blog.
i need to redesign the home page only for my clinic website, specially mobile version, you can use the same designs and images from current version, and keep the main sections it will be great if you can make a dummy page on a link. main focus is mobile friendly page with more focus on banner and advertisements area with clear call to action for calls and whats app home page : logos and design elements:
...as it has the features that I need in my website. Languages to be used: HTML, CSS, JavaScript using React.js framework. Database: PHP with MySQL. The website should have following: • Starting page: Page that is shown when webite is visited; Has Get Started, Sign Up and Sign in; Refer demo video. • User Sign Up and Sign in: Authentication and account creation process; Account verification for added security; Google sign in; Users should be able to customize their profile, add social media links; refer Sign Up and Sign in. • Home page: Acts as main page or gallery of all the featured, trending art, latest art; refer and demo video. • Shop section: 2 types of users - buyer and seller; Buyer buys the work from s...
Its a simple project. I have an excel sheet consisting 500 rows with customer chats. I want a tool using chatGPT API or any other tool API to summarize the chat in the adjacent column.