Unanswered

Automating ChatGpt prompts from an excel sheet.

(0) Share

Report

Posted on by thatonedev

Hello Power Community,

I have been using power automate for some basic work only. But now I have to perform some dynamic operations. I have to automate ChatGPT prompt process. What I want to achieve is I have list of prompts in an excel column and i want to automate giving chatgpt prompts from the excel. For once it can be done like taking a data from colum and gilling in the gpt prompt form. But i need to automate it so that it takes the prompt save it somewhere maybe in excel or word file and then go to excel and take another prompt.

I was wondering how we can achieve this dynamic form filling with power automate.

Categories:

Power Automate Desktop

All responses (5)

Answers (0)

Sort by

Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @thatonedev

First you have to read excel and store the data in a datatable variable like below

Consider you have excel like this

Now you have to try this flow to get data from excel in form of datatable

Now you will get data in form of datatable ExcelData2 , now loop through it like below

Here by passing %row['Prompt']% we will get prompt value for each row in excel.

Hope it helps !
thatonedev 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello yes i see that and its clear but where should i be putting the form fill up part to the web form?
Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @thatonedev

I did not get your question

I hope you are using chatgpt api under the loop and extracting some details from it right ?
thatonedev 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello, Thanks for getting back. I mean i was thinking i am automating the UI of ChatGPT interface why would i need an API? I do have a billable API but thats not i want to achieve. I want to simulate the UI. So i wanted to get one row say prompt come to the web form of chatgpt and paste it and copy the generated answer to excel or word anywhere then copy next prompt and repeat.
here is the flow that i was just try but something is wrong and incomplete here i know, but not exactly what. please check the screenshot.
thatonedev 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello there is an update i made the flow and it sucessfully took the column content copied it to clipboard and pasted to chatgpt please guide how can i loop so that it pastes the new copied cell everytime when chatgpt is done writing answer.