Skip to main content

Google Sheets

The Google Sheets add-on exposes spreadsheet data as a source for the Creative Builder's dynamic text layers. Point a text layer at a cell range and the creative updates automatically as the spreadsheet changes — perfect for live pricing, menus, leaderboards, or any data you maintain in a sheet.

Two ways to connect​

  • Public CSV URL — connect a publicly shared CSV link. No authentication required; great for simple, published spreadsheets.
  • Private spreadsheet (OAuth) — connect a private Google Sheet via OAuth for secure access to data you don't want to publish publicly.

You can use both at the same time, mixing public and private sources across different creatives.

Set up a connection​

  1. Enable the Google Sheets add-on for your team.
  2. Choose the access mode(s): public CSV URL, OAuth private, or both.
  3. For OAuth, connect your Google account.
  4. Set an optional auto-refresh interval (in minutes) so creatives pick up spreadsheet changes automatically.
  5. Save.

Use sheet data in a creative​

  1. Open a creative.
  2. Add a Dynamic text layer.
  3. Bind it to a connected spreadsheet and the relevant cell/range.
  4. Style and position the layer as normal.
  5. Preview to confirm the data renders, then publish.

The published creative will refresh its data on the interval you configured, so on-screen text stays in sync with your spreadsheet.

Per-site access controls​

You can control whether public and/or private access is available at each site, so a location with sensitive data can be restricted to OAuth-only connections while another uses public CSVs.