Extract answers from email with questions in a google sheet

[Donna]

(https://docs.google.com/spreadsheets/d/1Fry411YCmkH33VMWyPRa_L-MbVuqjkqRD-yGzdXIgvE/edit?gid=0#gid=0)

Look at the flow

1. I receive an email with answers to 2 questions: a. What is the collor of my car and b. with who do I have a meeting tomorrow
2. (these questions are in a google sheet (not attached/used in the flow)
3. I’m able to scrape the extract the answers when I copy paste the questions in a Extract data node
4. But now I want to update the sheet (with the questions) and I need to connect the Search Value

A. How do I do this, as the sheet does not have a reference
B. Can I feed the questions from my google sheet into the Extact Data node ( I do not think so)

(after this I want to be able to send a follow up email if not all questions are answered … still need to figure out how to do this)
Thanks (as always)

[Wasay-Gumloop]

Hey! Can you share the workbook and some run links please?

[Donna]

Here you go
https://www.gumloop.com/pipeline?workbook_id=qYHH4ZL8zKYh8VQCkFmzkq

[Donna]

Good morning. @Wasay can you shed some clever light at this?

[Wasay-Gumloop]

@Donna

https://www.gumloop.com/pipeline?workbook_id=qYHH4ZL8zKYh8VQCkFmzkq

Hey @Donna

1. I see that you’re using the Sender Name as the search value, does that not work in your case?

2. You can feed data from a Google Sheet into an Extract Data node, you’ll just have to use a Join List Items node in between to smush the list output of the Sheet in one text block for the Extract Data node.