How to use Google Sheets in a metric
Add Google Sheets data to journey-map metric cards by picking a spreadsheet, sheet, and the columns to plot.
Turn a column of values in a Google Sheet into a live chart or number on any journey map.
Add a Google Sheets metric
You can create a Google Sheets metric from two places:
From the workspace Metrics tab - Click Metrics in the sidebar, then + Create metric. The full-page Add metric form opens.
From a journey map - Click + Add card on a card slot and pick Metric under Advanced cards. In the Add metric picker, pick an existing metric or type a name and click Create. The metric opens in a compact modal; use Full screen view to switch to the full-page form.
The steps below walk the workspace-tab flow because the full-page form shows every field on screen. The journey map modal has the same fields in a more compact layout.
Name the metric and pick Google Sheet as the source
Type a name that describes what the metric shows (for example, New users by week). In Source, pick Google Sheet. The source list labels this option in the singular, Google Sheet, even though the integration itself is Google Sheets.

If you see a setup-required block below the Source field instead of the Sheets fields, the integration isn't connected for this account yet. Follow How to set up the Google Sheets integration before continuing.
Pick the metric type
Open the Type dropdown and pick Series, Number, or Comparison. The fields below depend on this choice. A Series plots a column of values as a chart, a Number shows a single headline value, and a Comparison sets two values against each other. The steps below walk a Series, the most common choice for sheet data.
Choose the spreadsheet and sheet
Click Select file under Spreadsheet and choose the Google Sheet to pull from. Then open the Sheet dropdown and pick which tab inside that file to read.

Map the columns to the chart
Turn on Make top row headers if the first row of the sheet holds column names, so Smaply reads row 1 as headers rather than data. The Data label and Data values dropdowns then list columns by name.
Pick the column for the chart's categories under Data label (for example, a
Weekcolumn).Pick the numeric column to plot under Data values (for example, a
Userscolumn).
For a field-by-field reference, see Field mapping below.
Set which rows to pull
Under Number of rows, set how many rows to read from the sheet. The maximum is 50.
Leave Select bottom rows off to read from the top of the sheet down. Turn it on to read the last rows instead, which is how you grab the most recent entries when new data is appended to the end of a long sheet.
Pick chart options and save
In the Default card preview panel on the right, pick a default chart type from the chip strip and add an optional Chart heading and Chart subheading. The preview updates as you change the selections. These are the defaults for new cards built from this metric; each card can override them on a journey map. For the full chart-options reference, see How to create and configure a metric.
Click Save. The metric appears in the workspace Metrics list and is ready to drop onto any journey map as a metric card.
Field mapping
Each field in the Add metric form points at part of your sheet. Work down the form in order, since the column dropdowns only list names once the spreadsheet, sheet, and header setting above them are set.
Spreadsheet - The Google Sheet file to pull from. Click Select file to choose it.
Sheet - The tab inside that file to read. A spreadsheet can hold several sheets, so pick the one with your data.
Make top row headers - Turn on when the first row holds column names. Smaply then treats row 1 as headers and lists your columns by name in the two fields below, rather than reading row 1 as data.
Data label - The column whose values become the categories on the chart (the x-axis on a bar or line chart, the slice labels on a pie chart). Example: a
Weekcolumn with values like Week 1, Week 2, Week 3.Data values - The numeric column whose values get plotted. Example: a
Userscolumn with the count per week.Select bottom rows - Off reads rows from the top of the sheet; on reads them from the bottom. Use it with Number of rows to grab the most recent entries when new data is added to the end of the sheet.
Number of rows - Caps how many rows the metric pulls. Maximum 50.
Refresh behaviour
Google Sheets metrics refresh on access. When you open the workspace Metrics section or a journey map containing the metric, Smaply pulls fresh values if the last update was more than about an hour ago. Data under an hour old isn't re-pulled, and there's no manual refresh button. The next time you open the metric or its map brings the values up to date.
The metric reflects whatever the sheet held at the last pull, so an edit you just made in Google Sheets shows up on the next on-access refresh once the hour window has passed.
Troubleshooting
If the connection itself isn't working, see How to set up the Google Sheets integration for connection troubleshooting. The issues below cover data-side problems once the connection is in place.
For wider questions about how integrations behave across tools (refresh frequency, switching auth, what happens on disconnect), see How to manage integrations.
Related topics
Last updated