Creating a Tally of task per in google sheet

Hello guys, I don’t know a single thing about API, but i need your help in this one, thank you!
tally
I’ve created a google sheet to monitor How many tasks we’re assigning per Day and per Project. if we could able to populate and update the sheet automatically, just the numbers.

Thank you very much!