Create Daily Task Status Snapshots from Monday.com to Google Sheets — n8n Workflow

Low complexity▶️ Manual5 nodes🏷️ Project Managementby Robert Breen

Overview

This workflow pulls all tasks from your Monday.com board each day and logs them into a Google Sheet.
It creates a daily snapshot of your project’s progress and statuses for reporting, tracking, or analysis.

⚙️ Setup Instructions

1️⃣ Connect Monday.com API
In Monday.com → go to Admin → API
Copy your Personal API Token
Docs: Generate Monday API Token
In n8n → Credentials → New → Monday.com API → paste your token and save

2️⃣ Prepare Your Google Sheet
Copy this template to you

Nodes used

Google SheetsMonday.comCode

Workflow Preview

📋 Monday.com → Google Sheets Daily Task Stat
This workflow pulls all tasks from your Monday.com boar
It creates a daily snapshot of your p
1️⃣ Connect Monday.com API
1. In Monday.com → go to Admin → API
2. Copy your Personal API Token
- Docs: [Generate Monday API Token](https://develope
⚙️ Setup Instructions
1️⃣ Connect Monday.com API
1. In Monday.com → go to Admin → API
2. Copy your Personal API Token
- Docs: [Generate Monday API Token](https://develop
2️⃣ Prepare Your Google Sheet
- Copy this template to your own Google Drive: [Google
M
Map Fields
M
Merge2
Today's Date2
Daily Progress to Sheet1
Get many items2
5 nodes4 edges

How it Works

  1. 1

    Trigger

    The workflow starts with a manual trigger.

  2. 2

    Process

    Data flows through 5 nodes, connecting code, googlesheets, merge.

  3. 3

    Output

    The workflow completes its automation and delivers the result to the configured destination.

Node Details (5)

GO

Google Sheets

googleSheets

#1
MO

Monday.com

mondayCom

#2
CO

Code

code

#3

How to Import This Workflow

  1. 1Click Download JSON button on the right to save the workflow file.
  2. 2Open your n8n instance. Go to Workflows → New → Import from file.
  3. 3Select the downloaded create-daily-task-status-snapshots-from-mondaycom-to-google-sheets file and click Import.
  4. 4Set up credentials for each service node (API keys, OAuth, etc.).
  5. 5Click Test Workflow to verify everything works, then activate it.

Or paste directly in n8n → Import from JSON:

{ "name": "Create Daily Task Status Snapshots from Monday.com to Google Sheets", "nodes": [...], ...}

Integrations

codegooglesheetsmergemondaycomset

Get This Workflow

Download and import in one click

Download JSONView on n8n.io
Nodes5
Complexitylow
Triggermanual
CategoryProject Management

Created by

Robert Breen

Robert Breen

@rbreen

Tags

codegooglesheetsmergemondaycomset
⚡

New to n8n?

n8n is a free, open-source workflow automation tool. Self-host it or use the cloud version.

Get n8n Free →