Hi All,
I currently have a Google Sheet that automatically clears the information within it, and then re-populates with new data on the 1st of each month.
Using Zapier I’ve configured it to email me whenever a new row is added or updated which is working but my problem is that it emails me each single row that’s been added/updated in an individual email…
How do I configure this so all rows are contained within a singular email?
+14
Hi
Try using this Zap action: GSheets - Lookup Rows
You will need a common value to use as the lookup key in a column.
The trigger would be on a Schedule: https://zapier.com/apps/schedule/help
+14
Another approach is to use a Digest: https://zapier.com/apps/digest/help
Hi
Try using this Zap action: GSheets - Lookup Rows
You will need a common value to use as the lookup key in a column.
The trigger would be on a Schedule: https://zapier.com/apps/schedule/help
Thanks for the replies Troy, very much appreciated, can you recommend what I should be using for the Body of my email (I’m going the schedule route as opposed to Digest)?
I can only seem to select the rows as Columns? Which means the data isn’t really usable for the recipient when emailed as it displays all contents of Column A, then B, ect?
+14
Help article about using line items:
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
