Question

How to send summary reports at the end of the day from sheets via Zapier.

  • 5 December 2023
  • 3 replies
  • 58 views

"I would like to receive a daily report containing the new information added to my Google Sheet. For instance, if there are new sales entries made today, I want a summary of the sales information by the end of the day to my mail. How can I set this up in Zapier?"


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

Userlevel 7
Badge +14

Hi @Laharika 

Good question.

That depends on how your GSheet is configured and how data is being added to the GSheet.

Depends on which email app is being used and the full email template to send.

Can you elaborate?

 

This is the format of the sheet. Information directly added by the other zap.

I want every day summary reports from google sheets at the end of the day to my Gmail. The format of the report should be a table. Can you please guide me in creating a zap.

 

Userlevel 7
Badge +14

@Laharika 

Here’s my suggestion...

Use Airtable instead of GSheets.

Follow this article to create a digest email:

https://support.airtable.com/docs/how-to-create-email-digests-with-automations