Steps taken:
- Invoice is uploaded through "On form submission"
- Text is extracted (Extract from file)
- Information is extracted (Information Extractor with Gemini Chat Model)
- Row is appended to Google Sheet (Append row in sheet)
- Generate an email (Basic LLM Chain with Groq Chat Model)
- Code node to make the output useable for gmail node to send email, with name, designation etc in variables
- Email sent (Using Gmail: Send a message)
Workflow image and exported json attached.
Comments and suggestions appreciated, to make the flow better :)