Copy and Paste data from ChatGPT using Google Spreadsheet

Help Studio
, , , , ,
1

Hey, UiPath community,

I have a requirement in which I have to copy the data from a Google spreadsheet and paste it to ChatGPT and then copy the ChatGPT content on a website. I need help in copying the data from ChatGPT. Could someone let me know the best activities for this work? I have to search 3-4 columns in ChatGPT and have to copy each result separately.

Any help will highly be appreciated.

2

Hello @Muhammad_Anas_Baloch, try this:

  1. Open Google Spreadsheet: Use the “Open Browser” activity to navigate to the Google Spreadsheet URL and interact with the website.
  2. Read Data from Google Spreadsheet: Use the “Data Scraping” activity to extract data from the Google Spreadsheet. This activity allows you to select the data you want to scrape from the spreadsheet and store it in a DataTable variable.
  3. Interact with ChatGPT: To paste the data into ChatGPT and extract the results, you can use the “Type Into” activity to enter the data into the ChatGPT input field. Then, use the “Get Text” or “Screen Scraping” activities to extract the results from ChatGPT and store them in variables.
  4. Interact with the Website: Use the “Open Browser” activity again to navigate to the website where you want to paste the ChatGPT results. Use the “Type Into” activity to paste the results into the website.
  5. Repeat for Multiple Columns: If you need to search multiple columns in ChatGPT and copy each result separately, you can use a loop (e.g., For Each Row) to iterate through the DataTable containing the data from the Google Spreadsheet. For each row, you can extract the necessary columns, paste them into ChatGPT, and store the results for pasting into the website.

Cheers!!

1 Like
3

Hi @Muhammad_Anas_Baloch ,
You can take the value in the spreadsheet one by one, copy it with send hot key and paste it into chatGPT, then use send hot key copy the result and paste it back in the spreadsheet.
Regards,
LNV

1 Like
4

You can try data scraping to get data from web applications or if the data comes in a somewhat structured format extract datatable may work

1 Like
5

Thank you for letting me know about these activities. Could you please help me out with how can I use get the text for dynamic text? As my text will always be changed. Other than that how can I copy the latest response?

6

while indicating you will get an option “conversion to dynamic text”
you can try that


4 Likes
7

Will surely check it. Thank you