Extracting data from google spreadsheet to send it by email

Hi
I have being trying for hours to extract some info from a couple of columns in excel paste them in gmail module (content field) but it was impossible.
Each column has a word that user inputs in google sheets and i just received in the email a couple of characters not a word.
I choose Google Sheets - Watch New Rows and Gmail Module.
What i was expecting for example that column Name with content John extracted to the gmail module and send an email saying “Hi John” But i just get “Hi J”
Appreciate any help. Thank you

1 Like

Hi @kvnz

Could you please share the snapshot of the mapping in Gmail module?

Regards,
Msquare Automation - Platinum Partner of Make
@Msquare_Automation

i recently changed the scenario because i read it was better with a webhook
So scenario is webhook + gmail
Webhook receives an array with 6 items but i cant access the array from the “content field” in the Gmail Module. At the Gmail module it just appear one item, the first.



1 Like

I have changed the json format and added an iterator but the module does not iterates.
I feel a bit down about it.
Thanks in advanced

1 Like

I finally solved it! The issue wasn’t with how I was doing it but with how I was running it. I had been executing each module separately, but when I ran them all together, everything worked perfectly.

2 Likes