Question

Convert Email Table into Google Sheet Rows

  • 22 February 2020
  • 1 reply
  • 313 views

Userlevel 1

I'm not sure how to convert the body of this email (plain text) which contains a table into new rows into Google Sheets.

I have been trying to use Formatter by Zapier to achieve this but not getting there.

Help please!

Screenshot 2020-02-22 13.25.09.png


This topic has been closed for comments

1 reply

Userlevel 7
Badge +10

Hi @vgrow! From the looks of the email, I think that the Formatter is likely going to be your best option, though it might be tricky.

Could I ask if the number of rows in the table is the same each time? ie do you always have two invoices? Or could there be different numbers?

So that we can take a look, could you post a screenshot of what the text of the email looks like in the Zap? Specifically, we need to see how the table is coming out, to see if there are any characters that we can use to split the text.