Question reporting with Zapier. Can I automate a report of due and overdue tasks in into Google sheets

  • 26 May 2023
  • 1 reply

Userlevel 1

Hi we use quite extensively and would like to create an automated report.

So simply putting into a google sheet

items due within 7 days

Items due today

Items overdue.


I would like to pass the item, the person assigned task, date due into a google sheet so that I can create a daily report to ensure people are upto date without reviewing dozens of boards.


Is this possible


Kind regards

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

Userlevel 7
Badge +14

Hi @Magpie2000k 

Good question.

Look into using Monday Automation that send data to a Zapier Webhook.

Monday help article about webhooks:


Zap Steps

  1. Trigger: Webhook - Catch Hook
    1. Will provide the Webhook URL to use in the Monday Automation.
  2. Action: GSheet - Create Row


NOTE: You may need to add additional Zap steps to get all the necessary data from Monday before sending the data to the GSheet.