Our team is using Trello for personal and team task management. Once a task is done we move this task to a specific list which allows us a good overview of the tasks we have finished everyweek.
Then
Add row to spreadsheet
This action will add a single row to the bottom of the first worksheet of a spreadsheet you specify. Note: a new spreadsheet is created after 2000 rows.
Explore more great ways to automate Google Sheets and Trello