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.

I have done a ton of searching and still can’t find answer to my question, so I am trying here. Use case - partners are filling out a SurveyMonkey form indicating which of our 11 webinars they want to partner on. I have the Zap set up to filter based on month chosen and several things happen:

  1. information gets sent to a specific worksheet in Google sheets
  2. A task is created in Wrike 
  3. Using Webhooks the email is sent to Mixmax to be added to a sequence that is sent at a specific date in the future. See “March Webinar” below. 

March works fine becuase with Zapier Delay it is within the 31 days. However, for April - November delay doesn’t work. I have tried doing the Google Event delay but cannot figure out how to tell to pull the email address from the Google Sheet. 

March Webinar Path that works
April Webinar Attempt that is not working

 

Hi @TriageC 

Try this…

Use Airtable instead of GSheets.

You won’t need Paths in the Zap, just send all the data to Airtable.

Airtable has Date fields: https://support.airtable.com/docs/date-and-time-field

Airtable has Views, which are segments of data that can be sorted, filtered, groups, show/hide fields, reorder fields, etc. https://support.airtable.com/docs/getting-started-with-airtable-views

The idea being that you create a View for each Webinar. (e.g. Date = Today and Field X = Y)

The Views would handle any delay logic.

Views can be used to trigger Airtable Automations or Zaps.

Airtable Automations have Run Script steps that allow for JavaScript for applicable plans. (e.g. POST request)

Airtable Automations have other native integrations that you may find useful. (e.g. Gmail, etc.)

 

 

Thanks so much for taking the time to respond! Unfortunately Airtable is not an option for us. 

@TriageC 

Explore using another Zap that triggers from a Schedule and finds matching GSheet rows then using the Looping app to process.

 

Schedule: https://zapier.com/apps/schedule/help

Looping: https://zapier.com/apps/looping/help

Terms & Conditions