← All guides

Getting started

How to Put Google Sheets Cells on Your iPhone Home Screen

Published by OneCell

You can put selected Google Sheets values on your iPhone Home Screen with OneCell. Connect a spreadsheet, choose the cell or range, save a widget design, then add OneCell through the iPhone widget gallery. This guide starts with one cell so you can check the result before building a larger dashboard.

What you need

  • An iPhone with OneCell installed.

  • A Google account that can open the spreadsheet you want to display.

  • Active OneCell Pro access, including an eligible active trial. Creating a widget requires Pro; downloading the app alone does not unlock widget creation.

Download OneCell for iPhone, then sign in. Connecting your Google Sheets account is a separate step from signing into OneCell.

1. Make a small example sheet

Create a Google spreadsheet called Widget demo and rename its first tab Dashboard. Enter these fictional values:

  • A1: Metric

  • B1: Value

  • A2: Orders this week

  • B2: 42

The expected value for the widget is 42. Keep the label in A2 for reference, but select only B2 for this first Big Number widget. That makes it easy to tell whether you have chosen the right cell.

2. Connect the spreadsheet

  1. In OneCell, open My Widgets and tap the + button.

  2. Choose Connect Google Sheet. If Google Sheets is not already connected, tap Connect.

  3. If prompted, complete Google authorization using the account that can access Widget demo. If an account is already connected, check that it is the correct one.

  4. Select the spreadsheet, then its Dashboard tab.

  5. Tap Pick range.

This connection supports private spreadsheets: you do not need to make the file available to anyone with its link. The Google permission request includes read-only Sheets access and Drive file metadata access. Choosing a range controls what the widget displays; it does not restrict that authorization to a single cell.

Paste Sheet Link is a different source option. It requires the spreadsheet to be shared as Anyone with the link → Viewer. Use the Google connection above when you want to keep the file restricted.

3. Select the value and design the widget

In the range picker, enter B2 in the range field, then submit it or leave the field to apply the selection. Confirm that SELECTED shows B2, then tap Design widget. Typing the reference avoids accidentally selecting a larger range.

Choose Big Number, which displays the first selected cell. Set the label to Orders this week, choose a size and theme, and check that the preview shows 42. For an introductory setup, a single numeric cell is easier to verify than a large table.

Enable the last-refreshed timestamp if you want an indication of data freshness. Tap Add to home screen. This saves the OneCell configuration and opens placement instructions. It does not place a widget on your iPhone automatically. If a paywall appears, widget creation needs active Pro access.

4. Place OneCell on your Home Screen

  1. Touch and hold an empty area of the iPhone Home Screen until the apps jiggle.

  2. Open the widget gallery. On current iOS versions, use Edit → Add Widget; older versions may show a + button.

  3. Find OneCell, choose a size, and add it.

  4. Touch and hold the placed widget, choose Edit Widget, and select the saved Orders this week configuration.

  5. Tap outside the widget to finish.

Apple’s widget instructions explain the system controls. Menu wording can vary by iOS version. Saving a design in OneCell and selecting that design on the Home Screen are separate parts of setup.

5. Check the result and understand updates

The expected value is 42. Change B2 in Google Sheets to 43. After a successful data refresh and widget update, the widget should show 43. Editing the spreadsheet does not guarantee an immediate Home Screen change.

OneCell’s refresh setting requests updates, while iOS controls widget scheduling and its refresh budget. Network access and Google authorization also affect whether fresh data can be fetched. Apple explains this behavior in Keeping a widget up to date. Treat the widget as a glanceable display, rather than a second-by-second monitor.

If the wrong value appears

  • The spreadsheet is missing: check the connected Google account and confirm that it can open the file. The connection screen provides a Change control for switching accounts.

  • The preview shows a label: check Dashboard and B2. Selecting B1 would display the header instead.

  • B2 is blank: put 42 back in B2 for this practice example and reload the preview. An empty source cell has no number to display; changing the widget label does not fill the sheet.

  • The Home Screen shows another metric: open Edit Widget and choose the correct saved configuration.

  • The value is old: check the source value, connection status, and any displayed refresh time before changing the range. A delay alone does not prove the selection is wrong.

Once the practice value works, use a cell from your own sheet and give the widget a label that tells you what the number means. Keep the sheet, tab and cell reference together so you can check the source when the number looks unexpected.

Ready to try the example? Download OneCell for iPhone and start with Dashboard!B2. Widget creation requires active Pro access, including an eligible active trial.

Explore all guides →