Skip to content
ClickRuntime

Connect Google Sheets to monday.com

Google Sheets is where many teams collect lists and build reports, while monday.com is where the work is tracked. Connecting the two lets you add tasks from a sheet, keep a daily history of your board for reporting, and log every approval for audits.
Add to ChatGPTAdd to Claude
Works inChatGPTClaudeClaude CodeCursorCodexVS CodeGemini CLIZedopencodeAny MCP client

Ideas

What you can do with Google Sheets and monday.com

Create items from sheet rows and keep a running record of your board in Sheets. These are ready-made starting points. Anything else you can describe works too.
Every 15 minutes

Create monday.com items from new sheet rows

Tasks you add to a Google Sheet show up on your monday.com board within 15 minutes.

See how it works
Daily

Log a daily snapshot of your monday.com board

Every evening each item's status on your monday.com board is saved to a sheet, building a history for reporting.

See how it works
The moment it happens

Keep an audit log of monday.com approvals in Sheets

Every approval or status change on your monday.com board is recorded in a Google Sheet, and rejections are flagged in Slack.

See how it works
Hourly

Export a monday.com board to Google Sheets hourly

Every hour, a Google Sheets tab is replaced with the current items of a monday.com board, one row per item and one column per board column.

See how it works
Every 5 minutes

Update monday.com item status from Google Sheets

When a Status cell changes in a Google Sheet, the matching monday.com item is set to the same status within 5 minutes.

See how it works
The moment it happens

Log completed monday.com items to Google Sheets

Each time an item is set to Done on a monday.com board, a row with the owner, created date, finish time and days open is added to a Google Sheet.

See how it works Your own logic

Any other automation you can describe in words

Your own rules, schedule and AI steps with Google Sheets and monday.com, plus any other app. Describe it and your assistant builds it.

See how to build your own

Build your own

Build any Google Sheets and monday.com automation you can describe

The ideas above are ready-made starting points, not a fixed list. Describe what should happen between Google Sheets and monday.com in your own words, with your conditions, other apps or an AI step, and your assistant writes it, tests it and runs it on ClickRuntime.

  • Your own rules

    Conditions, thresholds, filters and exceptions, written the way you'd explain them to a colleague.

  • Any number of apps

    One automation can read from one app and update several others. Over 248 apps are ready, and anything with an API works too.

  • AI where it helps

    Summaries, classification, extraction and drafts use ClickRuntime's built-in AI, with no extra key.

  • On a schedule or on each event

    Runs as often as every 5 minutes, or the moment an app sends an event, and keeps track of what it already handled.

For example, ask your assistant

Only create items for rows where "approved" is yes, and write the monday.com item ID back to the row so it is never added twice.

Each night, compare the sheet and the board and list any items whose status differs in a "mismatch" tab.

Use cases

Why people connect Google Sheets and monday.com

How the two apps work together

  • A check every few minutes finds new or edited rows in Google Sheets.
  • The script creates or updates monday.com items, filling columns such as status, date, person and numbers.
  • On a schedule, it reads boards and writes items and column values back to the sheet.

  • Ops teams importing work from forms

    Rows added to a sheet by a form become monday.com items. Intake goes straight to the board.

  • Finance teams reporting on projects

    Item budgets and statuses are copied to a sheet for charts and pivot tables. Reporting uses familiar tools.

  • Managers keeping history

    A daily snapshot shows how items moved through statuses. Trends over weeks are visible.

  • Teams bulk updating items

    Changes made in a sheet column update the matching monday.com items. Large edits are faster.

More apps

Google Sheets, monday.com and other apps in one automation

An automation isn't limited to two apps. Add the next step in another app and it runs as part of the same automation.

New item alerts

When a sheet row creates a monday.com item, post the item link to #ops.

Form to board

When someone submits my Google Form, add the answers to my sheet and create an item on my monday.com Intake board.

Weekly budget email

Every Monday, copy budget columns from monday.com to my sheet and email me projects that are over budget.

Setup

Connect Google Sheets and monday.com once

Every idea on this page uses the same two connections, so you set them up once. If one is missing, your assistant tells you and links to the right place.

Google Sheets

Spreadsheets

  1. In the ClickRuntime dashboard, open Connections and choose Google Sheets.
  2. Sign in with your Google account and allow access.
  3. Pick the spreadsheets the automation may use. It can't see any other file in your Drive.

monday.com

Project management

  1. In monday.com, click your profile picture and open Developers.
  2. Under API token, click Show and copy the token. Admins can also find it under Administration, Connections, Personal API token.
  3. In the ClickRuntime dashboard, open Connections & secrets and save the token as a secret for monday.com.

FAQ

Questions about connecting Google Sheets and monday.com

Will rows be added to monday.com twice?
No. Each row is marked with the new item's ID once it is created, and marked rows are skipped.
Which board columns can it fill?
Any columns you map from the sheet, such as owner, status, due date or text fields.
Can I build charts from the snapshots?
Yes. Daily snapshots build up in the sheet, ready for pivot tables and charts showing how work moved over time.
What do I need to connect monday.com?
A personal API token from your monday.com profile, saved in your ClickRuntime dashboard.
Can it update items when I edit the sheet?
Yes. If each row stores the item ID, edits to mapped columns update the item on the next check.
Does it handle subitems?
Yes. Subitems can be created or read through the monday.com API.
How large a board can it copy?
The monday.com API returns items in pages, so the script can copy large boards over one or more runs.

Related pages

Keep exploring

Tell your assistant what Google Sheets and monday.com should do together

Free plan. No credit card.

Add to ChatGPTAdd to Claude