Shwidget
Show Sheets data in a widget!
Free · In-App Purchases · Designed for iPad. Not verified for macOS.
Track your Google Sheets values with Shwidget on your Home Screen, Lock Screen, and Apple Watch, with widgets, watch face complications, and automatic updates.
Keep your important Google Sheets values on your Home Screen, Lock Screen, or Apple Watch.
Shwidget displays values from your Google Sheets cells in widgets and Apple Watch complications. Follow KPIs, sales figures, project progress, or any other values without opening the Sheets app.
KEY FEATURES
• Home Screen widgets in multiple sizes.
• Lock Screen widgets for a quick glance at your data.
• Apple Watch complications to display values on your watch face.
• Apple Watch Smart Stack widgets.
• Automatic refreshes managed by iOS and watchOS.
• Optional titles to make your values easy to identify.
• No Shwidget account required.
Refresh timing is controlled by iOS and watchOS. Updates are periodic, and changes in your spreadsheet may not appear immediately.
GETTING STARTED
1. Open your Google spreadsheet and copy its spreadsheet ID from the URL. This is the text between “/d/” and the next slash. Keep all characters, including hyphens and underscores.
2. In the spreadsheet’s sharing settings, set General access to “Anyone with the link” and the role to “Viewer”.
3. Enter the spreadsheet ID and the cell references you want to display, such as D1 or D2, in Shwidget. Add optional titles for your values.
4. Add a Shwidget widget to your Home Screen or Lock Screen, or use Shwidget on your Apple Watch.
FINDING YOUR SPREADSHEET ID
For this URL:
https://docs.google.com/spreadsheets/d/1CMvaCWBAsrAftZjT5nXlntTUsnmkkZDlxMkXhAd_sBs/
The spreadsheet ID is:
1CMvaCWBAsrAftZjT5nXlntTUsnmkkZDlxMkXhAd_sBs
Paste only the ID into Shwidget, not the entire URL.
TROUBLESHOOTING
If your widget displays “ERROR empty cell?”, check that:
• The selected cell contains a value.
• The spreadsheet is shared with “Anyone with the link” as a Viewer.
• The spreadsheet ID and cell reference are correct.
SHARING AND SENSITIVE DATA
Anyone with your spreadsheet’s link can view it when this sharing setting is enabled. Avoid using it for spreadsheets containing confidential information.
To share only selected values, create a separate spreadsheet and use Google Sheets’ IMPORTRANGE function to bring in the cells you want to display. Use that separate spreadsheet with Shwidget and enable link sharing only for that spreadsheet.
TRY AN EXAMPLE
Use this spreadsheet ID:
1CMvaCWBAsrAftZjT5nXlntTUsnmkkZDlxMkXhAd_sBs
Try individual cell references such as D1, D2, D3, or E1 through E7. Open the example spreadsheet to compare the values with your widget.
FREE AND PRO
The free version lets you display one data field per widget.
The KPI Lover subscription unlocks additional rows per widget and lets you remove the Shwidget logo from Home Screen widgets and the branding text from Lock Screen widgets.
Questions or feedback? Contact me at mikko_a_appsipaja.fi.
Cheers,
Mikko
Terms of Use — Apple’s Standard EULA:
https://www.apple.com/legal/internet-services/itunes/dev/stdeula/
Ratings & Reviews
- This app has not received enough ratings or reviews to display an overview.
Support for Apple Watch Complications and Stacks.
The developer, Appsipaja Oy, indicated that the app’s privacy practices may include handling of data as described below. For more information, see the developer’s privacy policy .
Data Not Linked to You
The following data may be collected but it is not linked to your identity:
- Identifiers
- Diagnostics
Accessibility
The developer has not yet indicated which accessibility features this app supports. Learn More
Information
- Provider
- Appsipaja Oy
- Size
- 9.3 MB
- Category
- Utilities
- Compatibility
Requires iOS 16.1 or later.
- iPhone
Requires iOS 16.1 or later. - iPad
Requires iPadOS 16.1 or later. - Mac
Requires macOS 13.0 or later and a Mac with Apple M1 chip or later. - Apple Vision
Requires visionOS 1.0 or later. - Apple Watch
Requires watchOS 10.0 or later.
- iPhone
- Languages
- English
- Age Rating
4+
- 4+
- In-App Purchases
Yes
- Yearly payment Rp 299ribu
- Monthly payment Rp 49ribu
- Copyright
- © Appsipaja Oy
