You can use a workflow accordingly :
- Step 1: List all the items on the board and apply a filter to include only the data from the last month.
- Step 2: Add a row to Google Sheets by mapping values from the Monday module.
You can set up schedule this scenario every month.
Please note that if there are many items in Monday, it will take a corresponding number of operations to add each row into Google Sheets. To overcome this, we have a custom app where we can add multiple rows in a single operation. You may check our Google Sheet (Batch) Custom App.
Regards,
Msquare Automation - Gold Partner of Make
Visit us here | Youtube Channel