Want to Use Google Sheet which can send the emails once the data is captured automatically
Dear Forum,
I have never used Google Sheets till now, but I was made aware of the amazing possibilities that can be attained while using the same, I use excel files but this being more dynamic as its on the Cloud will be more useful if it could achieve some things more that I intend to envisage in my file.
I send a particular file to each Sales Region so that they can populate the information of how much business was done in that Region which is divided into number of Locations/Cities, now each Region is termed as a "Branch" in our organisation and each Branch has several different Locations, so in a Region there are several different people who take care of this location and hence the information has to be entered by Multiple People, in the present context where I send them Excel files they are sent back to me with only few locations filling their details whereas the expectation is to have the entire information for the Region duly complete then the file sent back to me...
However, the sales team have to be continuously reminded, so a lot of to and fro emails take place and a lot of time is invested for this simple task..
I want to employ Google Sheets in such a way that once the file is sent then each person can fill their details and then till the time information is not complete they keep on getting Automatic Emails reminding them that this work is still pending..I would like to set a Time-Frame and then once the links is shared the Count-Down Begins.
Is this possible...and how to achieve the same, would also appreciate if some informative stuff or links are shared.
Warm Regards
e4excel
Bookmarks