Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

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:

 

 

Here’s how I have it setup in the zap:

  1. Trigger: “New Email in IMAP by Zapier” (linked to my “Sent” inbox)
     
  2. Action: “Lookup Spreadsheet Row in Google Sheets” (looking in the “To Address” column for the “To Address” fetched from IMAP)
     
  3. 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.

Anyone have any idea what I’m missing?

Alex

Any feedback here?

And just to clarify after re-reading my initial message: the e-mail showing in the error is indeed within the list, it’s just not showing in the screenshot I provided.

 

For the third step, if I select a specific row (i.e. the row that has that specific e-mail in it), it successfully inputs the correct send date, but when I use the dynamic look-up (from my second zap step), it prompts that error.

 

Very frustrating.

Update – the solution was that I had to select the “ID” variable for the dynamic row.

Hey @Alex H. thanks for letting us know! So glad you were able to figure out the solution for this one. :) 

Reply


Terms & Conditions