AI Agent for Task Management: Google Sheets Issues and Solutions
Marvin A. Hey I'm back with 2 questions (thanks for bearing with me my man. So what I have done is I've set up An AI agent that basically looks at a Google sheet will send email asking for updates from all the task owners and then once they've replied it formulates an agenda for a daily call that we have and it also sort of tries to predict if we should have a call or not. My Google sheet is set up in a way where I have daily tracking available for all tasks that I have and there is like a daily date column. Problems I'm facing:
- 1.
When I select update a column in Google sheets, the problem is it is overwriting my previous day's entry?
- 2.
The second problem is I want my timer to trigger the email at a specific time everyday which is 11:30 am IST
Appending ss for the flow.
- 1.
SS 1 overall flow
- 2.
SS 2 update column AI prompt
- 3.
SS 3 timer - will this work? Why can't I set a schedule to trigger this at 11:30 am IST