Google Sheets

Google Sheets is a connector: it links a MeDo app to one Google account, so the app can read selected cell ranges, look up a row, append entries, create a spreadsheet, and save reviewed cell changes. The app works with the spreadsheet you point it at, not with the whole Drive.

#What you can build

• An operations dashboard. Show the headers and rows of a chosen range with a manual refresh control.
• A data-entry form. Preview a new row before appending it to a selected range.
• A record lookup page. Enter an exact reference value and show the matching row.
• A spreadsheet editor. Select a bounded range, review the cell changes, and confirm before saving.

Google Sheets fits when the data already lives in a spreadsheet and the app should be a better front end for it — trackers, rosters, price lists, simple inventories. It is not a database migration tool; ranges are bounded and formulas are not executed, see Limits.

#Build examples

Copy one of these into the prompt box. The first one is the smallest useful starting point.

Use @Google Sheets to build a private operations dashboard from a spreadsheet I choose, showing the selected sheet's headers and rows with a manual refresh button.

Use @Google Sheets to build a data-entry form that previews a new row before appending it to a selected spreadsheet range.

Use @Google Sheets to build a private record lookup page where I can enter an exact reference value and view the matching spreadsheet row.

Use @Google Sheets to build a private spreadsheet editor where I can select a bounded range, review cell changes, and confirm before saving them.

#Prepare and connect

You need a Google account that can already open the spreadsheet the app should use, plus the spreadsheet link or ID.

1. Open Skills & Connectors in the sidebar and search for Google Sheets.
2. Open the card and click Connect.
3. Sign in to the Google account and approve the access MeDo asks for.
4. The button changes to Connected.

Then tell MeDo which spreadsheet to use. Pasting the sheet's link or ID into the prompt is the quickest way; the app should show the returned sheet name and headers so you can confirm it picked the right file.

If you start building before connecting, MeDo shows a Google Sheets connection button under its reply. You can connect there instead.

#Use it in your app

• The app uses your connected account, not each visitor's Google account. Everyone who opens the dashboard sees the same spreadsheet. Keep private rows and editing controls behind your app's own sign-in and limited to the intended people.
• Name the range. "The Orders sheet, columns A to F" produces a bounded, predictable app; "my spreadsheet" does not.
• One range, one job. A dashboard reading a price list and a form appending to a log are two ranges — say so, and the app will keep them apart.
• Reads refresh on demand. There is no live sync with the spreadsheet. Add a refresh control rather than expecting changes to appear by themselves.
• Writes are confirmed first. MeDo previews the new row or the changed cells before saving.
• App-owned data stays in the app. Notes, statuses, and audit fields that are not part of the sheet belong in your app's own tables.

#Limits and troubleshooting

"Connection required" appears in the app. Ask the app owner to open the connector card and click Connect, then reload.

The dashboard shows the wrong sheet. Confirm the link or ID in the prompt, then ask MeDo to re-read the spreadsheet and show its title and headers.

A row lookup finds nothing. Lookup matches exact text inside the chosen range. Check spelling and make sure the reference value sits inside that range.

An update did not land where expected. Writes are not retried automatically. Open the spreadsheet, confirm what actually changed, and only then repeat the edit.

Clearing a range asks for confirmation. Clearing removes cell contents. MeDo asks for confirmation first because the change is destructive.

#Related

• Connector catalog — the other connectors and what they are for.
• Skills & Connectors — how Skills are called, priced, and limited.
• Managing access & roles — restrict who can read and change connected data.