I am thoroughly stumped on this one. I would SO appreciate any assistance.
My gmail account receives a daily automated CSV attachment with two columns of rows that I would like to add to a Google Sheets spreadsheet (if they are not present already).
- I would like to take the CSV attachment from gmail & parse the rows.
- I want to search the existing rows in the Google Sheet and only add rows from the CSV attachment that don’t already exist in the Google Sheet.
Where I’m at so far:
- Trigger → New Email in Gmail
- Action → Utilities in Formatter by Zapier
- Action → Create Loop From Line Items in Looping by Zapier
- Action → Lookup Spreadsheet Row in Google Sheets (add if not found)
Problems I’m having:
- Looping by Zapier doesn’t seem to be breaking out the line items given it by Formatter by Zapier. See attachments below:
Line items working as they should from Formatter (as far as I can tell) Pic #1
Line items not working Pic #3
- When I run the test, the Google Sheet is being updated in a way that seems consistent with what Looper is creating. What I’d like is for each of these to be in their own Row, not all in Row 2.
Any ideas? Thanks so much!!