Boardfeed

Import guide

Import Google Sheets into monday.com on a schedule

A shared Google Sheet is the fastest thing a team can agree on, and the least reliable thing to import by hand: someone edits a cell, and the board is wrong until a person notices.

Boardfeed reads a Google Sheet on a schedule and pushes the result into a monday.com board — updating existing items by key instead of rebuilding the board from scratch every time.

Doing it by hand, every time

  1. Remember to download the sheet as CSV.
  2. Upload it through the board’s import and remap the columns.
  3. Ask around for who changed the header row last week.
  4. Re-sort the board because the import appended everything at the bottom.

The scheduled route

  1. Connect the sheet either as a published CSV link or by sharing it with a service account address. Both are read-only access to the sheet.
  2. Name the tab and the header row; Boardfeed reads the range that follows.
  3. Choose the key column and the schedule, then let it run.
  4. The run preview shows exactly what will change on the board before anything is written.

Field mapping notes for Google Sheets

This is the part that decides whether an import works on the first try. Everything below is handled in the mapping step, before a run is scheduled.

  • Published CSV link: File → Share → Publish to web gives a URL that always returns the current values, so re-publishing after a structural change is not needed. The link exposes the sheet to anyone who has it — share a dedicated sheet, not the whole Drive.
  • Service account: share the sheet with the service account address and keep the file private. This is the better choice for anything customer-related.
  • Header row: the first non-empty row is used as the header. Blank spacer columns and merged title rows above the data should be avoided.
  • Formatted values: Boardfeed reads the displayed value, so a date column shows the date the sheet renders, not the serial number behind it.
  • Cell formulas: values are read as the sheet calculates them; a cell referencing an external spreadsheet that has not loaded can come through empty.

Google Sheets import questions

Is the Google Sheet read-only access?
Yes. Boardfeed only reads the sheet. Publishing a CSV link or sharing with a service account grants read access, never write access.
How quickly do sheet changes reach the board?
At the next scheduled run. Hourly is the shortest standard interval; a cron schedule can run more often if the board needs it.
What happens when a row is deleted from the sheet?
Boardfeed does not delete items as a side effect of an import. Deleting is left to you — an importer that removes items because a row disappeared from a spreadsheet is a liability, not a feature.

Other sources