About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

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

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

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.

  • Home
  • Get Help
  • Troubleshooting
  • Delay Until in Delay by Zapier error: Missing Required Field in Zapier. Sending Follow-up Texts from Google Sheets.
Question

Delay Until in Delay by Zapier error: Missing Required Field in Zapier. Sending Follow-up Texts from Google Sheets.

  • 24 January 2024
  • 5 replies
  • 22 views
S

I’m getting the following “Delay Until” error:

 

Required field "Date/Time Delayed Until" (delay_until_date) is missing.

 

Here’s my setup:

This is part of a Zap to send follow-up texts to people we’ve met. I’m telling Zapier to “Delay Until” a specific date that I input into a specific column.

 

More Info:

-- Date is in MM/DD/YYYY format

-- Zap triggers when I add or update a row in that spreadsheet

-- All dates are within 1 month

-- Data being pulled from a Google sheet spreadsheet

 

How do I fix this error?

5 replies

Troy Tessalone
Userlevel 7
Badge +14

Hi @Strigen 

Check your Zap Runs history to see the DATA IN/OUT for each Zap step to help you troubleshoot.

https://zapier.com/app/history/

 

The error indicates the mapped value was missing (empty/blank/null).

 

Can you post a screenshot with how your Zap trigger step is configured?

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
S

Hi @Troy Tessalone ,

Thank you for your reply! I’m triggering when there’s a new or updated row in Google Sheets. More specifically, I’m asking Zapier to trigger when I input something in the “Zapier Type” column (which has input values of “Offer Follow-Up” or “Never answered/ Never visited”). This particular Zap checks further down the chain for “Never answered/ Never visited” specifically and sends a text message on the “Delay Until” date. There’s a sister Zapier that sends a different text message for “Offer Follow-Up”.

 

I’m wondering if the issue is that I’m asking Zapier to trigger when there’s a new or updated input in the “Zapier Type” column but then delaying until the date listed in “Zapier Start Date”? Should I just make the trigger off of the “Zapier Start Date” to match trigger with the delay?

 

See below:

 

 

 

Troy Tessalone
Userlevel 7
Badge +14

@Strigen 

The Zap trigger being used is for a NEW or UPDATED row.

Meaning it will trigger on NEW rows, and UPDATED rows for the specified column.

Make sure to add a Filter as step 2 if you only want to trigger for UPDATED row, to check for the existing of certain field values that are used in the Zap action steps.

Help: https://help.zapier.com/hc/en-us/articles/21613239711117-Google-Sheets-triggers-unexpectedly-or-too-soon#h_01HFYF19HHEZQ29QJT4XDAT10A

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
S

@Troy Tessalone

 

Thanks Troy I will do that now. Do you have any advice as to my original question regarding Delay Until error?

 

 

Troy Tessalone
Userlevel 7
Badge +14

@Strigen 

Try these suggestions...

 

Check your Zap Runs history to see the DATA IN/OUT for each Zap step to help you troubleshoot.

https://zapier.com/app/history/

 

Make sure to add a Filter as step 2 if you only want to trigger for UPDATED row, to check for the existing of certain field values that are used in the Zap action steps.

Help: https://help.zapier.com/hc/en-us/articles/21613239711117-Google-Sheets-triggers-unexpectedly-or-too-soon#h_01HFYF19HHEZQ29QJT4XDAT10A

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor

Reply


Terms & Conditions