Export a monday.com Board to Google Sheets

What you need

• A monday.com account and a personal API token with read access to the board.
• A Google account with edit access to the destination spreadsheet.
• The monday.com Exporter add-on, installed from the Google Workspace Marketplace.

Step by step

1. Open the spreadsheet and choose Extensions › monday.com Exporter › Open exporter.
2. Click Connect to monday.com and paste your personal API token. In monday.com the token is under your profile picture, then Developers, then API token. The token is stored per user in your Google account and is never written into the spreadsheet.
3. Add a saved export and pick the board. Subitem boards are hidden from the picker because their items come through the parent board.
4. Choose the columns to include, or take every column.
5. Run the export. The add-on writes the board into its tab, one row per item, with a header row built from the column titles.

What lands in the sheet

Each column value is converted to something a spreadsheet can use: text and status labels as text, numbers as numbers, checkboxes as booleans, and people columns as names. If a people cell would otherwise be empty, the add-on looks the names up from the ids in monday's data, one batched request per page of items. A team assignment is written with the team name when monday supplies one. A deleted user is left blank rather than failing the export.

Any text that starts with a formula character is written as plain text, so a board value like =SUM(A1) cannot execute in your sheet.

Large boards

The add-on pages through monday's API and saves its place, so a big board that does not finish inside one Apps Script run resumes where it stopped. monday's page cursors expire after 60 minutes. If one expires mid-run, the export restarts cleanly from the first page, so the tab never ends up with duplicated partial output.

Troubleshooting

The token is rejected

The add-on validates the token before storing it. Confirm you copied the personal API token in full and that your monday.com user can see the board.

A board is missing from the picker

Only boards your token can read are listed. Subitem boards are excluded on purpose, since subitems are exported through their parent board.

The tab changed after a refresh

Every refresh replaces the destination tab. Keep formulas, pivots and charts on a separate tab that reads from the export.

Related guides

To get subitems as their own rows, see exporting monday.com subitems to Google Sheets. To keep the sheet current without clicking, see scheduling a monday.com export to Google Sheets.

I'm the developer of monday.com Exporter, so weigh this guide accordingly. monday.com and Google Sheets™ are trademarks of their respective owners. This add-on is independent and is not affiliated with or endorsed by either.