Email Parser to Text Formatter to Google Sheets
Status: Closed · Asked by Roberto on · 0 views
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?
Did you create different columns with headers in gsheet and mapped values to those headers/fields in pabbly connect workflows add new row action
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!!!