The Google Sheets widget shows a Google Sheet inside a dashboard. Think of a budget spreadsheet open in a panel beside the contract values it feeds. You publish the sheet to the web in Google, then paste the published link into the widget.

Here is the test: is the content a spreadsheet that lives in Google Sheets and should be read beside the records? If yes, add this widget. To move numbers into a SmartSuite table, use the Google Sheets automation action instead.

Example: a Vendor Management solution. Finance keeps the annual security budget in a Google Sheet. On the Vendor risk overview dashboard, a Google Sheets widget titled Security budget shows it beside the register's Annual Contract Value column. Finance updates the sheet in Google, and the widget shows the new numbers on the next load.

The Vendor risk overview in View mode with the budget sheet in a Google Sheets widget beside the register.

The widget lands at the top left of the dashboard as a small block, with its title above the content. Hover over it and drag the pill on its right edge or its bottom edge to resize it; the width snaps to the dashboard's four-column grid. The dashboard saves on its own. There is no Save button.

The settings sit on the right of the window under two headings, Heading and Settings. Each collapses with the chevron at its right. The window's header holds a gear that shows or hides the settings, a three-dot More Options menu (Highlight Color, Duplicate Widget and Collapsed by Default) and an X. Close with the X after a change and the window asks whether you want to exit without saving. Its buttons are Exit Without Saving and Save Changes.

Title is the text shown above the widget on the dashboard. It is prefilled with the widget's name, so change it to what the content is, such as Security budget. Description is a switch, off to start. Turn it on and a text box appears with a small toolbar: bold, italic, underline, text color, highlight, link, bullet list and numbered list. Two tabs set where the description shows. As A Tooltip puts it behind an info icon next to the title. Below The Title shows it under the title, and is selected to start.

The published link to the sheet, pasted into the box marked Paste URL. The helper under it reads "Paste a link to a Google Sheet in the text box above." Paste the full link. The widget frames it exactly as you paste it. It ends in pubhtml; a normal share link does not display. Typing something that is not a link showed no message in the product read; the preview simply stays empty.

The Google Sheets window: the preview on the left, Heading and the Embed URL box holding a link that ends in pubhtml on the right.

The widget needs the published link, not the share link. These steps happen in Google, not in SmartSuite.

A published sheet is visible to anyone with the link. Publish only what every member of the dashboard may see.

Solution Managers and members with Full Access add, change and remove widgets on a public dashboard. The owner of a private dashboard does the same on it. Every member who can open the dashboard sees the widget. What they see inside it is a published sheet, so anyone with the link can see it, inside SmartSuite or outside it. A dashboard shared by link shows everything on it to anyone with the link, this widget included. See Dashboard Settings and Public Dashboard Sharing.

In View mode the widget shows its title and the published sheet as Google renders it, inside a frame on the dashboard. Members scroll inside the frame and switch tabs when the whole workbook is published. The widget is read-only: a published sheet cannot be edited from the dashboard. Hover over the widget and a full screen icon and a three-dot menu appear at its top right.

The live mobile guide lists the Google Sheets widget as supported in the SmartSuite mobile app; see Mobile Dashboard Widgets: Supported Features and Limitations Guide.

In Edit mode, hover over the widget. A strip appears with a drag handle (Drag Widget), Move Up, Move Down, Edit and a three-dot More Options menu. Select Edit to reopen the window, change the link or the title and select Save Changes. Drag the handle to move the widget; a dashed placeholder shows where it will land. Duplicating and deleting are in the More Options menu, and the delete prompt names the widget; see Managing Widgets.

Last verified 30 Oct 2026.