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.

Question

Delay send more than 30 days - pull emails from Google Sheets

  • 17 February 2024
  • 3 replies
  • 13 views
T

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

 

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

3 replies

Troy Tessalone
Userlevel 7
Badge +14

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.)

 

 

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

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

Troy Tessalone
Userlevel 7
Badge +14

@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

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