Hi there,
I’m trying to setup a zap that inputs the latest date that an e-mail was last sent to a particular e-mail address into a Google Spreadsheet. I have a spreadsheet with two columns: (1) e-mail addresses and (2) last sent date:
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/ca1152e6-b801-419d-985d-3007dd943678.png)
Here’s how I have it setup in the zap:
- Trigger: “New Email in IMAP by Zapier” (linked to my “Sent” inbox)
- Action: “Lookup Spreadsheet Row in Google Sheets” (looking in the “To Address” column for the “To Address” fetched from IMAP)
- Action: “Update Spreadsheet Row in Google Sheets” (with the “To Address” / e-mail row inputted with “Last Sent Date” fetched from IMAP) [see settings here]
Everything seems to make sense to me, but I’m getting the below error. The issue seems to be with the dynamic look-up for the row to update, as when I select row 2, it inputs the date as it should.
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/a932dc1f-b501-48c8-89f9-1ec8fd56adae.png)
Anyone have any idea what I’m missing?
Alex
Best answer by Alex H.
View original