Thanks for the video, that's very impressive But I have one question. In my situation, I'm working on a sheet that has 100 rows, and I want everyday it will sends 5 rows to my email continuously (the content in the next day can't be the same from the previous day) So how do I make this happen? Is there a way to do this? Thank you so much
I searched high and low for this fix and then I finally found it. Thanks for making this video!
Fantastic!
Thanks for the video, that's very impressive
But I have one question. In my situation, I'm working on a sheet that has 100 rows, and I want everyday it will sends 5 rows to my email continuously (the content in the next day can't be the same from the previous day)
So how do I make this happen? Is there a way to do this? Thank you so much
Add a column (sent) add sent when emailed, and search for next 5 not yet sent.
@@BetterSheets thanks for the solution, that works fine now xD
What about sending a series of data in a row?
I want to send 5 cells across row 1, then 2, then 3 etc.
Is that possible?
Anything is possible
How about a follow up where you can send a random cell from a list
Just add rand() to the mix. Randomize the row in a getRange.
Legend,!
What if I want to attach a whole spreadsheet to the email what would I use to input in this function?
Maybe pdf?
how to get full data from range a1:z
GetValues()