ysskrishna logoysskrishna

Chapter 6 of 6 · 3 min

Recipe: one table, three destinations (Sheets → README → Teams)

Keep the source of truth in Sheets, publish it as Markdown to a README and as rich text to Teams, and update both in two minutes.

A common setup: a status table (releases, owners, versions) lives in a sheet everyone edits, and copies of it live in a README and a Teams channel. Copies drift. This recipe makes refreshing them a two-minute job.

The sheet

componentownerversionstatus
apiAsha2.4.1stable
webRaj3.0.0-rc1rc
sheets-add-onsLi1.8.0stable

Sample data. Keep it on its own tab named README table, one header row, no merged cells.

Step 1: Markdown for the README

  1. Select the table including headers.
  2. Table Converter → Export → Markdown → Copy.
  3. In README.md, put the table between two marker comments so you always replace the same block:
| component | owner | version | status |
| --- | --- | --- | --- |
| api | Asha | 2.4.1 | stable |
| web | Raj | 3.0.0-rc1 | rc |
| sheets-add-ons | Li | 1.8.0 | stable |
  1. Commit. GitHub renders it as a table.

Step 2: Teams

Teams does not render a pasted Markdown table as a table reliably. Two options:

  • Export → HTML → Copy, then paste into a tool that accepts HTML, or
  • Paste the Markdown into Markdown to Teams, click copy there, and paste into the Teams message. The site's converter outputs Teams-ready rich text including tables.

If an agent posts the update through an API, the Markdown Convert MCP server's markdown_to_teams tool produces HTML for Graph's contentType: html.

Step 3: updating

When the sheet changes:

  1. Re-export Markdown → replace the block between the markers → commit.
  2. Re-convert for Teams → post the update in the same thread.

A short "last updated" cell in the sheet, included in the export, tells readers how fresh the copy is.

Checklist

  • One header row, no merges, no blank rows
  • Headers named for the destination
  • Marker comments around the README table
  • Teams version converted, not pasted raw
  • "Last updated" included

Course recap

Import: pick the format, paste, choose current selection or a new sheet, Import. Export: select with headers, pick the format, Copy or Export. Most problems come from the sheet's shape (merges, blank rows, header names), so fix the shape first.

Keeping the README in sync

The sheet is the source of truth; the README copy goes stale the moment someone edits the sheet. Two habits help:

  1. Put a line under the table in the README: "Source: , exported ". Readers know how fresh it is, and you know where to update it.
  2. Re-export after every change that matters and replace the whole table rather than editing single cells in Markdown. Hand-edited Markdown tables drift from the sheet and eventually disagree with it.
DestinationFormat to exportNotes
GitHub README or docsMarkdownRenders as a table on GitHub
Teams or Slack messageMarkdownCheck the preview; very wide tables wrap badly on mobile
A test fixture or seed fileJSONKeys come from the header row
Another spreadsheet or toolCSVThe most widely accepted format

Quick check

  1. Why put marker comments around the README table?So each update replaces exactly the same block.

  2. Why not paste the Markdown table straight into Teams?Teams doesn't reliably render Markdown tables; convert to rich text or HTML first.

  3. What keeps all copies honest?A single source of truth in the sheet, plus a "last updated" value in every export.

Continue exploring

ProductGoogle WorkspaceGoogle Sheets Table Converter

Google Sheets Table Converter

Pipe tables, JSON, CSV, or HTML in and out of Sheets, without leaving the grid you are already in.
Google Sheets Table Converter
Markdown & Docs
Text & Data Conversion
Google Workspace Add-ons
BlogCover image for Import JSON, Markdown, HTML & CSV Tables into Google Sheets Without Breaking Data

Import JSON, Markdown, HTML & CSV Tables into Google Sheets Without Breaking Data

Google Sheets Table Converter
Google Workspace Add-ons
+3
2 min read
BlogCover image for Convert Google Sheets to Markdown, HTML, JSON & CSV Without Breaking Tables

Convert Google Sheets to Markdown, HTML, JSON & CSV Without Breaking Tables

Google Sheets Table Converter
Google Workspace Add-ons
+3
2 min read
ProductGoogle WorkspaceGoogle Sheets Tab Manager

Google Sheets Tab Manager

Your workbook outgrew the tab bar. Clean it up in batches.
Google Sheets Tab Manager
Google Workspace Add-ons
Google Sheets
Google Apps Script
CourseCover image for Sheets Tab Manager: Delete, Hide, Rename, Colour and Sort Tabs in Bulk

Sheets Tab Manager: Delete, Hide, Rename, Colour and Sort Tabs in Bulk

Delete multiple tabs in Google Sheets at once, hide and unhide in bulk, rename with find and replace, colour and sort tabs A–Z with the free Sheets Tab Manager.

Google Sheets Tab Manager
Google Sheets
+1

6 chapters · 24 min

ProductGoogle WorkspaceGoogle Sheets Merge Tools

Google Sheets Merge Tools

Repeatable merges in Google Sheets, without the misclick marathon.
Google Sheets Merge Tools
Google Workspace Add-ons
Google Sheets
Google Apps Script