I’m trying to collect form information from gmail to update a Google sheet. Each module when run independently checks out but when I run the scenario, the row doesn’t get added in the sheet. It’s my very first attempt at a scenario so I could use some help. 
I have already double checked all of the connections and deleted and recreated several times. I’ve tried using ChatGPT for assistance but so far no luck.
Hi @Bill_Johnston Welcome to the community!
When there is no output from the Text Parser module, it will not continue further to Add a row. You just need to make sure that text parser module generates some output and once you map that output to Add a row module, you will be able to see the new rows.
Best,
@Prem_Patel
Hi Prem,
I was wondering about that, but I don’t know why the data in the email is not being parsed. When I run that module independently, it says it’s successful but still no output. Any ideas?
Can you share screenshot of email output and text parser setup and what info you are trying to extract?
Hey Prem,
Here is what I’m trying to get into a Google Sheet and the setup that ChatGPT gave me for the parser.
Text parser can work sometimes if configured correctly, but you can try Make’s New AI modules to extract this info. you can write a simple prompt like this and it will extract the info, so you can proceed further. Module name is Make Ai tools > Request anything. Set it up with email body text and add a prompt.
Output
If you need each value separately, you can add prompt to output only answers separated by | character. so you can use split function get them 1 by 1.
Extract using split and get. You can map same formula directly in sheets or CRM input fields.
I hope this helps.
Best,
@Prem_Patel
Hey Prem,
That looks great thanks, but I’m on the Free version of Make so that module is not available for me.
In this case, you have to dig deep in text parsing. to extract those fields data. or if that form is created using any form service, you can use " Watch responses" or webhook feature to get that data in make.
