Need a daily email to go out that reports all new rows in a Google Sheet for the day

I am able to connect Google Sheets and then generate an email with each new row that is added; however, is it possible to batch all new rows daily and basically send one email that includes all of the rows data?

Welcome to the Make community!

Yes, all you need to do is to set your “Watch New Rows” scenario to only run once per day/daily,

Then, you can Text Aggregate all the bundles from the “Watch New Rows” module to combine them into a single variable that you can include in your email.

Make sure you set a high bundle limit here so that ALL the new rows can be fetched and processed at the same time.

samliewrequest private consultation

Join the Make unofficial Discord server!

3 Likes

Thank you so much! This worked like a charm.

No problem, glad I could help!

1. If you have a new question in the future, please start a new thread. This makes it easier for others with the same problem to search for the answers to specific questions, and you are more likely to receive help since newer questions are monitored closely.

2. The Make Community guidelines encourages users to try to mark helpful replies as solutions to help keep the Community organized.

This marks the topic as solved, so that:

others can save time when catching up with the latest activity here, and

  • allows others to quickly jump to the solution if they come across the same problem

To do this, simply click the checkbox at the bottom of the post that answers your question:
Screenshot_2023-10-04_161049

3. Don’t forget to like and bookmark this topic so you can get back to it easily in future!

samliewrequest private consultation

Join the unofficial Make Discord server to chat with us!

I am trying to connect googlesheet to trigger gmail or any email

how are you doing? is it googlesheet direct to the email?