Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Question

How do I send a daily email summarizing new stock updates from a Google Sheet?

  • April 29, 2024
  • 4 replies
  • 136 views
N

I get an email every time a product goes in (or out) of stock on my website. I have managed to create a zap that takes info from the (gmail) email and creates a new row in a google sheet spreadsheet. 

Format of spreadsheet is:
Date, SKU, Product-name, Brnad, Supplier, Status (out of stock OR in stock).

The zap is working well and all stock movements are recorded. 

Now I want to create a daily summary email that lists all new rows from the spreadsheet and sends them in a single email. 

Completely lost trying to get it to work, if anyone can help it would be much appreciated.

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

4 replies

fiona819
Forum|alt.badge.img+3
  • fiona819
  • New
  • May 2, 2024

Hi @Ninja Hippo For your spreadsheet, does the “date” equate to the date that the zap added the new rows? 

N
  • Ninja HippoBeginner
  • Author
  • Beginner
  • May 2, 2024

Yes, the email is sent as soon as the product is marked in/out. I get the email within seconds, and then the zap adds the row to the spreadsheet.

fiona819
Forum|alt.badge.img+3
  • fiona819
  • New
  • May 7, 2024

@Ninja Hippo I think it’s possible if you have the updated date in the spreadsheet. But to come up with the email I think we need to do some simple JS code. Perhaps you can PM me just a few rows of sample data and then I’ll give you the script so you can append to the send email block in Zapier. 

N
  • Ninja HippoBeginner
  • Author
  • Beginner
  • May 7, 2024

@Ninja Hippo I think it’s possible if you have the updated date in the spreadsheet. But to come up with the email I think we need to do some simple JS code. Perhaps you can PM me just a few rows of sample data and then I’ll give you the script so you can append to the send email block in Zapier. 



Thanks for your response. I will PM you a sample just now

Terms & ConditionsAccessibility statement