Parsing Gmail data and passing to my google sheets in a row

How To
,
1

Dear all,

I am facing issue and need your help. I would like to parse data from my gmail about leads and wanted to transfer to Google sheets. I am using Text Parser module..>Match Pattern..> and put regular expression

Name : (?[^\n]+)\s+Email : (?[^\n]+)\s+Phone : (?[^\n]+)\s+City : (?[^\n]+)\s+State : (?[^\n]+)\s+Pincode : (?[^\n]+)\s

but once I connect to google sheet module,nothing is showing ..kindly help..Enclosed my screenshots

Email
Email528×357 27.2 KB

1 Like
2

Name:\s*(.+)\s+Email:\s*(.+)\s+Mobile:\s*(.+)\s+City:\s*(.+)\s+State:\s*(.+)\s+Pincode:\s*(.+)

  • Gmail Watch Email module:

Set it to watch new emails with subject like New Green Exchange Form Submission.

Text Parser – Match Pattern:

  • Input body content of the email (e.g., text or body).
  • Use the regex above.
  • Test to confirm correct values are matched in order.
  • Google Sheets – Add Row module:
  • Map each regex match group (1–6) to your sheet columns:
    • Column A: 1 → Name
    • Column B: 2 → Email
    • Column C: 3 → Mobile
    • Column D: 4 → City
    • Column E: 5 → State
    • Column F: 6 → Pincode
1 Like
3

Ur GEM of Person Dear ..Thanks..NAMASTE From India

4

Thanks One more Help I am getting lead details in Google Sheet 1 through scenario (Gmail+Text Parser+Google Sheet) which contains columns like Customer Name, Email, Phone, City, address, Pincode..Now I want to compare new row with execiting Master Google Sheet 2 on the basis of Pincode matching. Sheet 2 contains (Pincode, Dealer Name, Dealer email, Store name) data. Based on comparision I want send mailer to Dealer email id through Oulook â€ĶI am using below Scenario

  1. Watch New Rows-> Google Sheet 1
  2. Search Rows-> Google Sheet 2 Filter Pincode from Sheet 1 & Sheet 2
  3. Outlook-> Create and send message-> To Recipients-> Dealer email & Name

But its not working..Please help