Shwidget vs SheetWidget

Do you have a KPI or important value in Google Sheets that updates automatically, and you want to monitor it without constantly opening the Sheets app? Meet Shwidget, your solution! Shwidget is an iOS app that lets you display any Google Sheets cell value directly in a widget on your device. It automatically updates via iOS’s widget system, meaning you can keep tabs on your important data right from your Home or Lock Screen, without the need to check the Sheets app manually. Key Features: * Automatic updates using iOS’s widget update system. * Home Screen widgets in various sizes, as well as Lock Screen widgets. * Privacy-friendly: No account required, and your data never leaves your device. SETTING IT UP Getting started is easy! All you need is the Sheet ID and the Cell IDs of the data you want to display. Optionally, you can add titles for each value, which will appear in the widget for clarity. 1. Find the Sheet ID: This is the long string of characters in your Google Sheets URL (without the dashes). 2. Set Sharing Permissions: Make sure the sheet is set to “Anyone with the link” and read-only to allow Shwidget to fetch the data securely. Once you’ve set these up in the app, Shwidget takes care of the rest. The widget will automatically update at regular intervals thanks to iOS’s background system. PRO TIPS * How to Find the Sheet ID: Open your Google Sheet, and the ID is the long string of random characters in the URL between the slashes. For example:
https://docs.google.com/spreadsheets/d/1CMvaCWBAsrAftZjT5nXlntTUsnmkkZDlxMkXhAd_sBs/
In this case, the Sheet ID is: 1CMvaCWBAsrAftZjT5nXlntTUsnmkkZDlxMkXhAd_sBs.
 Paste only this ID into the Shwidget app. (Tip: Double-check you’re not copying the entire URL!) * Sharing Permissions: Ensure your sheet’s general access is set to “Anyone with the link” and role set to “Viewer” to allow Shwidget access without making unnecessary changes to your security settings. * If your widget says "ERROR empty cell?" Then the cell is empty OR sharing is not properly done OR typo in the cell field. Trust me, its one of these. * Data Privacy: If you’re concerned about sharing sensitive data, consider creating a “proxy” spreadsheet and use Google Sheets’ IMPORTRANGE function to pull only the necessary data into a separate sheet that’s shared with Shwidget. EXAMPLE SETUP Test Shwidget with the example sheet below:
Sheet ID: 1CMvaCWBAsrAftZjT5nXlntTUsnmkkZDlxMkXhAd_sBs
 Try cell IDs like D1, D2, D3 or E1-E7, and open the sheet to see the expected values. FREE vs PRO The free version of Shwidget lets you add one row or data field per widget. To unlock more rows, upgrade to the KPI Lover subscription for expanded functionality. The free version also includes a logo on the home screen widget and a subject text on the lock screen widget, which you can remove by subscribing. No hidden fees, no gimmicks — just more features and a cleaner experience! Cheers, Mikko 
P.S. Your feedback is always welcome! Drop me a line at mikko_a_appsipaja.fi. Terms of use, standard Apple Terms of Use (EULA): https://www.apple.com/legal/internet-services/itunes/dev/stdeula/

Turn Google Sheets into widgets for your iPhone Home Screen and Lock Screen. Check budgets, work shifts, schedules, sales, stock and project progress without opening your spreadsheet. Sheet Widget displays the cell ranges you choose, preserving borders, background and text colors, bold text and merged cells. HOME SCREEN Choose small, medium, large or extra-large widgets. Display tables, formula results and images from supported IMAGE formulas. Available sizes depend on your device and iOS version. LOCK SCREEN • Above the clock: show a single cell, such as your next appointment. • Circular: show one cell, with a gauge for percentage values. • Rectangular: display a table from your selected range. Create configurations in the app and choose which one each widget displays. Multiple configurations require Pro. NO PUBLIC SHARING REQUIRED Keep your spreadsheet private. You do not need to publish it to the web, create a sharing link or write scripts. Sign in with Google, select a spreadsheet and sheet, choose your cells or range, then add a widget. Tap a widget to open the spreadsheet or app. FREE FEATURES • One Home Screen configuration and one Lock Screen configuration. • Tables with borders, colors, bold text and merged cells. • Preserve cell proportions. • Formula results and supported IMAGE pictures. • Automatic updates and tap-to-open actions. MORE WITH PRO • Unlimited widget configurations. • Supported line, bar, pie and other charts. • Notifications when values, formatting or borders change in the displayed range. • Switch between multiple Google accounts. • Copy a tapped cell’s value, then open your chosen destination. • Nine theme colors plus custom colors. • Nine background presets plus custom RGB colors. • Request fresh data with the refresh button. • Hide the Sheet Widget watermark. • Show or hide the header and footer. Choose a monthly, yearly or lifetime plan. Eligible customers can try the yearly plan free for 7 days. Prices and trial eligibility are shown on the purchase screen. PRIVACY We do not use our own server to store your sheet contents. Authentication credentials are protected on your device using Keychain. No ads or tracking. UPDATES AND NOTIFICATIONS iOS manages automatic widget updates, so refresh intervals vary. Changes and notifications may take time to appear. Real-time updates are not guaranteed. Keep the spreadsheet you check every day where you can see it at a glance. Terms: https://sheetwidget.com/terms/ Privacy: https://sheetwidget.com/privacy/ Support: sheetwidget@gmail.com