Skip to main content
Best answer

How to setup delayed emails for Google Forms responses?

  • October 14, 2020
  • 8 replies
  • 401 views

Hi there,

I’d like to setup a scheduled time when emails (Gmail) are sent to a printer’s email address for each of the form responses (Google Forms) every day at a specific time. What is the best method to use for this with the Zapier?

Thank you!

Best answer by Troy Tessalone

Not sure if this will solve for your use case, but check out Digest: https://zapier.com/apps/digest/help

https://zapier.com/help/doc/how-get-started-digest-zapier

https://zapier.com/help/doc/what-digest

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

8 replies

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • Answer
  • October 14, 2020

  • Author
  • Beginner
  • October 15, 2020

Hi Troy,

 

Thank you for your suggestion. From what I understand, Digest can send out a summary of fields from the process, but my use case requires that each record (row of data) prints separately. I’m new to Zapier and would love any other suggestions I can look into using.

 

Thanks again for your help! :)


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • October 15, 2020

Why not send each in real-time?


  • Author
  • Beginner
  • October 15, 2020

I’m trying to send each to an ePrint service via diningorders@printer.com, but there is no queue. I’d like to somehow delay the time when the records are printed. Since they are for meal prep orders, breakfast will be printed at a certain time, lunch, and dinner at their own times so that the printed sheets are not lost if an order is placed the day/night before it’s meant to be prepared.


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • October 15, 2020

Try this then...Use a Delay > Delay Until.

You may have to get a bit more advanced and use a Code step first to determine the timestamp of when the Zap triggered then do an evaluation whether to delay until a designated time TODAY or TOMORROW.

This will achieve the effect of a queue.


  • Author
  • Beginner
  • October 15, 2020

Okay. I’ll give that a shot. Thank you.

I’m curious, is it possible to query the Google Spreadsheet for a specific date/time then email all the records and include a count of how many it prints (n out of  x)? 

 

Thank you.


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • October 15, 2020

You’d have to configure a GSheet tab that has some formulas (e.g. QUERY, FILTER) on it that takes an input that you pass in from the Zap and will return those 2 numbers.


  • Author
  • Beginner
  • October 15, 2020

Oh that gives me an idea. Thank you. Let me try these suggestions out and hopefully it does the trick! :)