ChatGPT to Excel Help

[Mark15]

Hi Makers, I’m new to this and I have created the following scenario and I need help with one step.

I have an excel spreadsheet that has the website url for every blog post we have published

Perplexity is retrieving the article and summarizing it and also retrieving the article title from the spreadsheet

ChatGPT is then taking the post summary and creating a social media post from that information

I want to now take that post created by ChatGPT and copy it back to a cell in the original excel file in the row where the original post came from

Eventually I want to take that post and automate the publishing to a social media site but for now I just want to have all the posts created.

Any suggestions on how I take the social media post from ChatGPT and paste it back into the excel spreadsheet?

[samliew]

Welcome to the Make community!

To do this, you can try using the Microsoft 365 Excel “Update a Worksheet Row” module —

Updates an existing worksheet row.

For more information, see https://www.make.com/en/integrations/microsoft-excel, and https://www.make.com/en/help/app/microsoft-excel in the help centre.

Here is an example, you’ll need a minimum of three modules.

This is just an example. Your final solution may or may not look like this depending on your requirements.

Hope this helps! Let me know if there are any further questions or issues.

— @samliew

P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.

[Mark15]

Thanks @samliew that got me on the right track. I have gone through some of the Academy content and I will get back to that to help me with my work here. Thanks!