Hey~ First thing first I am very new to n8n, currently I am working on a workflow in which I have to extract some information from google sheets on google drive, so could anyone suggest the any method to get this done.
I want to point out is the extract from file section. I just want to extract the root cause and the corrective action part only. But I don’t know how to work on that.
Hope have guys can help me to solve it~
Hey @Joe_B hope all is well. Welcome to the community.
Could you share one such document for us to experiment with?
It seems like cannot upload the xlsx file
you can share the document as read only for anyone with a link
Trying to open, no access
There you go, here is how you can extract root cause and corrective action from that sheet:
The result:
Obviously you will need to point it to your sheet, as I made a copy.
So, I no need the extraction function?
You don’t, unless you really want to… 
It also depends if the structure of the text remains the same, then this should work
Kindly mark the answer as solution if it was helpful. Thank you.
Cheers!
If this solution solved your problem, kindly mark the answer as solution. Thank you!
Cheers!
For the extract part I have solved it and now I have a problem on the AI agent’s prompt.
Then, using the AI Agent to verify if both sections are filled.
If both are valid, should sent a confirmation email to the issuer to said that the root cause and corrective action has been filled.
If not, the receiver should be notified to complete the missing sections.
Can you help me to improve the prompt?
Hi, how would you like the prompt to be improved? What is the prompt now? What is not good about it? What is the receiver? When posting a question, expect people to know nothing about your problem and provide enough context for people to understand it.
Alright, I try to mentioned clearly.
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.
