Hi, I want to create an automation where the data can pulled from a cell in my excel sheet and run it through ChatGPT to optimise the data further and give me back the result in a new excel workbook.
Does anyone have any suggestions on how to do this? I can’t figure out what the workflow of this automation should be.
Hi @Unaiz_Shehzad,
I have done something similar, but with Google Sheets instead of Excel. This is what my scenario looks like:
The trigger is looking for a new row in the Google sheet. It then passes the text from one of the cells in that row to ChatGPT, where I have a prompt to check for spelling and grammar mistakes. It then updates the same row, and adds the ChatGPT response to a new cell.
You could do something similar with Excel if you are using Office 365, and have that as the trigger.
I’m happy to share what’s in each step if you want more info.
Hi @Blair_Wadman
Thanks so much. I followed this and it works just fine now. There is a lot of hit and trial with automation, I guess. But my scenario is working perfectly now.
Thanks a lot.
2 Likes