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.
How do I send a daily email summarizing new stock updates from a Google Sheet?
Hi
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.
Thanks for your response. I will PM you a sample just now
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.