Watch email + google sheet

Beginner Questions
1

:bullseye: What is your goal?

I receive an application to become a member of a jazz club via Gmail. I want to retrieve the candidate’s details and transfer them to a Google Sheet.

:thinking: What is the problem?

I have a lot of unwanted characters in what I’m retrieving. Despite using different filters (trim, replace, etc.), it’s impossible to get clean text that I can then split into an array.

:test_tube: What have you tried so far?

For example, I replace line breaks with a single space between quotation marks, but I still find lots of quotation marks in the output. And I want to split this variable into an array, but it doesn’t do that and writes everything into the first cell of the Google Sheet.

1 Like
3

Hi @Laurent_Rouach. Welcome to the community.

Have you tried Make AI Toolkit? Maybe you can feed it the text from the email and ask it to format that text for you. It can then output json to insert into Google Sheets.

@damato

4

Hello,

Welcome to the Community!

If that’s possible, change your process and collect details using a form service like Tally.so . You can connect it to Make and create a whole workflow around that. It will simplify your life as you will receive structured input.

If your users submit their applications using plain text, @damato’s solution with using AI sounds reasonable as it will be able to “understand” the application and process it. So +1.

Another solution is to use Regular expression (Regex), but that will only work if your email is somehow structured, for example (GPT generated):

Name, surname: Joe Doe {{/n}}

Regex: (?<=surname:\s).*?(?=\r?\n|$)

Should return Joe Doe

Have a nice day!
Michal

1 Like
5

Hi @damato. I didnt know this option. tks a lot!

2 Likes
6

Hi @mszymkowiak Thank you for your responsiveness.! The application come through our wix website and this part hasnt been developped with a form

1 Like
7

Hi @Laurent_Rouach ,

Thank you for reaching out.

To help us better understand and troubleshoot the issue, could you please share an example of the data you are receiving via Gmail - similar to the ones you are processing?

This will allow us to test it and suggest a solution to clean and transfer the details properly into Google Sheets.

Best regards,
Msquare Automation
Platinum Partner of Make
@Msquare_Automation