Show a piece of a Google Spreadsheet document on Andriod main screen

Question

I have a Google Spreadsheets document that is frequently updated and there are some cells in it that show a kind of short summary. Let it be a 2x2 block of cells that contains two headers and two values. I want to see those cells on the main screen of my Android 6 device as a widget to be able to check those values at a glance without actually opening the Spreadsheets app.



Is there any relatively simple way to get this result? A page of code on Google Apps Script and/or some tricky use of IFTTT maybe?


— Helyrk | Sources

Answer

Many thanks to beeshyams. Here is a way to do what I wanted.



This app allows to parse chosen content from any web page and use it as a widget. In order to have a Spreadsheets document as a web page one can publish it (File → Publish to the web...). The cells of interest can be linked from another page of this document (or even from another document) using formulas like =Sheet1!A1 so that the page being published would only contain what is expected to appear on the widget.



For now the widget I produced looks poor but there are plenty of customization capabilities including regexps and CSS so probably I will be able to tweak it according to my likings.


— Helyrk | Sources

Q & A

Android device load process (preparing flashing)
Android 7 Nougat onwards: hides USB OTG sticks from third-party file managers?
Take notes, and enter into a Google Docs spreadsheet using Google Assistant.
Is there a way to completely disable all Bixby functionality without rooting the S9+?
Are lower-end phones just as moddable as flagships?
Install Bash on Samsung Galaxy Grand Prime+
How to open a file located in a non-sdcard directory in Tasker?
Google calendar force closing after OTA update (SM-G930A)
Importing the Telegram contacts into the phone book - Android
How does android dm-verity protection validate blocks with hash tree
How to completely clear my device of a particular company's apps?
Flashed BTU from sammobile but is still EVR
Does GBWhatsapp's back up feature restore media/images INSIDE all the chats?
How to install apps with adb shell and how to backup device settings and restore to an identical device?
How do I enable SEANDROID ENFORCING over adb inside TWRP?
How to export a list as Text of all Play Store Apps that I have ever installed
Google Play Services only recognizes deleted account; cannot update any apps
Get N on screen when trying to access developer options
How many mmcblk devices is normal?
Does LineageOS provide "Zip Signature Verification"

Topics

2D Engines   3D Engines   9-Patch   Action Bars   Activities   ADB   Advertisements   Analytics   Animations   ANR   AOP   API   APK   APT   Architecture   Audio   Autocomplete   Background Processing   Backward Compatibility   Badges   Bar Codes   Benchmarking   Bitmaps   Bluetooth   Blur Effects   Bread Crumbs   BRMS   Browser Extensions   Build Systems   Bundles   Buttons   Caching   Camera   Canvas   Cards   Carousels   Changelog   Checkboxes   Cloud Storages   Color Analysis   Color Pickers   Colors   Comet/Push   Compass Sensors   Conferences   Content Providers   Continuous Integration   Crash Reports   Credit Cards   Credits   CSV   Curl/Flip   Data Binding   Data Generators   Data Structures   Database   Database Browsers   Date &   Debugging   Decompilers   Deep Links   Dependency Injections   Design   Design Patterns   Dex   Dialogs   Distributed Computing   Distribution Platforms   Download Managers   Drawables   Emoji   Emulators   EPUB   Equalizers &   Event Buses   Exception Handling   Face Recognition   Feedback &   File System   File/Directory   Fingerprint   Floating Action   Fonts   Forms   Fragments   FRP   FSM   Functional Programming   Gamepads   Games   Geocaching   Gestures   GIF   Glow Pad   Gradle Plugins   Graphics   Grid Views   Highlighting   HTML   HTTP Mocking   Icons   IDE   IDE Plugins   Image Croppers   Image Loaders   Image Pickers   Image Processing   Image Views   Instrumentation   Intents   Job Schedulers   JSON   Keyboard   Kotlin   Layouts   Library Demos   List View   List Views   Localization   Location   Lock Patterns   Logcat   Logging   Mails   Maps   Markdown   Mathematics   Maven Plugins   MBaaS   Media   Menus   Messaging   MIME   Mobile Web   Native Image   Navigation   NDK   Networking   NFC   NoSQL   Number Pickers   OAuth   Object Mocking   OCR Engines   OpenGL   ORM   Other Pickers   Parallax List   Parcelables   Particle Systems   Password Inputs   PDF   Permissions   Physics Engines   Platforms   Plugin Frameworks   Preferences   Progress Indicators   ProGuard   Properties   Protocol Buffer   Pull To   Purchases   Push/Pull   QR Codes   Quick Return   Radio Buttons   Range Bars   Ratings   Recycler Views   Resources   REST   Ripple Effects   RSS   Screenshots   Scripting   Scroll Views   SDK   Search Inputs   Security   Sensors   Services   Showcase Views   Signatures   Sliding Panels   Snackbars   SOAP   Social Networks   Spannable   Spinners   Splash Screens   SSH   Static Analysis   Status Bars   Styling   SVG   System   Tags   Task Managers   TDD &   Template Engines   Testing   Testing Tools   Text Formatting   Text Views   Text Watchers   Text-to   Toasts   Toolkits For   Tools   Tooltips   Trainings   TV   Twitter   Updaters   USB   User Stories   Utils   Validation   Video   View Adapters   View Pagers   Views   Watch Face   Wearable Data   Wearables   Weather   Web Tools   Web Views   WebRTC   WebSockets   Wheel Widgets   Wi-Fi   Widgets   Windows   Wizards   XML   XMPP   YAML   ZIP Codes