Plan Availability | All plan types |
Permissions | General Access: Users can view and interact with the widget. |
Related Reading |
What Is the Google Sheets Widget?
The Google Sheets Widget embeds a shared Google Sheet into your dashboard, giving teams a central location to view and work with live data. This feature is perfect for collaborative data-driven projects or tasks requiring real-time updates.
Settings
Settings
The Google Sheet Widget is easy to configure. Just follow the steps below:
Get the “Publish to web” URL
Open your Google Sheet.
Go to File → Share → Publish to the web → Link.
Example:Choose Entire document or a single sheet.
Note: “Entire document” publishes all tabs in the Google Sheet, while “Single sheet” publishes only the selected tab.
Make sure Web page is selected, then click Publish → OK.
Copy the full URL generated — it will end with
pubhtml.
Example:Note: Above link has been unpublished but here for illustrative purposes only.
Add it to SmartSuite
Click Add Widget to add it to your dashboard.
Paste the copied URL into the Embed URL field in the Google Sheet Widget.
Practical Scenarios and Use Cases
1. Departmental Collaboration
Scenario: The Sales team needs a centralized location to track their monthly performance metrics.
Solution: Embed the team's performance tracking Google Sheet into the dashboard to ensure everyone has real-time visibility.
2. Cross-Departmental Reporting
Scenario: Leadership wants to review a cross-functional report updated by multiple teams.
Solution: Add a shared Google Sheet to the executive dashboard for seamless, live updates.
3. Project Data Management
Scenario: The Operations team collaborates on budget planning using a shared spreadsheet.
Solution: Use the Google Sheets Widget to embed their budget file into the project management dashboard for easy access.