Тёмный

Automating Question-Answering with Google Sheets/Excel and ChatGPT 

U-xer
Подписаться 98
Просмотров 334
50% 1

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

Опубликовано:

 

3 май 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 4   
@piceap
@piceap 9 дней назад
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 ?
@U-xer
@U-xer 8 дней назад
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.
@Harndog
@Harndog 24 дня назад
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?
@U-xer
@U-xer 24 дня назад
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
Далее
A GENIUS Way to use ChatGPT for Presentations!
7:38
Просмотров 81 тыс.
Прилетели в Дубай
00:17
Просмотров 75 тыс.
New Gadgets! Bycycle 4.0 🚲 #shorts
00:14
Просмотров 10 млн
Designing scalable Compose APIs
19:53
Просмотров 10 тыс.
5 New AI Tools You Should Try
9:18
Просмотров 13 тыс.
Прилетели в Дубай
00:17
Просмотров 75 тыс.