Hello to all
I don’t know how to update the cells of a specific column on Google Sheets with the data generated by Openai.
My workflow is simple but I can’t do it.
From the basic information in my Google Sheets and the information that will be generated by Openai, I want to update the cells in my Google Sheets with the data from the Openai completion.
More concretely, here is what I am trying to do on n8n…
Node 01 :
I ask n8n to read my Google Sheets file where I put a list of names in column A.
I ask Openai to write a small profile biography from the names in my Google Sheets, for example the one in cell A2 of my spreadsheet.
This generated biography must go into Cell B2 of the same Google Sheets. So I have to update B2 with the biography generated by Openai
Then, I ask Openai to generate a list of jobs from the biography previously generated in my Google sheets in B2. Here I have to take the answer generated by Openai in cell B2.
The list of jobs generated must then be put in column C of the same Google Sheets with the update of the right cell which is C2 here.
Basically, how to put the right data in the right columns and cells on google sheets.
Here it is, on paper it’s simple, but I’ve been knocking my teeth on it for 3 days. Can someone help me please?
I don’t know how to configure the nodes on Google Sheets with the right dynamic variables.
Thanks in advance for those who will take the time to help me
Here Workflow ::
And Here the screenvideo of my full workflow with Google sheett : duration : 3:25