Best answer

Create multiple rows in Google Sheet - parsed from line items in an email

  • 27 May 2021
  • 1 reply
  • 473 views

Hi Everyone

I’m familiar with using email parser to move data via a zap into a google sheet.  But my issue now is I want to polulate a number of colums with several rows of data, instead of just one new row - specifically, it’s a timesheet email which has data for each day of the week.  The data needs to go into specific columns, but I also want a row for each day. The email parse contains data for every day, Monday to Sunday, but currently, the zap will only pick up the first day, ie Monday. Any ideas?

icon

Best answer by Troy Tessalone 27 May 2021, 16:43

View original

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

Userlevel 7
Badge +14

Hi @Gary Harvey 

This will depend on a few factors.

  1. What email parser you are using. (e.g. Mailparser)
  2. How the email parser is paring the data.

Once the email parser parses the email data correctly, then you can look towards solving the multiple rows.

GSheets Create Row(s) options can be used with Line Items: https://zapier.com/help/create/basics/use-line-items-in-zaps

See Formatter > Utiliies > options related to line items that may be needed to prep the email data once parsed: https://zapier.com/help/doc/how-use-line-items-formatterv2