Email Parser to Text Formatter to Google Sheets

[Roberto]

Hi, I am trying to extract data from the body of a daily email I receive. I am using Email Parser as a trigger and run Text Formatter about 20 times to extract the different sets of information I require. After verifying this, everything seems fine, until I try to move the contents into Google Sheets.

When I use the Google Sheets: Add New Row action, it puts all the information into the first cell of the next available row. What can I do separate each Text Formatter action into a different cell within the newly created row?

 

[Fagun Shah]

Did you create different columns with headers in gsheet and mapped values to those headers/fields in pabbly connect workflows add new row action?

 

[Roberto]

My process in Pabbly Connect was right, but the problem was with my Google Sheet. The first row in the Google Sheet was being used for the title of the sheet. I eliminated that row so that the headers now appear on row 1. Now the Google Sheets: Add new Row action identifies each column and allows the values to be mapped. Thanks!!!