Good morning! I’m looking for help bringing in spreadsheet rows to a daily email. I have a google form and I’d like a daily email to be sent out with the responses from that day. I have everything working except for the step that concatenates all the responses in an email. Or even just a step that would count the new rows and put that number in the email would work. Can anyone help? I’ve tried to research it but I only get information on sending emails on a new row- I definitely don’t want an email every time a row is added or updated.
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
Userlevel 7
+12
- Zapier Staff
- 3731 replies
-
11 June 2020
Hi
It sounds like you could do this using Digest by Zapier.
You’d need two Zaps - one to add all of the new rows to the Digest, and one to release the digest and add it to an email.
Zap 1
- New Row in Google Sheets
- Append Entry and Schedule Digest (in this case leave the schedule set to manual)
Zap 2
- Schedule (set a time that you want the Zap to release the information in the Digest
- Release existing digest
- Send Email (add the information from the digest to the email)
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.