Google's collaborative spreadsheet editor in the browser

How to Record Google Sheets

Record Google Sheets at 150% zoom with frozen headers. Guide for formula tutorials, dashboard walkthroughs, and Apps Script demo recordings.

When you’d need to record Google Sheets

Formula and function tutorials

Record QUERY, IMPORTRANGE, ARRAYFORMULA, and Google Sheets-specific functions. Sheets has unique functions not in Excel — tutorials need to show the formula bar, cell references, and live results.

Dashboard and report walkthroughs for teams

Walk colleagues through a shared spreadsheet — where to input data, which cells update automatically, how to use data validation dropdowns. A 3-minute recording prevents weeks of 'how does this sheet work?' messages.

Apps Script automation demos

Record Google Apps Script running inside Sheets — show the script editor, run the function, show the result in the sheet. Script demos need both the code and the spreadsheet visible.

Data import and API integration tutorials

Record IMPORTDATA, IMPORTHTML, or connected Sheets pulling data from BigQuery. Show the function, the live data refreshing, and how to structure the output. These integrations are hard to explain without seeing them run.

Recommended settings

Resolution

2560x1440

Frame rate

30fps

Audio

Microphone only

Capture mode

Window Capture

Things to know

•Google Sheets cell text is smaller than Excel's default — 10pt Arial renders tiny on video
•Collaborator cursors highlight entire cells with colored borders and name labels — other editors are visible
•The sheet tab bar at the bottom shows all sheet names, which may reveal data categories you don't want public
•Google Sheets recalculates formulas live — complex sheets may show brief #LOADING or #REF errors during recording

Step-by-step

1
In Screenify Studio, select Window Capture and pick the Google Sheets window.
Record at 1440p if possible — Sheets' small text benefits from higher resolution more than most apps.
2
Open Google Sheets. Increase the zoom level immediately: View > Zoom > 125% or 150%. Google Sheets defaults to 100% with 10pt Arial, which is unreadable in any recording. This is step zero.
3
Freeze header rows: select row 2, then View > Freeze > 1 row. When you scroll through data, the header stays visible so viewers always know which column is which.
4
Check the sheet tab bar at the bottom. Tab names like 'Salary Data,' 'Confidential Projections,' or 'Client List' are visible. Rename sensitive tabs or right-click > Hide Sheet before recording.
5
Start recording. When clicking a cell with a formula, look up at the formula bar and point it out. Google Sheets' formula bar is narrow and easy to miss — viewers need verbal direction: 'notice the formula bar shows ARRAYFORMULA here.'

For Apps Script and data integration demos

6
For Apps Script demos, open the script editor: Extensions > Apps Script. This opens in a new tab. Arrange the Sheets tab and the Apps Script tab side by side using Split View, or record them sequentially — show the code, explain it, switch to the sheet, run the script, show the result.
7
When demonstrating QUERY function, type the formula in stages. First the basic SELECT, run it. Then add WHERE, run it. Then ORDER BY. Building up the QUERY clause-by-clause teaches the syntax instead of dumping a 200-character formula at once.
8
For connected Sheets (BigQuery), show the Data > Data connectors > BigQuery flow from the beginning. The connection setup has multiple steps (project, dataset, table, query) — each needs screen time.

Pro tips

Auto-zoom on the formula bar. Google Sheets' formula bar is a single line of 12px text at the top of the screen. Formulas like `=ARRAYFORMULA(IF(A2:A="", "", VLOOKUP(A2:A, Data!A:C, 3, FALSE)))` are unreadable at normal zoom. Auto-zoom catches your click and zooms in.

150% zoom is the minimum for Sheets. Google Sheets with 10pt Arial at 100% zoom is the least readable of all apps in this category. At 150%, cell values become comfortable to read on video. At 100%, they're gray dots on a grid.

Freeze panes before recording. Scrolling through 1,000 rows without frozen headers means viewers see numbers with no column context. Freeze row 1 (headers) and optionally column A (row labels). View > Freeze.

Build formulas incrementally. Don't paste a 200-character formula and explain it. Type the inner function first, press Enter to verify it works, then wrap it in the next function. This builds-up approach teaches the formula logic, not just the final syntax.

Common mistakes

Recording at 100% zoom. Google Sheets' default font (10pt Arial) at 100% zoom is the #1 reason Sheets tutorials fail. After video compression, cells become a grid of unreadable gray text. Zoom to 150% minimum. Every time.

Not freezing header rows. You scroll to row 500 and start explaining values. Viewers see numbers in columns they can't identify because the header row scrolled off-screen 400 rows ago. Freeze it.

Exposing sensitive sheet tabs. The bottom tab bar shows every sheet in the workbook: 'Revenue FY2026,' 'Employee Salaries,' 'Churn Analysis.' Right-click > Hide Sheet on any tab you don't want in the recording.

Showing collaborator activity. Other editors' cursors highlight cells with colored borders and their full names. If someone is editing the 'Salary' column while you're recording a formula tutorial on a different sheet, their activity is still visible in the collaborator count. Ask others to close the sheet during recording.