Google sheets simple task?

[sid02]

Rookie question here, been trying to work this out for a couple of days…

- I have a google sheet with a list of file names of videos.

• The file names are in the structure “[username] - [video description]”

I want chat GPT to create a new description for each one with better keywords and then the [user name] at the end. And then output into a different sheet.

Any help?

[Ahmad_Hassam]

@sid02send the screenshot of your query, and then help you

[sid02]

I only have failed attempts at creating workflows for this. I don’t think they’re even close

[Ahmad_Hassam]

ok share your workflow json

[sid02]

Where do I find that?

[sid02]

Can anyone point me to a template that is close?

[Rahi_Uppal]

Just copy the n8n nodes, and paste them here

[sid02]

That won’t help as I have very little idea what I’m doing

[WillNotGiveUp]

I created this simple workflow and hope it will help to inspire you.

[WillNotGiveUp]

[sid02]

You’re an absolute legend! Thanks very much. With a few tweaks I can get this to do what I want but now I’m able to picture how it works and get off to a start.

[WillNotGiveUp]

You are welcome, and I’m glad that it helps.

[sid02]

@WillNotGiveUp I’m trying to figure out how I can get it to fill another column with titles as well

[WillNotGiveUp]

@sid02 Can you be more specific on where to get the data of the “Title”?

[sid02]

@WillNotGiveUp In my head I was thinking to just get the GPT to generate it from the video filename as well

[WillNotGiveUp]

Like this?

[sid02]

@WillNotGiveUp That didn’t seem to work

[WillNotGiveUp]

Seems like “Update row in sheet“ node does not recognize the 2 variables. Please check if the previous node passed the correct variables.