Best answer

How to setup delayed emails for Google Forms responses?

  • 15 October 2020
  • 8 replies
  • 347 views

Userlevel 1

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!

icon

Best answer by Troy Tessalone 15 October 2020, 01:58

View original

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

Userlevel 7
Badge +14

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

Userlevel 1

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! :)

Userlevel 7
Badge +14

Why not send each in real-time?

Userlevel 1

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.

Userlevel 7
Badge +14

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.

Userlevel 1

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.

Userlevel 7
Badge +14

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.

Userlevel 1

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