Automating Question-Answering with Google Sheets/Excel and ChatGPT

Поделиться
HTML-код
  • Опубликовано: 5 окт 2024
  • In this video, we will retrieve questions from Google Sheets, ask them to ChatGPT, and write the results back into Google Sheets. This process can also be applied to Microsoft Excel.
    Pre-conditions:
    - Open the Google Sheet on one side and ChatGPT on another. With U-xer, you don't need to open a new browser, log in, or solve captchas. It can start working on your screen like a human does.
    - Highlight the 1st cell on the Google Sheet at the beginning.
    How to do?:
    1. Copy and paste the script below
    2. Change the 7th line to add a fresh "CopyIcon". It is explained in the video.
    It will probably take 5 minutes to write your own scenario. You can use it for 20-30 lines or 1000 lines of questions.
    *Scenario*
    Click Text "Google"
    SendKeys CONTROL VK_C
    Click Text "Message ChatGPT"
    SendKeys CONTROL VK_V
    SendKeys ENTER
    IsVisible Text "Message ChatGPT"
    Click Image {CopyIcon}
    Click Text "Google"
    SendKeys RIGHT
    SendKeys CONTROL VK_V
    SendKeys DOWN LEFT
    🔗 Helpful Links:
    • U-xer Website: u-xer.com
    • User Community: community.u-xer.com
    • Discord Channel: Join U-xer on Discord
    • Connect with Zek: Zek's LinkedIn
    • Company LinkedIn: Quality Museum on LinkedIn

Комментарии • 7

  • @marianzefferer-nlp
    @marianzefferer-nlp 3 месяца назад

    Is it possible with your software to automate some simple cutting stuff on camtasia? Itwould be always the same stuff to do (include intro, outro, nominalis audio, cut begging and end of there is just stillness or noise)?

  • @billsin9717
    @billsin9717 Месяц назад

    i need alternative to google sheet how i can make something like this but with software thats free and dont need login

  • @Harndog
    @Harndog 4 месяца назад

    Can the agent go to a website and download various CSV files.
    I am interested if the agent can record my steps like an Excel Macro.
    Can it do this?

    • @Uxer.ai.automation
      @Uxer.ai.automation  4 месяца назад

      Hi Harndog, I agent can click texts and buttons. If there is a link called "Download csv" or anything like that you can do it very easy. However, if you don't know the exact name of the link then it is not possible. Currently U-xer expects exact commands.
      It doesn't record your moves. It just executes your commands.
      Examples are here: community.u-xer.com/c/documentation/5

  • @piceap
    @piceap 4 месяца назад

    Ok scenario is set to start with first line. If I create scenario job each minute it will automatically go to next line? Or how this can be done ?

    • @Uxer.ai.automation
      @Uxer.ai.automation  4 месяца назад

      It will not go to next line automatically. You need to go to next line in the end of scenario so that it will be ready for the next execution.

    • @tahooo1402
      @tahooo1402 2 месяца назад

      @@Uxer.ai.automation How does ist work? I assume that the last action sets the active frame in the Google Sheet one row down, if the focus comes back to the Google Sheet as part of a job then the active frame is still there and the actions are then executed on this row, right? If so, then you must always ensure that the focus is in the correct position. So it would probably not work if the sheet was closed and opened, because then the focus is automatically at the top left. Is there any idea how a solution could work in this case that still uses the next line? Can U-xer count, i.e. "1+2=3"?