How to turn Google Sheets data into a video

Prepare a sheet the connector can read

The current connector uses an API key configured by the service operator. It reads sheets accessible to that key, normally a public or shared-read sheet. It does not sign into your private Google account or request OAuth access.

Use a separate sheet containing only the data you intend to publish. Share that sheet for reading as required; do not expose private business or personal data just to make a video. The Google Sheets documentation explains spreadsheet IDs, sheet tabs and A1 ranges.

Choose a table or a time series

For cards, use a row per entry with a name and a numeric value. An optional subtitle adds context. For a time series, place periods in the first column and numeric series in the following columns, with a header row.

Import and check the mapping

1. Open the data-source picker in the Studio and select Google Sheets.
2. Paste the spreadsheet ID and an A1 range such as Sheet1!A:C.
3. Select the row or time-series feed, map the intended columns, and preview the project.
4. Check the values, units and title. Save the project, choose its visual style, and generate the video.

Refresh a saved project

The imported project retains its provider, range and field mapping. A supported scheduled project can refresh that recipe and skip rendering when the data content has not changed. Scheduling depends on the account plan.

A successful import says that the connector read the sheet. It does not verify the truth of the underlying numbers. Keep the sheet’s formulas and definitions auditable, and inspect a refreshed preview when the structure changes.