Extract from emails into a structured Google Sheet

Hi there,

I am building a workspace Studio workflow:

  • I am extracting unstructured data about companies from emails
  • I used one Workflow to label all emails with Gemini (it works)
  • I am now trying to create a second workflow to extract the unstructured data from the email and put it into a Google Sheet. I have a template sheet called (creatively) “Meat Grinder” and I am trying to match the data type with the Google Sheet. Each email may have mutliple companies in them so I need to create a string (per company or per type of info like Company_name and company_URL etc) but somehow it always end up pulling only one company per email, can you help please?
    Thanks,
  • Thanabur