Hi,
I want to create an automation process where I have a sheet with many records. Some records are marked with a color. I want the automation to continue from the last color-marked record, send the next 15 records via email, and mark those records as well. The same process should repeat the next day.
Could you assist with this?
Identifying the color validations or any rule in google sheet is not returned in Make. You can do an alternate approach.
Create a column for checks. The rows that are colored, check those rows and then process from last checked row. Once the rows are processed, mark them checked.
Regards,
Msquare Automation - Platinum Partner of Make
@Msquare_Automation