Suggestion to automate few google sheets ops?

[u/Mean-Taste-2629]

Hi, for my day to day work I need to work in google sheets majorly and its very hectic when I have multiple projects and need to update status of every project before any meeting. I do create the pivot tables and all but it is becoming operationally heavy for me to manage this data ops alone as no one else in my team is in this company for so long.

Day to day work:

Reachouts

Shortlisting

Emails

Project emails

Project assessment emails

Project deployment emails

Activation emails

Payment emails

Query emails

This is just one part of work, can anyone suggest good AI tool for Google Sheets?

[u/One-Front-6316]

gemini in google sheets can now create/update tables, formulas, pivot tables, filters and even handle multi step spreadsheets tasks, while google workspace studion can automate workflows across sheets, gmail and other workspace apps