Schedule a monday.com Export to Google Sheets

How the schedule works

Each saved export has a refresh setting: manual, hourly, daily or weekly. When any export in a spreadsheet is scheduled, the add-on installs one hourly Apps Script trigger for that spreadsheet. On each tick it checks which saved exports are due and queues them. When none are scheduled the trigger is removed.

Daily and weekly schedules catch up if a tick is late. If the trigger runs after the target hour, the export still runs that day rather than waiting for the next one.

Step by step

1. Open Extensions › monday.com Exporter › Open exporter and make sure your token is connected. See exporting a board.
2. Create or edit a saved export for the board.
3. Set the refresh to hourly, daily or weekly. Scheduled refresh needs the Pro plan; the Free plan keeps manual refresh.
4. Save. The first scheduled run happens at the next hourly tick that is due.

What a scheduled run does

A scheduled refresh replaces the destination tab with the current state of the board, the same as a manual run. Large boards that do not finish inside one Apps Script execution are saved and resumed on the next tick. If monday reports an expired page cursor, the run restarts from the first page so the tab does not mix old and new rows.

The run is serialised against manual runs in the same spreadsheet, so clicking Run while a scheduled refresh is in progress does not interleave writes.

Troubleshooting

The sheet did not refresh at the exact hour

Apps Script time-based triggers fire within an hour window rather than on the minute, and the add-on dispatches on that hourly tick. Do not rely on minute precision.

A scheduled run stopped

The token is stored per user. If the person who set up the schedule rotated their monday.com token or lost access to the board, the run fails until the token is reconnected from the sidebar.

My formulas disappeared

The destination tab is replaced on every refresh. Build charts and formulas on a separate tab that references the export tab.

Related guides

See exporting monday.com subitems to Google Sheets for including subitems in a scheduled export.

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.